System Variables
IBM® InfoSphere® DataStage® provides a set of variables containing useful system information that you can access from a transform or routine. System variables are read-only.
- Name
- Description
- @DATE
- The internal date when the program started. See the Date function.
- @DAY
- The day of the month extracted from the value in @DATE.
- @FALSE
- The compiler replaces the value with 0.
- @FM
- A field mark, Char(254).
- @IM
- An item mark, Char(255).
- @INROWNUM
- Input row counter. For use in constraints and derivations in Transformer stages.
- @OUTROWNUM
- Output row counter (per link). For use in derivations in Transformer stages.
- @LOGNAME
- The user login name.
- @MONTH
- The current extracted from the value in @DATE.
- @NULL
- The null value.
- @NULL.STR
- The internal representation of the null value, Char(128).
- @PATH
- The path name of the current InfoSphere DataStage project.
- @SCHEMA
- The schema name of the current InfoSphere DataStage project.
- @SM
- A subvalue mark, Char(252).
- @SYSTEM. RETURN.CODE
- Status codes returned by system processes or commands.
- @TIME
- The internal time when the program started. See the Time function.
- @TM
- A text mark, Char(251).
- @TRUE
- The compiler replaces the value with 1.
- @USERNO
- The user number.
- @VM
- A value mark, Char(253).
- @WHO
- The name of the current InfoSphere DataStage project directory.
- @YEAR
- The current year extracted from @DATE.