I have declared Environment Variables SERVERNAME,USERID and PASSWORD.
When I use them in my Data Stage job as #$SERVERNAME#,#$USERID# and #$PASSWORD#, I am getting the following error message
DB2_UDB_API_2,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009
Unable to connect to DB2 server '#DSCAPIOP__SERVERNAME#'.
Could anyone help me on this?
Regards
Prasanna
Environment variable Issue
Moderators: chulett, rschirm, roy
Environment variable Issue
We are using DB2 API stage. Configuration has been set properly. When I use those Environmental variables I am able to view the data from Datastage in DB2 source. But no records are passing to target.