DSXchange

Hi All

How can we list out all the jobs present in a DataStage Project?
Are any way there to generate an excel/doc containing all the job names in a particular project?

Hi,

I have join two tables based on id columns using JOIN stage.

There are some reject means after joining two table some records are not satisfying the joining criteria . I would like to capture those records.
Any tips how to handle the rejects after joining?

Hi,

I need to enter null in a column(integer) in a sequential file. When I try to do this the value entering is 0.
Also, if possible please let me know to enter an empty string for the same column.

Please help me with this.

Thanks,
Srai

Hi All,

I have a simple job to load data from a dataset to Oracle db.

My DataStage job is failing and throwing error as->

"Operator terminated abnormally: received signal SIGABRT"


Thanks in advance.
Santosh

yes it won't work because you are comparing "true"=true here quotes are making the difference Use one of the codes below Trim(Convert('"','',Convert(@FM,'',Execute_Command_3.$CommandOutput)))="true" Trim(Convert(@FM,'',Execute_Command_3.$CommandOutput),'"',"A"...

First try to get what is the command output from the sequence log. are you getting "true"? Please let us know the command output from the logs. Then try following codes 1 by 1 Convert(@FM,'',Execute_Command_3.$CommandOutput)="true" Trim(Convert(@FM,'',Execute_Command_3.$CommandO...

I believe you are using cat command to get True/False. Are you removing FIELD MARKS before comparision. I think its related to wrong comparision in custom trigger not the logic. use $returnvalue<1>="true". Match case too. Hi Kunal, I am using following syntax Execute_Command_3.$CommandOut...

To help with this and to cut down on the 'loop speed' add an Execute Command (or Routine Activity) stage inside the loop that does a 'sleep' for a user-configurable period of time. ... Hi Craig, I am facing one problem. I am reading the return value from a seq file using execute command and in trig...

'Breaking from the loop' is easily done - it's just a matter of branching out of the loop to a point after the End Loop stage based on your 'custom condition'. ... Hi Craig, But I did not understand how to do it using sequencer job...because when I am using start loop activity stage there are two t...

Hi Santosh, If i were you, i would have implemented this logic using a basic routine for the looping logic instead of opting for a sequence job. In the sequence job we can specify the count of loops to be executed or for an 'in list' for the counter. But i dont think we have the option to break fro...

Hi All, I have to develop a datastage job which internally calling a web service and updating saleforce.com portal and returning indicator as True or False. Based on this indicator we have to run the job in loop. Means if web service return indicator as "False" then againg same job we have...

What is preventing you from using parameters for the file names in the stage? ... My question is how to generate the parameter for the date so that it would read the file name as 06082009_ABC.txt on June 08 run 06092009_ABC.txt ... on June 09 run and so on in wait for file activity stage for every ...

The stage itself will only take one filename, but if you need to wait for all the files you can just put them sequentially, one stage per file. If more "intelligence" is needed then you could always c ... Thanks for response. I have one more requirement that is to parametrized the file na...

Hi All, I have requirement in DataStage to wait for a list of files to be present in a UNIX folder and check if all the files are present then proceed otherwise terminate the job. 1) How do we pass more than one file name in wait for file activity stage? 2) How do we parametrized the file names. Mea...

Hi All, I have a requirement to wait for a list of files (5 files) in certain folder and if all those files are present then process them otherwise terminate the job. Using Wait for file activity stage, in filename we can only mentioned one file name. How can I make job to wait for multiple files to...