SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Creating an SQL/MX Database
HP NonStop SQL/MX Installation and Management Guide—523723-004
7-24
Managing Table Data
Restrictions on Using Character Set Data
Use only ISO88591 characters in these contexts:
In addition, user data fields must use either ISO88591 or USC2.
Defining Numeric Data
Numeric data types are either exact or approximate. Exact numeric data types can
represent a value exactly. Approximate numeric data types do not. NonStop SQL/MX
supports these exact and approximate numeric data types:
FLOAT is compatible with other numeric data types. NonStop SQL/MX performs
implicit data conversion from other numeric types to handle arithmetic or comparison
operations when required.
A column of an exact numeric type can accept a floating-point number. Also, a column
of the FLOAT data type can accept either a floating-point number or an exact numeric
type. These rules apply both to columns of an SQL/MX object and to a host variable
field.
SQL/MX tables require IEEE floating-point data. SQL/MP tables require Tandem
floating-point data. For more information, see the SQL/MX Reference Manual.
ISO88591 Field Where Found
BY partitioning-column CREATE INDEX, CREATE TABLE
CHECK constraint text CREATE TABLE, ALTER TABLE
Column default values CREATE TABLE, ALTER TABLE, CREATE VIEW
Column HEADING text CREATE TABLE, ALTER TABLE
FIRST KEY values CREATE TABLE, CREATE INDEX, MODIFY TABLE
sql-datatype character
string data types
CREATE PROCEDURE
SQL/MX names Names of catalogs, schemas, tables, views, indexes,
constraints, and columns
View text CREATE VIEW
$volume specification CREATE CATALOG, CREATE TABLE, CREATE INDEX,
CREATE VIEW, DUP, PURGEDATA, MODIFY,
RESTORE
NUMERIC
SMALL INT
INTEGER
LARGEINT
DECIMAL
PICTURE
Exact numeric data types
FLOAT
REAL
DOUBLE PRECISION
Approximate numeric data types