DSXchange

Can you post the function you are using here ?

It is well tested functionality of DataStage and not new to 6X so, I don't think there is any bug related to it.

If you use the same key in the second job also then u shld get continued values. The second job key starts from the point where the First job key has ended.

Is this you what are looking for ?

I would say it is possible. My way of doing it is:

Export all the jobs u want to modify as XML files and use any text editor to find and replace the string you want and again import those jobs and just test couple of them.

IHTW

Oh !! . I didn't know about that.

I wish there is a place where we can go the submitted Trouble tickets for every version so that we will not spend too much time on them before we realise that it is bug in the system, or is does on already exist ?

DataStage is showing you the information from LinkCollector which you are trying to insert the stage followed by this one. Actually the second message is showing the data which is not accepted by ORACLE.

Are you trying to change any in Transformation stage or is it direct mappings for every column ?

First of all Suttond I am confused with your question. Q1)If I am not wrong you are trying to write into ORACLE and you are getting warnings. To decide which stage is throwing the error you can get either from logs or I would suggest write the output to Sequential file to zero on error. Then if this...

I would like to pitch in one more idea about this. in your target ORACLE stage if you don't check box for 'Treat Errors as Non-fatal' you might get a non-fatal error for every hiccup you have in update. Usually this box is checked and the hiccups will be considered as Warnings by DataStage. Just a t...

I would approach this error in multiple steps to find out at what point the error is being induced into the job. 1) In JOB1 just have the T ->X -> Hash/seq file if this works then go to step 2 2) Then add your T1 to the job see. If Step-2 fails then u know what is the problem. Just an idea to zero o...

The Date() function returns an integer. So it doesn't have any timestamp in it.

Can you post the error ur having ? Did u try X = Oconv(Date(), "D") just the regular one.

IHTW

viewtopic.php?t=86342&highlight=write+cache+defer

take a look at the above code. Ray has posted some code for creating HASH FILE from DS BASIC.

GOOD Luck !!

Peter can you post the part of the code which u think might be wrong. Are there any warnings in your 20th job. This might not trigger the 21st job if u r trigger conditions are set to 'Ok Conditional'

IHTH

Also again Modularity. If your jobs are not documented well the person who comes after you will have to wonder which process is deleting the data. In this case all he/she needs to do is look at the second job which deletes the source data and will appreciate your Development standards

Well Nag, Server jobs does everything that Parallel jobs can. But the main difference is Parallel jobs are used for vast amounts of data. They are highly powerful. The way they have to be designed is differed from the Server jobs design. For true Parallelism you need to have Parallel Extender which ...

On the first look at your problem, if you want to re-use the same job how are you going to manage the Metadata which is different for ur tables. More-over the number of rows are also differ. There will be hell number of variables in your job if you even want to try it. But lets see what other have t...

Okay the last post which totally contradicts what Kenneth says. Even I am confused. I haven't used Stored Procedures from DataStage. I heard both of the statements that it can & cannot be done.

Can someone clear up this. Can we have result set of a Stored Procdure captured in DataStage or not?