Option 2: define a new table

This option (see Table 94) is indicated by the keyword TBL. The library in which this table is to be defined must already exist.

DEFINE

TBL=(table name)
TTYPE=(table name conversion – blank/V)
LIB=(library name)
ORG=(R/U/S/D/H)
MTHD=(S/Q/B/C/H)
MAXGEN=(max. no. of generations allowed)
INDEX=(T/P)
SMC=(storage mode code)
ISZ=(row size)
KSZ=(key size)
KLOC=(key location)
EST=(estimated number of rows)
RPSWD=(read password)
WPSWD=(write password)
UCOMMENT=(user comments)
UPPERDEN=(upper density)
LOWERDEN=(lower density)
EXPFACTR=(expansion factor);

Required keyword

Action

A table is defined in the named library.