SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-99
CONVERT Behavior
For more information about how the conversion is performed, see Conversion of
DDL Elementary Items on page C-103.
NATIONAL { ISO88591 | ISO88592 | ... | DEFAULT }
specifies the character set for PIC N fields. If you omit the NATIONAL option, all
items are converted according to the definitions of the original items.
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 KSC5601. (For more
information, see Character Sets on page C-17.)
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-103.
CONVERT Behavior
CONVERT writes these 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.
For more information about how audited tables are loaded, see LOAD Command
on
page L-18.
CONVERT requires authority to read the DDL dictionary and authority to write to the
EDIT file that receives the generated commands.