Dynamically Designed Panels

Describes panels produced for the SQL Query Result DATATYPE whose columns are named for their datatypes.
With the ISPF TBDISPL service, you must first design and edit an appropriate table display panel before you can display the contents of an ISPF table. In contrast,
RLX
TBDISPL dynamically creates a suitable panel. The following example illustrates the display produced for the SQL Query Result DATATYPE whose columns are named for their datatypes.
SQL Query Result 'DATATYPE'--------------------------------------- ROW 1 OF 14 Command ===> Scroll ===> HALF INTEGER SMALLINT DEC55 CHAR5 MDV005 DATE TIME 1(I) 2(S) 3(P) 4(C) 5(V) 6(DATE) 7(TIME) 57 57 0.57000 C57 VC57 2003-01-21 16.42.23 58 58 0.58000 C58 VC58 2003-01-21 16.42.23 59 59 0.59000 C59 VC59 2003-01-21 16.42.23 63 63 0.63000 C63 VC63 2003-01-21 16.42.23 78 78 0.78000 C78 VC78 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 82 82 0.82000 C82 VC82 2003-01-21 16.42.23 82 82 0.82000 C82 VC82 2003-11-23 13.24.23 87 87 0.87000 C87 VC87 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-01-21 16.42.23 93 93 0.93000 C93 VC93 2003-10-18 11.16.45 100 100 0.10000 C100 VC100 2003-10-18 11.16.45 100 100 0.10000 C100 - 2003-10-18 11.16.45
The panel illustrates the following points:
  • Query result columns whose datatype is numeric appear right-justified
  • Non-numeric query result columns appear left-justified
  • The
    RLX
    TBDISPL service can expand the width of the display in accordance with the width of the logical screen