IBM SC41-5210-04 manual Working with Query for iSeries query definitions

E means DBCS-either

G means DBCS-graphic

L means Date

T means Time

Z means Timestamp

vThe Null column shows whether the field is null capable (Y) or not (blank).

vThe Data Type column shows the data type for each field.

vThe Text column shows the comment (if it exists) for each field. If the field is for a summary function, the text shown is the field name (without any added numbers) followed by the type of summary function.

vThe CCSID column (if shown) appears when multiple CCSIDs are represented and shows the CCSID for each field.

Chapter 16. Working with Query for iSeries query definitions 183