SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-98
CONVERT Command
The default is VARCHARS.
REDEFINE ( redef-spec [ , redef-spec ] ... )
specifies that original items (groups or fields) are to be converted to columns
based on redefinitions of the items. Unless you include the REDEFINE option, all
items are converted according to the definition of the original items, and the
REDEFINES clause in the DDL record definition is ignored.
redef-spec is:
original-qualified-name AS redefined-qualified-name
original-qualified-name
identifies an original field or group in a DDL record. The name must be qualified by
the group names at all preceding levels; for example,
CUSTOMER.ADDRESS.STREET-ADDRESS is the qualified name for the
STREET-ADDRESS field of the ADDRESS group. The ADDRESS group is in the
CUSTOMER group.
redefined-qualified-name
identifies a redefined field or group that corresponds to the original field or group.
The name must be qualified by the group names at all preceding levels; for
example, CUSTOMER.ADDRESS.STREET-DETAIL is the qualified name of the
STREET-DETAIL field that redefines the STREET-ADDRESS field.
When the source field is converted, the conversion is based on the redefinition that
you specify.
If the item is redefined as a group, the elementary fields of the group are converted
to columns. When the redefined item is shorter than the original item, the resulting
columns are the size of the redefined item; CONVERT does not pad the columns
with blanks.
CHARACTER { ISO88591 | ISO88592 | ... | UNKNOWN }
specifies the character set for PIC X, PIC A, and TYPE CHARACTER fields. If you
omit the CHARACTER 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.