DSXchange

What is your commit level (transaction size)?

chulett wrote:Bah... you want one of these.

Can i have that but not with the office image

You can have a sequence inside a sequence inside a sequence. The top level sequence is what i referred to as Master. In your drop down, you can also choose sequence jobs.

Set the transaction size to 1.

EDITED: After realizing its a px job.
Try this

Ouch. Sorry. Wrong forum guys. Sowwiee

That job activity will pass it down the chain. You will feed the parameter to the a single job activity as "Master". It will set the parameter for that Master. Inside Master you will have, say five job activities. You will choose Master's job prameter and feed it to where ever you want to in the sub...

Read the CDC manul help for more understanding of how this stage works. Basically when you pass your data through CDC the output will have codes, based upon which you will know wheather its a new record, updated etc. So Option 2 does not make sense. You will already have new,modified,unchanged and d...

chulett wrote:No more ridiculous than DataStage jobs that just run Stored Procedures.

You mean to say 200+ grand for just doing a simple command line exec stp

A job list has to be present before you get inside your routine. dsjob -ljobs can be used to list all the jobs. Select NAME from DS_JOBS; is a UV command you can run to get all the job names. But i would stick to dsjob as the second one would sieze to exist in versions to come, so I have heard. Refr...

Thats why I asked you to reset and get the log entries so that we can try to find out.

Krazykoolrohit wrote:thanx a lot for all your support.

DSguru4U is a nice suggestion.

the 4U part sounds cheezy. Dont you think

Basically its a new kind of error and such a behaviour never witnessed. Well, contact support and see what they say. Dont forget to enlighten us on the resolution.

If you are afraid of corruption of the file, make a copy of that job, delete the original one, rename the copy. This way all associated internal files with this job will be re-created. Also next time you get this error, reset the job. This will create more log entries starting with "From previous ru...