Passing Parameters

nilotpalr · Post by **nilotpalr** » Mon Jun 03, 2002 1:26 am

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.

DSGuru · Post by **DSGuru** » Fri Jun 07, 2002 11:59 am

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