DSXchange

Hi All,
How could I pass DSN name, User ID and Password to DS jobs(specifically ODBC stages). Or read a connection string having UserID, Password and DSN name so that these are not hardcoded in the stages.
Sample codes/references will be of great help.
Thanks in advance.
Nilotpal.

Have you tried #DSN# for your DSN box, #UserId# for your UserId and #PassWord# for your password. In you Job Property, create these parameters DSN, UserId, and PassWord. You also need to have DSN setup at the DataStage server. I believe it works, try it.


Leonardo