dsjob -run

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
OddJob
Participant
Posts: 163
Joined: Tue Feb 28, 2006 5:00 am
Location: Sheffield, UK

Post by OddJob »

Why are all of your params like...

-param prmDbSrcName=prmDbSrcName
i.e.
ParamName=ParamName
?

You should be using -param prmDbSrcName=<Name of Dd Source>,
-param prmDirSrcFile=<actual directory of source file> etc, etc
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

To take part of your command line, "-param prmDbSrcName=prmDbSrcName " means that your Oracle instance name is "prmDbSrcName" which I doubt is what you wanted to specify. What are you trying to do - use environment values, i.e. "-param prmDbSrcName=$prmDbSrcName"
arnabdey
Participant
Posts: 50
Joined: Wed Jan 10, 2007 5:56 am

Post by arnabdey »

Hi
Probably you are correct. You need to set dsenv. Please ensure that you have set the following environment variables ORACLE_HOME, ORAHOME, ORACLE_SID, ORASID, LD_LIBRARY_PATH/LIBPATH properly first. Also review the database credentials you provide.
Thanks
Arnab
Post Reply