An SQL primer
adsm> select typename as "Name of enumerated type",VALUES as "Enumerated values and their ordering" from syscat.enumtypes
Name of enumerated type Enumerated values and their ordering
----------------------- ------------------------------------
OBJECT_TYPE DIR(0), FILE(1), UNKNOWN(2)
BACKUPSTATE ACTIVE_VERSION(0),
INACTIVE_VERSION(1), UNKNOWN(2)
COMPRESSTYPE NO(0), YES(1), CLIENT(2)
OPENCLOSED CLOSED(0), OPEN(1)
LOGGINGMODE NORMAL(0), ROLLFORWARD(1)
SEVERITY_TYPE I(0), W(1), E(2), S(3), D(4)
COPYTYPE ARCHIVE(0), BACKUP(1), SPACE
CTYPE BACKUP(0), ARCHIVE(1)