NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-102
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.
Partition Attributes of Tables and Indexes
If you convert a partitioned Enscribe file to a partitioned table, the following rules apply:
•
The partitions of the table are derived from the partitions of the file. Each table
partition, other than the first one, is created on the same subvolume as the
corresponding file partition, unless you use the MAP NAMES option to override
this naming pattern.
•
The EXTENT and MAXEXTENTS physical attributes for each table partition are
derived from the corresponding Enscribe file partition.
•
For key-sequenced files, each Enscribe file partition's LOW KEY attribute is used to
derive the FIRST KEY attribute of the corresponding table partition. An Enscribe
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