Supported macros and system variables
Database native SQL does not provide equivalent functionality for all the macros and system variables that you can use in job designs.
The following table lists macros and system variables that can be used in a Transformer stage and states whether they can be reproduced in SQL.
If you use any of these unsupported macros and system variables in any expression in a Transformer stage, then the processing contained in that Transformer stage cannot be pushed into target or source SQL. If you want to use these items in your job, segregate them into a separate Transformer stage which will not be pushed into a database source or target.
Element | Supported in Teradata SQL | Supported in IBM® Db2® SQL | Supported in Netezza | Supported in Oracle | Comment |
---|---|---|---|---|---|
Macros: DSHostName
DSJobController DSJobInvocationId DSJobName DSJobWaveNo DSProjectName |
No | No | No | No | These macros concern various aspects of the running a job. There are no equivalents in SQL. |
Macros: DSJobStartDate
DSJobStartTime DSJobStartTimestamp |
No | No | No | No | It is not possible to capture this information when the database machine and IBM InfoSphere® Information Server machine are different. |
System variables: @TRUE
@FALSE @INROWNUM @NUMPARTITIONS @OUTROWNUM @PARTITIONNUM |
No | No | No | No | There are no equivalents in SQL. |