Neoview SQL Reference Manual (R2.4)

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software

New or Changed InformationChapter

• “Data Types” (page 229)

— “Numeric Data Types” (page 232) corrections and added extended

numeric precision support

— “Comparable and Compatible Data Types” (page 231) corrections

to CHAR and VARCHAR maximum values, removed LONG

VARCHAR

• “Delimited Identifiers” (page 252) corrections to limitations

• Added entry for “LIKE Predicate” (page 275). In SJIS and Unicode

configurations, the LIKE predicate now handles an underscore as

one character, regardless of the byte length of the character, and

now compares character strings at the character level, not the byte

level. See the “LIKE Predicate” (page 275).

• Added entry for “Materialized Views” (page 263).

• Added entry for “Synonyms” (page 289).

Chapter 4 (page 221)

Added “FORMAT Clause” (page 296).Chapter 5 (page 293)

• Character string functions now treat each multibyte character in an

input string as one character, regardless of the byte length of the

character. These character string functions have been enhanced to

handle multibyte characters:

“ASCII Function” (page 327)

“CHAR Function” (page 340)

“CHAR_LENGTH Function” (page 341)

“CODE_VALUE Function” (page 343)

“CONCAT Function” (page 344)

“INSERT Function” (page 386)

“LCASE Function” (page 390)

“LEFT Function” (page 391)

“LOCATE Function” (page 392)

“LOWER Function” (page 395)

“LPAD Function” (page 400)

“LTRIM Function” (page 401)

“POSITION Function” (page 423)

“REPLACE Function” (page 431)

“RIGHT Function” (page 432)

“RPAD Function” (page 437)

“RTRIM Function” (page 438)

“SPACE Function” (page 450)

“SUBSTRING/SUBSTR Function” (page 454)

“TRANSLATE Function” (page 462)

“TRIM Function” (page 463)

“UCASE Function” (page 464)

“UPPER Function” (page 472)

“UPSHIFT Function” (page 473)

• These other SQL functions may return ISO88591 or UCS2 characters:

“CONVERTTOHEX Function” (page 345)

“CURRENT_USER Function” (page 357)

“DATEFORMAT Function” (page 362)

“DAYNAME Function” (page 367)

“MONTHNAME Function” (page 407)

“USER Function” (page 474)

• Added “CONVERTTOHEX Function” (page 345), “TIMESTAMPADD

Function” (page 460), and “TIMESTAMPDIFF Function” (page 461)

from Neoview R2.3 SP2 Supplement to the Neoview SQL Reference

Manual.

Chapter 6 (page 317)

Added ORDER BY expression support and clarified limitations.Chapter 7 (page 481)

Moved information to this appendix from the Neoview Database

Administrator's Guide.

Appendix E (page 513)