SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

L-18

Literals

Literals are numeric, string, date-time, or INTERVAL constants that can be used in

expressions, in statements, or as parameter values.

For more information, see the entries for specific types of literals:

Date-Time Literals

INTERVAL Literals

Numeric Literals

String Literals

LOAD Command

LOAD is an SQLCI utility command that loads data from an SQL table or a Guardian

file (such as a Guardian process, device, unstructured disk file, or non-SQL object) into

either an SQL table and its indexes or an Enscribe structured disk file. LOAD

overwrites existing data in the target table or file.

LOAD resembles the FUP LOAD command but, unlike FUP LOAD, it works with SQL

objects.

If SMF is installed on your node, LOAD syntax cannot specify any file located on a

$*.ZYS*. subvolume.

When using the PARTONLY option to load a single partition, you do not need to turn off

auditing, as the command does it for you. You still need to make an online dump of the

single partition.

Caution. When loading an entire table, LOAD requires that you turn off auditing for the table.

This requirement invalidates TMF online dumps of the table and its indexes. To ensure TMF

volume recovery protection for the table and its indexes, turn AUDIT back on when the LOAD

is complete, and make new TMF online dumps of all partitions of the table and its indexes.

LOAD in-file, out-file [ [, load-option ] ... ;

load-option is:

{ control-option }

{ in-option }

{ key-sequence-option }

{ move-option }

{ PARALLEL EXECUTION { ON [config-op] | OFF } }