SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-97
CONVERT Command
COMMENTS
writes all qualifier names and their corresponding level numbers as comments in
the EDIT file specified in the SOURCE option (or the default EDIT file, CNVSRC).
DICTIONARY subvol
specifies the name of the subvolume (or an equivalent DEFINE) that contains the
DDL record definition ddl-record-name.
The default is the current default subvolume.
FILE IS enscribe-file
specifies the name (or an equivalent DEFINE) of the Enscribe file to convert.
The default is the file name in the FILE IS clause of the DDL record definition name
that follows the keyword RECORD.
{ LOAD | NO LOAD }
specifies or inhibits loading data from the file to be converted into the table. If you
specify NO LOAD, you can use the LOAD command later to load the data.
The default is LOAD.
{ PART | NO PART }
specifies whether to convert a partitioned Enscribe file to a partitioned table or a
nonpartitioned table.
The default is PART.
SOURCE edit-file [ CLEAR ]
identifies an EDIT file to contain the SQL commands. You can examine these
commands and modify them if necessary before executing the file with OBEY.
edit-file is the name of the file. CONVERT creates the file if it does not exist.
CLEAR clears all data from the file before adding the command. If you omit
CLEAR, CONVERT appends commands to the end of the file.
The default edit-file is CNVSRC.
{ VARCHARS | NO VARCHARS }
specifies or inhibits conversion of the special DDL group that represents
varying-length strings to the SQL VARCHAR data type:
VARCHARS converts the two elementary fields to one column with data
type VARCHAR
NO VARCHARS converts the two elementary fields to one column with data
type CHAR