NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-33
Considerations—LOAD
For example, if the source field character set is UNKNOWN, you can copy it to a
target field associated with any character set. If the source field character set is one
of the nine supported ISO character sets, you can copy it only to a target field
associated with that same character set.
In addition, if you load double-byte data into a single-byte field or load single-byte
data into a double-byte field, the target field must be the same length, in bytes, as the
source field.
(Enscribe-to-Enscribe loads do no field-by-field conversion, so that case is not
shown in the previous table.)
•
Transactions, breaks, and failures
You cannot execute LOAD within a user-defined TMF transaction.
You cannot load data into an audited table. If the table to be loaded is audited, you
must turn auditing off for this table before executing the LOAD utility. If you load a
partitioned table using the PARTONLY option, this restriction does not apply.
You should perform the following sequence of operations when you need to load
data into an audited table:
1. Use ALTER TABLE to set the AUDIT attribute of the table OFF.
2. Execute the LOAD utility to load data into the nonaudited table.
3. Use ALTER TABLE to set the AUDIT attribute of the table ON.
4. Perform online dumps of all table partitions and indexes. (See the NonStop
TM/MP Operations and Recovery Guide for more information about performing
online dumps.)
If you press the Break key to interrupt a load operation, SQLCI stops the load
operation and returns the SQLCI prompt immediately, but any sort processes started
by the load operation continue to execute to completion unless you exit SQLCI and
stop them separately. Any data loaded at the time you interrupt a load operation
remains in the table or file.
If a load operation fails, the target table or file is not usable. (Depending upon the
reason for the failure, it might or might not be empty and it might or might not be
marked corrupt, but in no case is it usable.) Make any necessary corrections in the
LOAD options you specified and rerun the load operation. Alternately, if you do not
want to rerun the load operation, use the PURGEDATA command to clear the
corrupt flag.
•
Using LOAD with tapes
KSC5601 PIC N
Enscribe to SQL PIC X Any character set
PIC N Any character set
Source and
Target File Types
Source Field
Character Set
Target Field
Character Set