DSXchange

Deepak - we don't need to use lookup to validate data. Most of the times it's just checking the domain value of the column.

I believe Ray's reply suggests to have as many links as the errors which I am trying to avoid....

Thanks

We have a process to deliver a file which has more than 50 fields. We need to add error process to this. we need to load a error table whenever there is a data violation. Problem is we need to capture all the violations in a record not just the first one. I can have mulitple links going out but I do...

I returned number from the shell script isntead of string.

rtn.$ReturnValue= "Invalid Header Record" (did not work)

rtn.$ReturnValue= 1 (worked)

Hi Requirement is to check for header, trailer formats, check the counts in the trailer of incoming file and if everything is correct then run the job or don't run the job. I have a shell script to do all of the above and I am calling this script from a routine. I have to check for 3 files so I have...

How can I pass a valule to a DataStage job and use it in transformer for other purpose. Say I need to do a pre processing to get a date and pass that date to a job to compare with a field coming out of my input file. I read somewhere in this forum that we can use a file as a stage variable when it h...

Thanks a lot for the reply...I will try to reinstall the server...

Thanks for the reply.

What is template project ? I have never used it before. Can you please elaborate the steps involved or direct me to the manual which talks about this ?

Thanks

we have recently installed a stage to our existing project. I beleive we have to install that stage in every project we create now on. Is there any option we can avoid the reinstall of this stage in each project ? I remember reading about this in this forum but I am not able to locate that post now....

In MQ Plug in help it says "If Commit/Backout only once at end of job is selected, messages are deleted only when the job finishes successfully" Does it mean that it's going to only delete those messages which are read when the job started or it's going to delete the messages which are pre...

All We are looking to do full outer join of two files in DataStage. I can do this using Merge Stage. But reading some of the postings in this forum I think the performance is not good and some people say its ugly ! Can anyone tell me why the performace is not good when we use Merge stage ? If I do t...

Hi
We read XML messages from MQ using MQ stage. I am looking for a way to remove messages from queue once I successfully load them to staging file/table. I don't want to do destructive read. I want to delete them after I make sure that all the messages are read and written to stage file.

Thanks

I found out the problem. By default sender channel will be down for every 6000 idle secs.

Thanks

I am specifying Array Size as 1 in my DB2UDB Input stage while I am writing to the table. I have done this to enable the dynamic lookup conecpt meaning I am using the Target table as my lookup and I want to capture multiple state of same enitity. i.e.If a record is updated more than once a day I wan...

We are reading Messages from a queue on diferent MQ server to etl server using MQ stage. But it appears whenever I do a destructive read the channel sender located on MQ server goes down.
is this a normal behaviour ? Does anyone experienced this before ?

Thanks

You need to run this command once before running the job to get the beginning id and once after the run to get the end id and then use both begin id and end id to get the log details using the following command

dsjob -logdetail $prm_project $prm_job $Bgn_Evnt_Id $End_Evnt_Id