SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-50
Constraint Droppable Options
Constraint Droppable Options
These table entries describe settings that enable NonStop SQL/MX to ensure that the
defaults for certain constraints are set to NOT DROPPABLE:
*** ERROR[8822] The statement was not
prepared.
>>control query default infer_charset
'on';
--- SQL operation complete.
>>insert into infchar values('abc');
--- 1 row(s) inserted.
NATIONAL_CHARSET Displays the national character set ISO88591, UCS2,
KANJI, or KSC5601 used in NCHAR and NCHAR
VARYING columns. The national character set also
governs the interpretation of the character string literal
N'string'.
You select the national character set when you install
NonStop SQL/MX by using the -n option of the
InstallSqlmx script. If you specify KANJI or
KSC5601 and later attempt to create an SQL/MX table
with an NCHAR column, you will receive an error
message because SQL/MX tables do not support the
KANJI or KSC5601 character sets. If you do not specify
a value for the -n option, the national character set
defaults to UCS2.
For more information about setting the national
character set from the InstallSqlmx script, see the
SQL/MX Installation and Management Guide.
For more information about the use of the N'string'
literal, see Character String Literals
on page 6-64.
For more information about the use of the NCHAR
keyword, see Character String Data Types
on
page 6-22.
Attribute Setting
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Set to ON (DROPPABLE) or OFF (NOT DROPPABLE).
This option is used if DROPPABLE or NOT
DROPPABLE does not appear in the definition of a NOT
NULL column constraint.
The default is OFF.
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Set to ON (DROPPABLE) or OFF (NOT DROPPABLE).
This option is used if DROPPABLE or NOT
DROPPABLE does not appear in the definition of a
PRIMARY KEY constraint.
The default is OFF.