Environment variable Issue

mspanda · Post by **mspanda** » Mon Jul 09, 2007 1:22 am

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

mspanda · Post by **mspanda** » Mon Jul 09, 2007 5:56 am

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.