PREVIOUS

2.15. What is the use of INROWNUM and OUTROWNUM datastage variables?

@INROWNUM and @OUTROWNUM are internal datastage variables

which do the following:

• @INROWNUM counts incoming rows to a transformer in a datastage job.

• @OUTROWNUM counts oucoming rows from a transformer in a datastage job.

These variables can be used to generate sequences, primary keys, id's, numbering rows and also for debugging and error tracing.

They play similiar role as sequences in Oracle.

NEXT