| 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