Datstage solutions, knowledge base, FAQ and best practices

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.

Back to the list of all Datastage FAQ topics