Datastage Expressions

Reading Time: < 1 minute
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.