...
Variable Name | Description | S2PX Translation | Notes | |
---|---|---|---|---|
@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. | No translation. | ||
@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. | No translation. | ||
@LOGNAME | The user login name. | Currently unsupported|||
@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. | Currently unsupported|||
@SCHEMA | The schema name of the current InfoSphere DataStage project. |
| ||
@SM | A sub-value mark, Char(252). |
| ||
@SYSTEM.RETURN.CODE | Status codes returned by system processes or commands. | Currently unsupported|||
@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. | No translation. | ||
@USERNO | The user number. | Currently unsupported|||
@VM | A value mark, Char(253). |
| ||
@WHO | The name of the current InfoSphere DataStage project directory. |
| ||
@YEAR | The current year extracted from @DATE. |
|
System Marks
Universe has a set of System “Mark” ‘System Mark’ characters which are used to support multi-valued strings. These characters are represented as fixed ASCII values, have special handling when converting to and from NLS Code pages and Unicode, and can be accessed directly using system variables. The table below shows the ASCII and Unicode Hex Values for each System Mark:
System Variable | Description | ASCII Character | Unicode Character |
---|---|---|---|
@IM | Item Mark | 0xFF | 0xF8FF |
@FM | Field Mark | 0xFE | 0xF8FE |
@VM | Value Mark | 0xFD | 0xF8FD |
@SM | Subvalue Sub-value Mark | 0xFC | 0xF8FC |
@TM | Text Mark | 0xFB | 0xF8FB |
@NULL.STR | Null String | 0x80 | 0xF8F7 |
...