SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-103

Conversion of DDL Elementary Items

CONVERT converts each elementary field item in the record definition to a column

definition. The table that is created as a result of the conversion can contain at most

450 columns.

CONVERT uses the name of a DDL field as the name for the corresponding column

but replaces any hyphens (-) in the name with underscores (_).

If the data type of a DDL field is equivalent to an SQL data type, the column is

assigned the equivalent data type. If the data type is not equivalent to any SQL data

type, the column is assigned a compatible data type, if possible. If there is no

compatible data type, the column specification becomes a comment, and a warning is

appended.

DDL fields of various data types are converted as shown in the table.