README for HP Neoview Release 2.4 Service Pack 1

Neoview SQL Database
The current software release introduces these new features and enhancements to the Neoview
SQL database:
• “Extended Support for Delimited Identifiers NEW!” (page 8)
• “ANSI Holdable Cursor Support NEW!” (page 8)
• “MAINTAIN OVERRIDE Option NEW!” (page 10)
• “Automated Update Statistics and Reorganize Operations” (page 10)
Extended Support for Delimited Identifiers NEW!
Neoview has extended support within Neoview SQL to include the forward slash (/) character.
The forward slash (/) is supported within delimited identifiers for DDL, DML, and SQL utility
statements.
Delimited identifiers are character strings that appear within double quote characters (") and
consist of alphanumeric characters and other characters. To include a double quote character in
a delimited identifier, use two consecutive double quotes (for example, "da Vinci’s ""Mona
Lisa"""). Unlike regular identifiers, delimited identifiers are case-sensitive. Spaces within a
delimited identifier are significant except for trailing spaces, which Neoview SQL truncates. You
can use reserved words as delimited identifiers.
The forward slash (/) character can be in any position with the delimited identifier string including
the first character following the starting double quote.
Limitations for Delimited Identifiers
These limitations apply to delimited identifiers:
• Must start and end with a double quote.
• Internal double quotes must be doubled.
• Identifiers with @ character prefix are reserved for internal names.
• The circumflex character ^ cannot be the first character following the starting double quote.
• Cannot contain trailing spaces before the end double quote (characters are removed).
• Must contain at least one non blank character.
• Cannot be all special characters (for example, "-" or "~!#$%^&").
• Can cause a length limit (128) overflow. For example, 250 double quotes result in character
length of 125 bytes.
• A table/column name including a double quote retrieved from an ODBC/JDBC catalog API
needs to be prefixed with another double quote before being used as part of an SQL statement.
For example, if the catalog API returns the table name 'Abc"def' then the application needs
to convert the table name to a delimited identifier and prefix the internal double quote with
another quote in an SQL statement, like "Abc""def".
ANSI Holdable Cursor Support NEW!
Neoview SQL now supports ANSI holdable cursors. A holdable cursor enables an application
to retain an open cursor across transactions, even after a transaction is committed, unlike
non-holdable cursors, which automatically close when a transaction is committed. ANSI holdable
cursors have these features, which make them different from other types of cursors:
• The cursor remains open when the transaction is committed.
• The cursor closes when the transaction is rolled back.
• A transaction is started automatically on a fetch after the transaction is committed.
• Error 8013 is returned when a row is updated or deleted (positioned update or delete)
without a fetch after the transaction is committed.
• Supported application programming interfaces (APIs) include both ODBC and JDBC.
8