Neoview SQL Reference Manual (R2.2)

FeatureID
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 a limited number of national, international, and vendor-specific encoded
character set standards: ISO88591 and UCS2.
Unicode is a universal encoded character set that lets you 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 443).
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 relaxes SQL:1999's data type matching rule for UCS2 character set host variables
for ease of use and better performance. A UCS2 host variable is assignment and comparison
compatible with an ISO88591 value expression.
Neoview SQL allows various SQL:1999's NATIONAL CHARACTER syntax to denote a
predesignated character set. The default NATIONAL character set is UCS2.
Neoview SQL uses binary collation (that is, comparison of binary code values) to compare
character strings.
Neoview SQL complies fully with SQL:1999 for these character data type subfeatures: character
string data type declaration, character value expression, search condition, string functions and
predicates, and string literals.
448 Standard SQL and Neoview SQL