Notes on REXX
This topic discusses comments, REXX delimiters, case, continuation characters, and the concatenation operator.
For more information on SQL within REXX code, see Quotation marks.
Comments
Every REXX program must begin with a comment that contains the word REXX. REXX comments begin with the characters /* and end with */ as follows:
01 /* rexx ***************************************************************/
REXX delimiters
REXX uses the semicolon (;) as a clause delimiter that you can omit if the end of a line implies a delimiter.
Case
Uppercase and lowercase are not significant outside quoted strings.
Continuation characters
To continue a REXX statement, use a trailing comma, as follows:
'WHERE DBNAME' eqorlike ' ' 'dbnamex' ' ',
' AND TIMESTMP = (SELECT MAX(TIMESTMP) ' ,
' AND TIMESTMP = (SELECT MAX(TIMESTMP) ' ,
Concatenation operator
To concatenate strings, use the || concatenation operator. The column headings require two lines. The concatenation operator is at the end of the first line as follows:
ipfd.top.9 = ' DBNAME CREATOR IXNAME PART USED SPACE'||,
' GB % GB DATE STATS';
' GB % GB DATE STATS';
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*