Document toolboxDocument toolbox

DataStage Macros

Owned by John McKeever
Last updated: Sept 30, 2022
2 min read

DataStage Server shares many, but not all, DataStage Macros with the Parallel Engine. This page describes the S2PX conversion behaviour for DataStage macros referenced in Server Jobs.

Server Macro Name

Description

S2PX translation

Server Macro Name

Description

S2PX translation

DSHostName

IBM Documentation (link)

None required - available in Parallel Engine.

DSJobController

IBM Documentation (link)

None required - available in Parallel Engine.

May also be automatically processed by Job Decomposition.

DSJobInvocationId

IBM Documentation (link)

None required - available in Parallel Engine.

DSJobName

IBM Documentation (link)

None required - available in Parallel Engine.

May also be automatically processed by Job Decomposition.

DSJobStartDate

IBM Documentation (link)

None required - available in Parallel Engine.

May also be automatically processed by Job Decomposition.

DSJobStartTime

IBM Documentation (link)

None required - available in Parallel Engine.

May also be automatically processed by Job Decomposition.

DSJobStartTimestamp

IBM Documentation (link)

None required - available in Parallel Engine.

May also be automatically processed by Job Decomposition.

DSJobStatus

Current status of job overall

Replaced with constant 1 as this is what Server always returns when the Job Status is requested from within a running job. 

Note that this value is, counterintuitively, the same as DSJS.RUNOK, and not the expected 0 which maps to DSJS.RUNNING.

DSJobWaveNo

IBM Documentation (link)

None required - available in Parallel Engine.

DSLinkLastErr

Last error message (if any) reported from the link in question

Unsupported

DSLinkName

Returns the name of the link

Replaced with a constant containing original link name.

DSLinkRowCount

IBM Documentation (link)

Replaced with @OUTROWNUM (see System Variables).

DSProjectName

IBM Documentation (link)

None required - available in Parallel Engine.

DSRTIRequestNo

Count of EndOfTransmission blocks processed by this stage so far

Unsupported

DSRTIRowCount

Row count since last EndOfTransmission block

Unsupported

DSStageInRowNum

IBM Documentation (link)

Replaced with @INROWNUM (see System Variables).

DSStageLastErr

Last error message (if any) reported from any link of the stage in question

Unsupported

DSStageName

IBM Documentation (link)

Replaced with a constant string which is the name of the stage (fully qualified, including any container names).  This name is based on the original server job stage name, not the stage name generated by PX which might be in a newly generated local container

DSStageType

IBM Documentation (link)

Replaced with constant string CTransformerStage.

DSStageVarList

Comma-separated list of stage variable names

Replaced with an explicit comma-separated string of the host Transformer’s Stage Variable names. 

See also

 

© 2015-2024 Data Migrators Pty Ltd.