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

Introduction to SQL/MX Database Management
HP NonStop SQL/MX Installation and Management Guide—523723-004
1-5
Multiple Character Sets
read, SKIP CONFLICT, and STABLE. These access modes are maintained by shared
or exclusive locks on rows, sets of rows, partitions, and tables. For more information
about access options, see the SQL/MX Reference Manual.
Multiple Character Sets
NonStop SQL/MX allows you to associate one of these character sets with a literal or
host variable:
For more information about supported character sets, see the SQL/MX Reference
Manual. For information about the supported character sets for NonStop SQL/MP, see
the SQL/MP Reference Manual.
Database Security
Authorization to operate on SQL/MX tables, views, and stored procedures in Java
(SPJs) is maintained by the GRANT and REVOKE statements.
SQL/MX programs and files stored in OSS space are subject to the same security
rules as any other files stored there.
For more information, see Section 5, Planning Database Security and Recovery.
Parallel Processing
NonStop SQL/MX performs these types of parallel processing:
•
Parallel query processing
•
Parallel join operations
•
Parallel index maintenance
•
Parallel index loading
•
Parallel sorting
•
Parallel input-output operations
Parallel query processing can provide speed-up and scale-up. Speed-up is the
reduction of response time, which you can accomplish by spreading the database over
multiple partitions. Scale-up is the maintenance of a constant response time even
though the database is growing, which you can accomplish by increasing the number
of partitions.
ISO88591 Default single-byte 8-bit character set for character data types. It
supports English and other Western European languages.
USC2 Double-byte Unicode character set in UTF16 big-endian encoding. All
Basic Multilingual Plan (BMP) characters are included. Surrogate
characters are treated as two double-byte characters.
KANJI Double-byte character set widely used on Japanese mainframes. It is a
subset of Shift JIS (the double-byte portion). Its encoding is big-endian.
KSC5601 Double-byte character set required on systems using government and
banking within Korea. Its encoding is big-endian.