environment variable in the DSJOB.EXE

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 6:39 am

I AM USING THE COMMEND DSJOB.EXE
i am using in my job --environment variables.
i am passing parameters from the commend prompt. please see below.
environment variaable:$PATH.
some times i need to change the parameter value.

C:\Program Files\Ascential\DataStage7.5>dsjob.exe
-server SERVERNAME
-user RAJU
-password RAJUPASSWORD
-run
-mode NORMAL
-param $PATH="\\10.111.111.23RAJ\Source TGT -230907_FILE.txt"
PROJECTNAME FIRSTJOB1
when i click enter
status code = 0

But iam checking in the director showing the fatal error

FIRSTJOB1..Transformer_20: |FIRSTJOB1.sourcwe.DSLink14: DSD.SEQOpen Failed to open .txt in directory \\10.111.111.23\RAJ\Source TGT -230907_FILE.txt"
STATUS = 2.|

can any one help me please

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 6:40 am

FYI....

I AM USING THE COMMEND DSJOB.EXE
i am using in my job --environment variables.
i am passing parameters from the commend prompt. please see below.
environment variaable:$PATH.
some times i need to change the parameter value.

C:\Program Files\Ascential\DataStage7.5>dsjob.exe
-server SERVERNAME
-user RAJU
-password RAJUPASSWORD
-run
-mode NORMAL
-param $PATH="\\10.111.111.23\RAJ\Source TGT -230907_FILE.txt"
PROJECTNAME FIRSTJOB1
when i click enter
status code = 0

But iam checking in the director showing the fatal error

FIRSTJOB1..Transformer_20: |FIRSTJOB1.sourcwe.DSLink14: DSD.SEQOpen Failed to open .txt in directory \\10.111.111.23\RAJ\Source TGT -230907_FILE.txt"
STATUS = 2.|

can any one help me please

chulett · Post by **chulett** » Thu Jun 28, 2007 6:47 am

Besides the fact that you would not want to set your PATH statement to that particular value, you wouldn't do that as part of the dsjob command. $PATH is reserved, I'd suggest you use a different name if you need a 'file path' variable.

Wrapper your dsjob call in a script. Set the variable there before you call dsjob.

Is your full filename correct? Do you have permissions to that UNC path?

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 6:48 am

i gave $TEST_PATH
Sorry i did not mension that one.

chulett · Post by **chulett** » Thu Jun 28, 2007 6:53 am

Ok... then answer my last two questions.

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 7:04 am

1. i tried with out environment variable.
i gave a local parameter with in the job and also parameter value.
but when we run from the commend prompt i changed the parameter value. that is working fine.

i tried same systax in the using enviroment variables.
i have permsision to the directory and also file.

2. i dont want to add too many calling values.

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 7:18 am

Can any one help me please

ray.wurlod · Post by **ray.wurlod** » Thu Jun 28, 2007 7:23 am

Don't use file names or pathnames that contain space characters, or add another layer of quotes.

Try using forward slashes rather than backslashes within the pathname.

suresh_dsx · Post by **suresh_dsx** » Thu Jun 28, 2007 7:30 am

i tried all the possibilites
not working still getting the same error.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 28, 2007 1:25 pm

Please list the names, types and default values of the job parameters in the job in question (FIRSTJOB1).

suresh_dsx · Post by **suresh_dsx** » Mon Jul 02, 2007 4:55 am

Hi ray

Here is the list of values.

I created environment variable in the administrator:
Parameter name: TEST_PATH
Type: String
Value:"\\10.111.111.23\RAJ\Source TGT -230907_FILE.txt"

i used the environment varable in the job.
PARAMETER NAME: $TEST_PATH
PROMPT:ENTER THE PARAMETER
TYPE:STRING
VALUE:"\10.111.111.23\RAJ\Source TGT -230907_FILE.txt"

ray.wurlod · Post by **ray.wurlod** » Mon Jul 02, 2007 9:11 am

In the job change the default value to $PROJDEF

This instructs the job to read the value from the Administrator, unless overridden when the job is submitted.

Once you've done this, you only need a -param option in dsjob if you want it to run with a different value than the default.