SQL/MP Reference Manual
HP NonStop SQL/MP Reference Manual—523352-013
D-36
Summary of DEFINE Attributes
SUBSORT BLOCK size Optional
CPU cpu-number Optional
NOSCRATCHON (volume-name[, volume-name]...) Optional
PRI process-priority Optional
PROGRAM file-name Optional
SCRATCH file-name Optional
SCRATCHON (volume-name[, volume-name]...) Optional
SEGMENT extended-segment-size Optional
SWAP file-name Optional
TAPE BLOCKLEN block-length Optional
DENSITY {800 | 1600 | 6250} Optional
DEVICE $device-name Optional
EBCDIC {IN | OUT | ON | OFF} Optional
EXPIRATION date Optional
FILEID file-name Optional
FILESECT volume-order Optional
FILESEQ file-order Optional
GEN generation-number Optional
LABELS Optional
{ANSI | IBM | OMITTED | BYPASS | BACKUP}
OWNER owner-id Optional
MOUNTMSG “text” Optional
RECFORM {F | U} Optional
RECLEN record-length Optional
REELS num-of-volumes Optional
RETENTION days Optional
SYSTEM \system-name Optional
TAPEMODE {STARTSTOP | STREAM} Optional
USE {IN | OUT | EXTEND | OPENFLAG} Optional
VERSION number Optional
VOLUME {volume-id | SCRATCH} Optional
Table D-1. Attributes of DEFINEs (by Class) (page3of3)
Class Attributes
Required/
Optional