Scrollable Column Headings

Describes how TBDISPL creates scrollable column heading.
RLX
TBDISPL produces a two-line heading for each column of the generated display. The first heading identifies the column name while the second heading line specifies the column datatype.
RLX
references the SQL query result and ISPF table into which the query result was loaded to obtain this information.
INTEGER SMALLINT DEC55 CHAR5 MDV005 DATE TIME 1(I) 2(S) 3(P) 4(C) 5(V) 6(DATE) 7(TIME)
RLX
TBDISPL derives the column name from the name of the ISPF table variable. These dialog variable names are limited to eight characters in length. See DECLARE ISPFTABLE Service for a description of the column naming conventions used by the
RLX
DECLARE ISPFTABLE service which produces a dialog variable name like MDV005.
The Data Type heading appearing beneath the Column Name heading consists of two components. The first is an ordinal number which identifies the column position (first, second, third, ...) within the sequence of query result columns. This ordinal number uniquely identifies the column and may be used in lieu of the column name in
RLX
TBDISPL commands.
The second component identifies the query result column datatype. The next sample enumerates the codes and corresponding datatypes which can appear in the Datatype Heading.
Code Datatype --------- ----------------------------------- DATE Date TIME Time TIMESTAMP Timestamp V Varchar C Character LV Long Varchar VG Vargraphic G Graphic LVG Long Vargraphic FLOAT Float (Single and double precision) P Packed Decimal I Integer S Small Integer