NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-95
CONVERT Behavior
The character set can be one of the single-byte character sets ISO 8859/1 through
ISO 8859/9, or one of the double-byte character sets Kanji or KS C5601. (See
Character Sets on page C-16 for more information.)
UNKNOWN specifies that the character set is unknown, and specifying this option
is equivalent to omitting the CHARACTER clause. SQL uses the data as 8-bit data.
DEFAULT specifies the system default multibyte character set.
For more information about how the conversion is performed, see Conversion of
DDL Elementary Items on page C-98.
CONVERT Behavior
CONVERT writes the following to the EDIT file:
•
A section header in the form ?SECTION CREATE_table-name
•
A CREATE TABLE command that defines a table compatible with the DDL record
definition for the Enscribe file
•
A CREATE INDEX command for each alternate-key file associated with the
Enscribe file
•
A section header in the form ?SECTION LOAD_table-name
•
A LOAD command (which includes the REDEFINE option you specify in the
CONVERT command) that loads data from the Enscribe file into the empty table
and data from the alternate-key files associated with the Enscribe file into the empty
indexes
CONVERT resolves any DEFINE names you specify in the CONVERT command and
uses the actual file names in the commands it writes. Except for table name in
?SECTION headers, all file names are fully qualified. You can examine and modify the
text of the file if necessary. You use OBEY to execute the commands in the file.
Because a load operation cannot run within a TMF transaction, you cannot execute the
OBEY command generated by CONVERT within a user-defined transaction. The
catalog manager defines transactions while the CREATE commands are executing. See
LOAD Command
on page L-17 for information about how audited tables are loaded.
CONVERT requires authority to read the DDL dictionary and authority to write to the
EDIT file that receives the generated commands.
Executing the EDIT file with OBEY requires authority to read the EDIT file; authority
to write to the affected catalogs (for creating the table and indexes); authority to read the
DDL dictionary, the Enscribe source file, and the catalog in which the table is described;
and authority to read and write to the table (for loading the table and indexes).
If you press the Break key while the CONVERT command is executing and the
BREAK_KEY option is ON, SQLCI stops execution, displays a message stating that the
command was terminated by a Break, and displays the standard SQLCI prompt. The
EDIT file is closed. If the BREAK_KEY option is OFF, control returns to the previous
Break key owner (usually the command interpreter process).