Default Action

Describes the default action that is taken by DECLARE ISPFTABLE.
If you choose to omit the INTO clause of the DECLARE ISPFTABLE statement,
RLX
uses the name of the SQL result column as the name of the host main variable as well as the ISPF table row variable. In exceptional cases where this is not feasible,
RLX
offers a useful alternative. The exceptional instances are as follows:
  1. The name of the SQL result column exceeds eight characters in length.
    For example, TOO_LONG_NAME
    Should the SQL result column be eight characters or less in length but contain an underscore (for example, COL_NAME),
    RLX
    substitutes the Underscore Replacement Character that is defined in the profile or using the
    RLX
    CONTROL URC service.
  2. The SQL result column has no name, as with
    SQL Built in functions - e.g., AVG(COLUMN1) Multi-term expressions - e.g., COLUMN_NAME + 10 literal constants - e.g., 10 or 'CONSTANT'
In these two instances,
RLX
derives dialog variable names according to the following convention:
MDVxxx for each (M)ain (D)ialog (V)ariable where xxx is the ordinal number (1st, 2nd, 3rd, ...) of the SELECT list column for which
RLX
is deriving a default name. For example, if AVG(PEACHES) were the third column in the SELECT list,
RLX
would generate the name MDV003 for both the host main variable and ISPF table row variable.
If the SQL result column permits NULL values,
RLX
generates indicator variables according to a similar convention:
IDVxxx for each (I)ndicator (D)ialog (V)ariable where xxx corresponds to the ordinal number (1st, 2nd, 3rd, ...) of the SELECT list column with which the indicator variable is associated. For example, if APPLES were the first column in the SELECT list and it permitted NULLS, the derived name of its indicator dialog variable would be IDV001.