Page Comparison

@DATE

The internal date when the program started. See the Date function.

DaysSinceFromDate2(StringToDate(DSJobStartDate), StringToDate('1967-12-31'))

• Type conversion functions (IBM)

@DAY

The day of the month extracted from the value in @DATE.

MonthDayFromDate(StringToDate(DSJobStartDate))

• Type conversion functions (IBM)

@FALSE

The compiler replaces the value with 0.

No translation. @FALSE is available in the Parallel Engine.

• Support macros and System Variables (IBM)

@FM

A field mark, Char(254).

Char(30)

• Type conversion functions (IBM)

• System Mark ASCII code translations

@IM

An item mark, Char(255).

Char(31)

• Type conversion functions (IBM)

• System Mark ASCII code translations

@INROWNUM

Input row counter. For use in constraints and derivations in Transformer stages.

@INROWNUM is available in the Parallel Engine and is used in all instances except when it is used inside a Transformer with no input links. In this case S2PX replaces @INROWNUM with @ITERATIONS to ensures the generated Parallel Job produces matching output.

• Support macros and System Variables (IBM)

@OUTROWNUM

Output row counter (per link). For use in derivations in Transformer stages.

No translation. @OUTROWNUM is is available in the Parallel Engine.

• Support macros and System Variables (IBM)

@LOGNAME

The user login name.

Unsupported

• Unsupported System Variables

@MONTH

The current extracted from the value in @DATE.

MonthFromDate(StringToDate(DSJobStartDate))

• Type conversion functions (IBM)

@NULL

The null value.

setnull()

• Null handling functions (IBM)

• S2PX Null Handling

@NULL.STR

The internal representation of the null value, Char(128).

Char(25)

• Type conversion functions (IBM)

• S2PX Null Handling

@PATH

The path name of the current InfoSphere DataStage project.

Unsupported

• Unsupported System Variables

@SCHEMA

The schema name of the current InfoSphere DataStage project.

DSProjectName

• DSProjectName (IBM)

@SM

A sub-value mark, Char(252).

Char(28)

• Type conversion functions (IBM)

• System Mark ASCII code translations

@SYSTEM.RETURN.CODE

Status codes returned by system processes or commands.

Unsupported

• Unsupported System Variables

@TIME

The internal time when the program started. See the Time function.

StringToTime(DSJobStartTime)

• Type conversion functions (IBM)

@TM

A text mark, Char(251).

Char(26)

• Type conversion functions (IBM)

• System Mark ASCII code translations

@TRUE

The compiler replaces the value with 1.

No translation. @TRUE is available in the Parallel Engine.

• Support macros and System Variables (IBM)

@USERNO

The user number.

Unsupported

• Unsupported System Variables

@VM

A value mark, Char(253).

Char(29)

• Type conversion functions (IBM)

• System Mark ASCII code translations

@WHO

The name of the current InfoSphere DataStage project directory.

DSProjectName

• DSProjectName (IBM)

@YEAR

The current year extracted from @DATE.

YearFromDate(StringToDate(DSJobStartDate))

• Type conversion functions (IBM)