You can enter expressions at various places in a job sequence to set values. |
Literal strings enclosed in double-quotes or single-quotes. |
Numeric constants (integer and floating point). |
The sequence’s own job parameters. |
Prior activity variables (for example, job exit status). |
All built-in BASIC functions as available in a server job. |
Certain macros and constants as available in a server or parallel job: |
DSHostName |
DSJobController |
DSJobInvocationId |
DSJobName |
DSJobStartDate |
DSJobStartTime |
DSJobStartTimestamp |
DSJobWaveNo |
DSProjectName |
DS constants as available in server jobs. |
Arithmetic operators: + – * / ** ^ |
Relational operators: > < = # <> >= =< and so on. |
Logical operators (AND OR NOT) plus usual bracketing conventions. |
The ternary IF … THEN … ELSE operator. |
Datastage Expressions
Reading Time: < 1 minute