DSXchange

Hi, In DS Transformer stage , I use one stage variable STGVAR1 of IINTEGER with starting value 0.And then I use the expression that STGVAR1+1.The values in the output not coming correctly,output I pasted below.Can you help me the reason why it is not incrementing properly? 1 1 2 3 4 5 6 7 8 9 10 2 3...

Use Write Method=Write and Write Mode=Append

Hi, My requirement is that find the actual number of records is deleted from target table with reference of source data. If we have 2 stages i.e 2 DB2 stages one is for the data to be deleted and another one where the data to be deleted.In target because of some rules not all the count of data is de...

chulett wrote:Can you confirm for us that you did not enable the 'Do not checkpoint' option in the Job Activity stage? ...

Hi Craig,
I have tested with both options that by check/un-check 'Do not checkpoint' option in the Job Activity stage. I can see same.

Thanks,
LK

Did the Sequence show a status of 'Aborted/Restartable'? (it must) Did you just Run it or did you Reset it first? You want to do the former as the latter will remove all of the checkpoints. ... Hi Craig, I have tried both. Sequence showed a status of 'Aborted/Restartable'.Once I reset it and ran an...

Not working means what? Tell exactly whats happening ..Also this has been discussed many times in the forum ...do a search you can find solution .. Hi , My Sequence has two Datastage jobs Lets say Job1,Job2.In first run Job1 ran successfully and Job2 jot failed.When I ran next time it again started...

Hi, I have to handle the Restartability in sequencer to make sure that Sequncer runs from the point where it got failed before. I have tried by checking the option "Add CheckPoints so sequence is Restartable on Failure" in sequncer properties.But this is not working. Is anybody have inputs...

Don't even bother trying to read it with a Sequential File stage, rather use the External Source stage in a Parallel job as noted [url=http://dsrealtime.wordpress.com/2007/12/04/reading-xml-content-as ... Thanks a lot Craig, You made my work so easy and I am able to finish my job. Thanks once again...

Hi, Folder stage is not available in Parallel jobs,It is available only in Server Jobs. Thanks, LK Hi, You can read XML file using sequential file also!! even folder stage can be used. But in the XML Input stage you have to meniton the X-path(hierachy) for each and every output columns and repeative...

I have a requirment that need to convert XML files data into db2 tables data.This I have to do it in parallel jobs.Is it possible?If yes how can I achieve this. I actually I have tried this by using sequential stage with data type of LongVarChar(9999), and then XML input stage.But it is not converti...

Can somebody help on below mentioned question

How can we achieve Dynamic Lookup concept in Parallel jobs..?

Thanks,
Lakshmi