SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-45
Example—LOAD
The SQLCI LOAD command ignores the PARTONLYIN if it is combined with the
SHARE option and reads all the source partitions.

HP encourages the use of BLOCKIN and RECIN attributes when the input file is an
unstructured file. In this case, the RECIN must be set to the actual row length and
BLOCKIN must be set to the largest multiple of the RECIN value between 1
through 32,767.
Example—LOAD
Suppose that the ODETAIL table on subvolume $VOL1.SALES is empty, and you want
to load it with data from a non-SQL object named OBASE that resides on subvolume
$VOL2.SALES. You also want to specify these requirements for the load operation:

The source file is unsorted; a temporary scratch file named
$SPOOL.SCR.TEMP is to be used during the sorting phase of the operation.

The source file is described by a DDL RECORD description named
OFORMAT. This RECORD entry is located in a DDL dictionary on the
$VOL2.SALES.

Each field in the DDL RECORD description is to be mapped to a column of the
same name in the target table.
This command performs the specified LOAD:
>> LOAD $VOL2.SALES.OBASE,$VOL1.SALES.ODETAIL
+> SCRATCH $SPOOL.SCR.TEMP
+> SOURCEDICT $VOL2.SALES
+> SOURCEREC OFORMAT
+> MOVEBYNAME;
LOCK TABLE Statement
LOCK TABLE is a DCL statement that locks a whole table (or the underlying tables of a
view) and its indexes, limiting other accesses to the table and its indexes while you or
your program execute DML statements.
name
is the name (or an equivalent DEFINE) of a table or view to lock.
LOCK TABLE { name } IN { SHARE } MODE
{ EXCLUSIVE }