Neoview SQL Reference Manual (R2.4 SP2)

choice between module language and embedded language. Module language and embedded
language are identical in capability. They differ only in how SQL statements are associated with
the host programming language.
Neoview SQL Extensions to Standard SQL
Neoview SQL provides many features that enhance or supplement the functionality of standard
SQL. In your Neoview SQL applications, you can use these extensions just as you can use Core
SQL:1999. This table shows the Non-Core extensions that Neoview SQL supports:
FeatureID
Direct SQLB021
Basic dynamic SQLB031
Extended dynamic SQLB032
Isolation levels other than SERIALIZABLEF111
Basic diagnostics managementF121
Multiple schemas per userF171
INSERT statement: DEFAULT VALUES clauseF222
LIKE enhancementsF281
User authorization (no support for SYSTEM_USER)F321
ALTER TABLE statement: ADD CONSTRAINT clauseF381-02
ALTER TABLE statement: DROP CONSTRAINT clauseF381-03
NATURAL JOINF401-01
CROSS JOINF401-04
Named character setsF461
Constraint managementF491
Full value expressionsF561
LIKE clause in table definition (not exact Core SQL:1999 syntax)T171
Basic trigger capability (except for T211-07 Trigger privilege)T211
Enhanced trigger capabilityT212
ABS and MOD functionsT441
Enhanced numeric functionsT621
Character Set Support
Neoview SQL supports several national, international, and vendor-specific encoded character
set standards even though Neoview SQL supports only ISO88591 and UCS2 for character column
definitions.
Unicode is a universal encoded character set that allows you to store information from any
language using a single character set. Modern standards, such as XML, Java, Java Script, and
LDAP, require Unicode. Unicode complies with ISO/IEC standard 10646. To obtain a copy of
ISO/IEC standard 10646, see the Web sites listed under “ISO Standards” (page 513).
Neoview SQL complies fully with the Unicode 2.1 standard. For information about this standard,
see the Web site of the Unicode Consortium:
http://www.unicode.org
Neoview SQL uses UTF-16BE (16-bit) encoding for the Unicode (UCS2) character set. The full
range of UTF-16 characters is allowed, but surrogate pairs are not recognized as characters.
Neoview SQL uses single-byte encoding for ISO88591 character sets.
Neoview SQL Extensions to Standard SQL 517