sam2929
asked on
db2 export via aix
Hi,
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
parameters
#
# exports data into IXF file.
. /db2_src/db2rind/sqllib/db 2profile
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
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
parameters
#
# exports data into IXF file.
. /db2_src/db2rind/sqllib/db
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER