NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-110
COPY Command
COPY resembles the FUP COPY command but, unlike FUP COPY, COPY works with
SQL objects.
If ServerWare Storage Management Foundation (SMF) is installed on your node, files
you specify in COPY syntax cannot be on any $*.ZYS*. subvolumes. However, remote
files on a non-SMF node can reside on any subvolume.
COPY in-file [ [, out-file [ [,] option ] ... ] ] ;
[ ,, option [ [,] option ] ... ]
option is:
{ control-option }
{ in-option }
{ out-option }
{ display-option }
{ move-option }
control-option is:
{ ALLOWERRORS [ ON | OFF | num ] }
{ }
{ COUNT num-records }
{ }
{ FIRST { ordinal-record-num } }
{ { KEY record-spec } }
{ { KEY key-value } }
{ { KEY (key-value [, key-value]... ) } }
{ { key-specifier ALTKEY key-value } }
{ { key-specifier ALTKEY (key-value } }
{ { [, key-value ] ... ) } }
{ }
{ REPLACE SPACES WITH { ZERO[ES] | DEFAULT[S] } }
{ }
{ UNSTRUCTURED }
{ }
{ UPSHIFT }
{ }
{ USESQLNULLS }
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 }