An SQL primer
adsm> select typename,remarks,values from syscat.enumtypes
------------------ ------------------ ------------------
OBJECT_TYPE Object Type DIR(0), FILE(1),
BACKUPSTATE Backup object ACTIVE_VERSION(0),
version state INACTIVE_VERSION-
YESNO_TYPE Yes/No Enumeration NO(0), YES(1)
COMPRESSTYPE Client compression NO(0), YES(1),
OPENCLOSED Open/Closed CLOSED(0), OPEN(1)
LOGGINGMODE Server logging NORMAL(0),
SEVERITY_TYPE Message severity I(0), W(1), E(2),
COPYTYPE Client object copy ARCHIVE(0),
CTYPE Analysis object BACKUP(0),