DSXchange

Can you post the routine so that we can try to see whats going on and possible try to pin point the culprit.

Ofcourse they do. How exactly are you typing it in ?

Ray, is RMM stage part of the IBM Integration Server

you can also do it in the command prompt using the dsjob command

This is right out of dsbooks -> Plugin Documentation -> DB2/UDB API Stage (page 14) If the property value begins with {FILE}, the remaining text is interpreted as a pathname, and the contents of the file supplies the property value. Provided you have 7.5.1A. If you have any other version then i am n...

Welcome Aboard,
Specify the keyword {FILE} before giving the fully qualified path for the sql file. That should do the trick.

check out this post.

I am sure, for testing purposes just create a simple routine with one arg and paste either mine or kumar's solution there. Test it there. You will see that they both work. Try loading it to a sequential file. What database are you loading it too. For most databases, the date format is YYYY-MM-DD Try...

For db2 its just db2 then you go ahead with 'connect to blabla user blabla using blablabla'. But for that he needs to setup the environment first. Like how for oracle you need to run the . ~oracle/92.env file first. Similarly there is a db2 env file that needs to be executed first. But that referenc...

Kumar, you want the poor fellow to get in trouble with his DBA ?

ArndW is right. That option will work.
You can also try

Why dont you add that info in the dsenv file. This way whenever datastage runs, the db2 environment will also be set.
You can also source that file directly by providing the fully qualified path name in the cmd of the execute command activity.

Try this result.

tiozzo wrote:Can a few more gurus confirm what DSguri2b is saying is true?

DSguri ???
Dude, you made me a female

I get what his DBA is wanting. Correct me if i am wrong tiozzo, your dba wants your database stage to point to a connection file and dynamically pick up the username and password from there. Tell him its out of the scope of this tool. Such a file does exist, the uvodbc.config and .odbc.ini files. Th...