DSXchange

Use the Loop stage. After finishing the last job of the sequence, check if the end time is reached ? Depending on the result, either proceed for next iteration else exit the loop.

HTH

Hi, This post reminds me of my inital days ow working with DataStage 7.5.1A (Server edition) on Windows. The same problme in my case was resolved by following almost ALL of the suggestion highlighted in the post. Only, thing I would like to add is, to please check the place where the routines are in...

Remember to mark the topic as resolved...

Remember to mark the topic as resolved...

I just presented an alternative..

If you know the maximum number of columns..then specify all those on the columns and select Retain for the Incomplete Column. This you can set in the Columns tab of Output properties for the stage.

So, Depending on the value of the first column, route the data to the desired links..

Well..I did not use UVCONFIG file in DSENGINE to create the DSN... The steps, I vaguely remember, were as follows: 1. Install a DB2 client on the server 2. Configure the DB2 client to access the desired database and verify the conenctions with some SQLs. 3. Using DS Manager, Import the table definit...

see...setting at DataStage level is helpful, in the case if u create a new project, then by default, it will be created with the DataStage level NLS settings... Anyhow, you may then overwrite the NLS settings at Project level... So , in your case you should be setting it at the Project level... chan...

Hi, One more way could be like this.. Create two output links from the transformer, one with normal mapping (col1=>col3) and (col2=>col4) and second link with on lookup[meeting some conditions] the column must be swapped ie.(col1=>col4) and (col2=>col3) Add the lookup[meeting some conditions] as the...

Job level NLS settings will overwrite the project level or the DataStage level NLS settings.. So I believe, you have 2 more places for NLS configurations... 1st: Project level : Launch the DS Administrator, select your project, click on NLS tab, and specify the desired NLS map 2nd: DataStage level :...

This sounds like a potential bug. What version of DataStage are you using, exactly? Could be... actually I went for a version upgrade.. so we actually had to upgrade from 7.5.1A to 7.5.2.. thing went fine..but the actual screwup happened when we had overwritten the project directories with the back...

Please share the exact problem you are facing while conencting to DB2 on mainframes, using the DB2 API ? I am also working on server edition and using DB2 API stage for connecting to DB2 on mainframes... Initiallly I did faced some issues...like unable to acces the table definitions and catalogs... ...

Hey..I have it... Sorry, I did not check that earlier.. The same error occurred on 23Jan also... This is the "From previous run:" From previous run DataStage Job 3 Phantom 468 Program "DSD.RUN": Line 593, Unable to unlink the operating system file "DSD.RUN_79218_14633"....

I will definitely do this...
But, unfortunately, in the latest run, there is no such entries logged...
Are these always logged or they are conditional ?

After executing UPDATE.ACCOUNT, I also exe uted VVOC (I found it on the forum itself... but to be true, without understanding what VVOC actually does.. )
So, when I ran VVOC, the screen reads: What does it mean ? I am worried