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:- The name of the SQL result column exceeds eight characters in length.For example, TOO_LONG_NAMEShould the SQL result column be eight characters or less in length but contain an underscore (for example, COL_NAME),RLXsubstitutes the Underscore Replacement Character that is defined in the profile or using theRLXCONTROL URC service.
- The SQL result column has no name, as withSQL 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.