DSXchange

Thanks for your reply. However I'm not sure I gave enough information or I'm not understanding. We have an initial db2 connector that is using the job properties to connect to a specific database with user and pass. Within that db2 connection stage we have sql query to pull database and table names ...

Is it possible to pull data from a db table (schema name and table name) and then feed this info to populate the connection properties of a second DB2 stage? I have tried to find ways to also update the global variable with this info. Any suggestions would be appreciated.

I am unable to change the password from variable to string. The password is controlled by the security group and the developers are not allowed to know or have the password.

version of DS 7.5.1

I am using the following variables: #$HRDMPassword# #$HRDMUser# #$HRDMPROD# The error message i am getting is: testedwdev..DB2_UDB_API_0: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08...

Any suggestions would be appreciated. Have a simple server job that does a sql select statement to view rows in a table. If I run the job with the Server Name, User ID and password hardcoded, it works fine. However the minute I put the environment variables in and update the job parameters the job f...