db2 export via aix
Posted on 2012-08-14
Below script works perfect but i want to do some changes
1) using abc second line is password i want to encrypt it and call it as parameter
2) "/opt/aa/ third and fourth line i want this call in parms too
How can i convert this script to parameters and also what will execute command to call
# exports data into IXF file.
db2 connect to autod user mkt_dbo using abc;
db2 EXPORT TO "/opt/aa/abc.ixf"
OF DEL MESSAGES " /opt/aa/abcerror.txt"
SELECT aa FROM aa.kk where 1=1 with ur;
db2 connect reset