Identifying the SQL Query Result
In order to create the scrollable table display,
RLX
TBDISPL must reference both the ISPF table and the SQL query result. The ISPF table containing the query result may have been loaded in a single, composite operation via the RLX
DECLARE ISPFTABLE service or through discrete SQL and ISPF service calls (TBCREATE, DECLARE CURSOR, OPEN, FETCH, TBADD, CLOSE). RLX
TBDISPL supports both these query result loading mechanisms.The following example illustrates how
RLX
TBDISPL refers to the correct ISPF table and SQL query result on the basis of the name DATATYPE.---> "RLX DECLARE DATATYPE ISPFTABLE FOR", | "SELECT INTEGER, SMALLINT, DEC55, CHAR5, VARCHAR10,", | "DATE, TIME, TIMESTAMP", | "WHERE INTEGER BETWEEN :LOW AND :HIGH", | "ORDER BY INTEGER" | | DO WHILE RC = 0 --- "RLX TBDISPL DATATYPE PANEL(RLX)" END
Since the
RLX
TBDISPL service identifies the ISPF table named DATATYPE as the table it will display, RLX
searches for an ISPF table / SQL query result combination whose DECLAREd name is DATATYPE.RLX DECLARE DATATYPE ISPFTABLE FOR... A | | RLX TBDISPL DATATYPE PANEL(RLX)