DSXchange

I don't know what's going on...The code which worked few hours before is not working now... Even this small piece of code is not working now...I just have the following code in a test routine...which does not give me the output... Call DSExecute("UNIX","echo $prm_project_path",Un...

Value of $prm_project_path is /datastage/dev/srcdev/ and value of $prm_path_common is common/. It's all just directories in AIX.

So value of the the HashFilePath is /datastage/dev/srcdev/common/

Thanks

Thanks for the response. Arnd - This is the code I am using to get the env variables... Call DSExecute("UNIX","echo $prm_project_path$prm_path_common",UnixOutput,SystemReturnCode) HashFilePath = Trim(UnixOutput) DSGuru - I am getting the same error when I tried your second mathod...

Hi I am trying to use environment variables in Routine(Transform Function). I got some idea from this forum as to use echo statements to get the env values and I use modified UtilityHashLookup Routine to read. It works fine If I hard code the path of hash file like following HashTable=/dir/dir/dir/T...

Hi Source is Sequential file Target is DB2UDB table AIX server We have to insert huge amount of records(70 millions) as part of the initial load into a table. If the Target table is partitioned is there any way to route the records using DataStage to particular partition in DB2UDB database. Target t...

It's not letting me to enter DSExecute instead of ExecSHsilent in Rotine Name. Do you want me to put DSExecute in Input Arg of Routine Activity ?

Thanks

Kumar - I am not using DSExecute. I am using ExecShSilent in Routine Activity of Sequence job and giving the script name in InputArg.

Where do you want me to use DSExecute ?

Thanks

Craig - Yes. I am using the samething...

"In Routine1's trigger - custom(conditional) and expression as DSJS.RUNWARN"

Kumar - I tried ReturnValue. It does not work...Is ReturnCode different from ReturnValue ?

Thanks

DSGuru,
It's not working...It's Aborting the job even there is no warnings in Routine1...
How can check using the return value of the Routine ?

Thanks

Oops...I got it wrong...Thanks for the clarification...

OK...If I am not doing the right thing can you tell me what should be the correct way of doing this.

I have tried the following in custom value of the Routine1 but it's not aborting the job.

RA_Fld_Lvl_Change.$ReturnValue="88"

Thanks

Craig, Thanks for the quick reply. I have done it like this. Just want to make sure is thats what you meant... Routine1 ---> Routine2 In Routine1's trigger I am using custom(conditional) and expression as DSJS.RUNWARN. In Routine2 I am calling UtilityAborttoLog and Arg1 as DSJS.RUNWARN. It works...B...

Hi

I am executing a shell script from Routine Activity sequence. When the shell scripts fails I am exiting with a non-zero value(say '88') which creates a warning message on the DataStage job log. I would like to get the FATAL error instead of Warning Message in the logs ? How can I do that ?

Thanks

Check the maximum limit of the messages which the queue can hold.
Your queue must have filled up. Either you need to increase the queue size or delete the messages as soon as you read and stores somewhere.

Thanks

Thanks for the reply...we are on the same track as Deepak suggested. will let you know...