Routine Variable

[mahi_mahi]

Hi All,
My requirement is like below

I have a input file which is having 10 records
in trnaformer iam calling a basic routine where am doing some process
and returning a value to output.

my question i need to declare a variable in routine and this should incremented every time when i call the subroutine.

in this case the value of the variable should be 10 at last excution as i have 10 input records...

SO please how can i hold the value in that variable fornext execution of routine..............!!!!!!

regards
Mahi

[DSguru2B]

i dont know if you can store the value inside the routine without clearing it, but you could physically store the value in a file. Next time just using the openseq basic command to read the value from the file. Do your manipulation and then increment it by one and write it back to the same file.

[kcbland]

You need to declare a COMMON variable, which will maintain its value as long as the process is active.

COMMON /pickaname/ yourvariable1, yourvariable2, yourvariable3.

Search the forum for implications and limitations to a labeled COMMON.

[ray.wurlod]

There are five system variables called @USER0 through @USER4 and another called @USER.RETURN.CODE. Each is initialized to zero automatically when your job starts. You can use any of these, thereby avoiding the need to use COMMON (and leaving open the possibility, therefore, of later migration into a parallel job).

[Sreenivasulu]

HI,

Wonder if this would help.
RowRunningTotal which holds the cumulative values of the job.

I remember using a datastage provided routine for this purpose.

Will get back on this soon.

Regards
Sreeni

Hi All,
My requirement is like below

I have a input file which is having 10 records
in trnaformer iam calling a basic routine where am doing some process
and returning a value to output.

my question i need to declare a variable in routine and this should incremented every time when i call the subroutine.

in this case the value of the variable should be 10 at last excution as i have 10 input records...

SO please how can i hold the value in that variable fornext execution of routine..............!!!!!!

regards
Mahi

[chulett]

Wonder if this would help. RowRunningTotal which holds the cumulative values of the job.

Yes, because it helps illustrate the use of COMMON variables in a very simple to understand example. 'RowProcGetPreviousValue' is a much more interesting one. However, it does sound like the routine you mentioned, which is technically 'RowProcRunningTotal' in the 'sdk/RowProc' branch of the repository, could be used by the OP if they don't want to write their own.

I always tend to forget about the @USER variables. While COMMON can certainly be made to work under the caveats that they come with (like buffering and migration to PX), the @USER answer is the better one. IMHO.