How to create a progressional variable in data stage?

mfranke · Post by **mfranke** » Mon Jan 16, 2006 1:48 am

Hi,
I'm loading data from a text file with data stage, this data has no really clear key column I can use. In the Oracle database where I put in the data I use a sequencer to create an id when writing the data in, but I would like to create a progressive variable earlier. Ok, e.g. there are systemvariables like inrow or outrownum, but I want that variable not only to live when the job is running, I want to store the last value and when the job runs next time he should run with the last value +1. Is this possible in data stage?
Thanks for advice,
Mario

Sreenivasulu · Post by **Sreenivasulu** » Mon Jan 16, 2006 2:38 am

HI,

I think storing a value of the variable for the next run is not possible
in datastage.

You need to store it in a file or table for reading it in the next run

Regards
Sreeni

loveojha2 · Post by **loveojha2** » Mon Jan 16, 2006 3:39 am

As Sreenivasulu told its not the variable, you should be using table or file for the purpose.

Datastage provides KeyMgtGetNextValue routine for the purpose. Which anyway uses a file for storing the next value.

mfranke · Post by **mfranke** » Mon Jan 16, 2006 4:02 am

thank you, to make it with KeyMgtGetNextValue transform works