Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

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) ' ,

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';

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

DASD MANAGER PLUS for DB2 13.1