NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-94
CONVERT Command
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.
AS 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 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.
For more information about how the conversion is performed, see Conversion of
DDL Elementary Items on page C-98.
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.