?
Solved

db2 export via aix

Posted on 2012-08-14
2
Medium Priority
?
674 Views
Last Modified: 2012-08-22
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/db2profile

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
0
Comment
Question by:sam2929
2 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 38294544
the connect command wont accept an encrypted password
do you want to decrypt it in the script?
0
 

Author Comment

by:sam2929
ID: 38294586
ok can i pass it as parms then
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Screencast - Getting to Know the Pipeline
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question