SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

HP NonStop SQL/MP Reference Manual—523352-013

L-19

LOAD Command

control-option is:

{ ALLOWERRORS [ ON | OFF | num ] }

{ }

{ COUNT num-records }

{ }

{ EMPTYOK }

{ }

{ FIRST { ordinal-record-num } }

{ { KEY record-spec } }

{ { KEY (key-value[, key-value] ... ) } }

{ { key-specifier ALTKEY (key-value } }

{ { [, key-value] ... ) } }

{ }

{ PAD pad-character }

{ }

{ REPLACE SPACES WITH { ZERO[ES] | DEFAULT[S]}}

{ }

{ UNSTRUCTURED }

{ }

{ UPSHIFT }

{ }

{ USESQLNULLS }

{ }

{ SQLNULLABLE }

in-option is:

{ BLOCKIN in-block-length }

{ { COMPACT | NO COMPACT } }

{ EBCDICIN }

{ RECIN in-record-length }

{ REELS num-reels }

{ { REWINDIN | NO REWINDIN }}

{ SHARE }

{ SKIPIN num-eofs }

{ TRIM trim-character }

{ { UNLOADIN | NO UNLOADIN }}

{ VARIN }

key-sequence-option is:

{ { PARTONLY } }

{ { PARTOF volume-name } }

{ PARTONLYIN }

{ SORTED }

{ MAX num-records }

{ SCRATCH scratch-file }

{ DSLACK percent }

{ ISLACK percent }

{ SLACK percent }