How to store the Values in the Environment Variables

[priyadarshikunal]

Seems like you are using a list loop with seretator as , and values 1,1,1

For 3 runs you are passing the same value, So how you are expecting the counter to be different for each run?

Pass 1,2,3 to create 3 different files.

Else as Craig said explain your problem properly.

[chulett]

Seems like you are using a list loop with seretator as , and values 1,1,1

No, they were noted as being the Start, Stop and Step values used in the stage... as in looping "from 1 to 1 by 1", a single iteration - which would mean there's absolutely no need for the loop. Hence the confusion.

[shivakumar]

Hi ,

Basically I need the reject files based on my job runs.Suppose if my job runs 5 times in a day then I have to execute my job 5 times so 5 Rejecte files are to be created with/ithout rejected records.

The reject file name cinatains "RejectFile_Date_<JobrunNumber>"

Here the <Jobrunnumber>={1,2,3,4,5} it varies from day to day based on the job runs on that particular day.

06-07-2009 ---> if my job rund 2 times then I have to get 2 reject files

RejectFile_06-07-2009-1 and RejectFile_06-07-2009-2.

for 07-07-2009 ---->if my job runs for 3 times then I have to get 3 reject files as RejectFile_07-07-2009-1, RejectFile_07-07-2009-2 and RejectFile_06-07-2009-3.

If you observe the above files I have to rest the counter value if Date changes.


Can you please guide me how to achieve this in Data Stage?

Thanks and Regards
Siva

[chulett]

We get all that. That's straightforward. What you still haven't explained is what drives your "if my job runs X times" requirement. How is it triggered? What controls running 2 versus 3 or 5 times?

[priyadarshikunal]

Seems like you are using a list loop with seretator as , and values 1,1,1

No, they were noted as being the Start, Stop and Step values used in the stage... as in looping "from 1 to 1 by 1", a single iteration - which would mean there's absolutely no need for the loop. Hence the confusion.

Thanks for clarification.

After reading each and every post, what I understand is there is no loop at all (at least not needed). Its being triggered when the condition is met (like file arrival).

In that case you need to store your counter and loop will not hold it once the job is complete. hence you need to think out of the box and store the counter somewhere like in a file (or database) . Increase it every time and reset it everyday.

PS: Its impossible to guess the problem without proper explanation. In that case probablity of getting correct answer will be too less.