Clear Job Variables in a Workflow

[PrateekBhatnaga]

Hello,

I am working on a custom task which will loop over a result set, returned by a SQL SELECT statement, and do some work. To do work in a loop, I am using the next value node in my workflow. After the WF runs and next value node evaluates to False, I see in runtime data, a new variable created called AppNameIndex = # of total rows in the dataset.

I am just wondering how can I clear the value of this AppNameIndex variable once Next Value node evaluates to false? I tried setting it to 0 and to an empty string '' using set value and SELECT node but either approach didn't work.

We're on RSA Via 6.9.1 P10.

[PrateekBhatnaga]

Any thoughts on how to de-initialize the Index variable which is created by a next value node?

[MostafaHelmy · Accepted solution]

I tried modifying its value before (as I was trying to access a specific index) but failed. I haven't tried to set its value to null though (which I guess is more logical in your case since you want to totally remove the variable).

Try something like this in a SQL Select node (I haven't tested it though):

select null as AppNameIndex from dual

[PrateekBhatnaga]

It worked!!!

Earlier I was setting the Index variable to numeric 0 instead of NULL, setting it to NULL like you suggested did the trick!!

[AndyCheek]

Why would you care? As far as I can see that is a system generated variable to hold the loop counter while the workflow is doing all the For Next type processing. Once the loop is complete it is irrelevant and (presumably) of no interest to you.

[PrateekBhatnaga]

Hi Andy,

You are correct but I am implementing batch processing where if there are 100 records to process in total, I want to pass only 15 records at a time to the node doing the work, and then send control back to SQL SELECT to return next 15 records, and so on till we process all 100 records.

In this case, I want to ensure after first batch run, all system variables are cleared out.

-Prateek