DSXchange

Hi, We have an evaluation version of IIS 8.1 on a windows 2003 machine. We installed Oracle 10g client by choosing the " custom mode " option on the windows machine where the DataStage is Installed. And, I created a System DSN on Windows 2003 machine. When i try to connect Oracle 10g datab...

hi I am trying to dump the table data to an xml file and I gave xpath defination also in the xml output stage but it is throwing me an error "Derivation rule "Table_Name/Field_name" is invalid. Message = "'/' expected at "/""" Can some body help me pls Thanks

Can we use any stage in Sequence to run the SQL to get the row count from a table instead of using a ODBC or native plug-in stage od a database in a job and putting them in a file then reading from the file.....

Any suggestions??


Thanks

mailx -s "$SUBJECT" $USERS Works fine for me. Hi duke, I made some progress on this, but, When i tried to use the same, I have a big sentence of subject in between spaces for each word. Now, when i tried to use the above, its putting the first word of the sentence as a subject and the res...

Hi I have an issue with the mail syntax: Here it is mail -s $EMAILSUBJECT $EMAILADDRESS < EMAILFILE Variable $EMAILSUBJECT is suppose to substitute the value of it as a subject. But it is not doing that. I tried to put in quotes also. Instead of taking the variable value it is sending one of the ema...

Hi Yesterday i scheduled few of the sequences. They all are in a runnable state. But 2 of the sequences has just started and gave the below message: DS.SCHED: Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG345 This sequence did not run any jobs in it. Is it because of the over load...

Thanks Kris.. I think you are right. I just enabled "allow multile isntance" check box for the jox "X". But i ignored the invocation id what it is getting. Thanks for your suggesstion again. In connection to my yesterdays post regarding the patch for the ds cleint, I opened a tic...

Hi All, I am running a parallel job "X" from a sequence "SEQ1". This sequence (SEQ1) is needed to run from another sequence (SEQ2). This SEQ1 is a common sequence need to run 11 times in SEQ2. I enabled "allow multiple instance" check box in the job properties to the SE...

kris007 wrote:Here's the patch name

Code: Select all

dsjsjobgen.dll

But I don't have the eCase number. So can't help you on that.

Thanks Kris..

I will work on this.

Thanks

I dont have access to DataStage currently but isnt it suppose to be $ReturnValue that you choose by right clicking on the window expression. :?: :?: :?: Hi Chuck Thanks for your response. Actually, I am getting the return value of a "Execute Command" using "Comand_Output.$ReturnValue...

This is a known issue with the Nested Condition stage. You will need to apply a patch on your client machine. Contact your support provider. I can't recollect the eCase number. I faced the similar problem in the past at a different Client site. However, search the forum. I remember posting the patc...

Hi, I am using a "Nested-Condition" stage in a sequence. Actually, this sequence is used as a sub-sequence in a different sequence. I have 4 triggers for the "Nested Condition" stage. Iam using the expression type "custom(conditional)". Below are the expressions iam usi...

I would suggest to use a job sequence. You could use a Execute Command or embed your shell script in a routine, Now you can read the ReturnValue and based on that you can Abort your job Thanks a lot Narasimha... :D Fabulous idea!!! Just based on your suggestion my entire process has been changed. I...

Hello Everyone, I have a shell script which is being called in the "Before job sub routine" of a DataStage job. This shell script is on another Server which runs on Linux. Iam calling this script using "SSH" command to connect to the remote server where this script is located. Wh...

Hello Everyone, I have a shell script which is being called in the "Before job sub routine" of a DataStage job. This shell script is on another Server which runs on Linux. Iam calling this script using "SSH" command to connect to the remote server where this script is located. Wh...