SQL

SQL as argument

The argument spans several lines to make it easier to read. However, the report programs treat the entire argument as a single line. Consequently, error messages refer to the entire argument by its first line number. For example, if a REXX syntax error occurs anywhere in the SQL in the above figure, the error message refers to line 22.

DECLARE and OPEN cursor

The report programs combine the DECLARE cursor and OPEN cursor statements, as in the following example:

For an example, see OPEN VL CURSOR in lines 22 and 23 of the sample program.

Variables in the SQL

Variables in the SQL vary by program.

For an example of the variables, see SQL as argument. In unmodified report programs, at a minimum, the variables represent the input table name, dmtable, and EXEC PARM input data, such as volume.

Retrieving the most recent data

Fetching the most recent data from the DASD MANAGER PLUS historical database requires the MAX function, MAX(TIMESTMP), within a subselect (for example, lines 28 through 30), as shown in the following example.

Quotation marks

When SQL requires single quotation marks within REXX code, you must enclose the single quotation mark with double quotation marks to indicate that the single quotation mark is a literal.

The first set of double quotation marks can enclose code other than the single quotation mark, as shown below:

'''variable''' ,

In the following example, the first set of double quotation marks encloses the words WHERE VOLID LIKE in addition to the first single quotation mark for the variable 'volume '.