SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-107
DDL Groups
DDL Groups
SQL does not let you define groups of columns. When the record definition is
converted to a table definition, each elementary item in a group is translated to a
corresponding column. The group name is not translated.
If two fields in the same record definition convert to the same column name, a different
digit is appended to each one to make the names unique.
Physical File Attributes of Tables and Indexes
CONVERT derives most of the physical file attributes of a table directly from the
physical attributes of the Enscribe file being converted. For indexes, CONVERT
derives MAXEXTENTS and EXTENT file attributes from the physical attributes of the
Enscribe alternate key files. Attributes that CONVERT does not specifically set in the
CREATE INDEX statement default to predetermined values.
For the AUDIT attribute, the file is created with the same value as the original file if you
specify NO LOAD; otherwise, the file is created with NO AUDIT, then set to AUDIT
after loading if the original file was audited.
Without VARCHARS Option
None CHAR(m) CHAR(j)
CHARACTER set CHAR(x)
CHARACTER SET set
NATIONAL set CHAR(y)
CHARACTER SET set
NATIONAL DEFAULT NCHAR(k)
With VARCHARS Option
CONVERT Option
SQL Data Type
PIC N Field
SQL Data Type
PIC X, PIC A or
CHARACTER Field
set An SQL-supported character set
j The number of single-byte characters
k The number of double-byte characters
m The number of characters; m is twice the corresponding k
x The number of characters; x equals j for single-byte character sets and equals j/2 for
double-byte character sets
y The number of characters; y equals k for double-byte character sets and equals twice k for
single-byte character sets