README for HP Neoview Release 2.4

^ (25 characters from start if SQL statement)

*** ERROR[8822] The statement was not prepared.

Schema Privileges in Release 2.4

Schema privileges are enabled by default in Neoview Release 2.4. This means that the schema

owner can use GRANT and REVOKE statements to modify these privileges for individual

schemas. The Neoview SQL Reference Manual documents the use of the GRANT and REVOKE

statements.

Previously, schema privileges were disabled by default. Neoview platforms that are migrated

to Release 2.4 can optionally have schema privileges enabled for existing schemas, after which

users can use the GRANT and REVOKE statements to modify privileges at the schema level. For

assistance in having schema privileges enabled for existing schemas, contact HP support.

Schema Version 2400

Release 2.4 introduces schema version 2400. The schema version changed as a result of

enhancements to the underlying metadata. Customers who want to migrate from Release 2.3 to

2.4 must contact an HP support provider to upgrade the schema version from an earlier schema

version to 2400.

Sequence Generator

In Release 2.0, Neoview SQL introduced the surrogate key. The surrogate key is implemented

as an IDENTITY column that the database uses to generate unique values as a numeric column.

These values are unique across all the partitions of a table.

In the Release 2.0 through 2.3 implementation, a timestamp-based random number generator

creates the value for the IDENTITY column. The drawback of this method is that there can be

duplicates, and the values are non-sequential between multiple inserts into the table. Also, the

IDENTITY column values are generated using serial plans, resulting in poor resource usage.

In Release 2.4, IDENTITY column value generation now uses an internal sequence generator.

The random number generator is no longer used, thus eliminating duplicate values. The values

for IDENTITY columns can now be generated in parallel.

For more information about the syntax and semantics of the IDENTITY column and the internal

sequence generator, see the Neoview SQL Reference Manual.

Connectivity

These are the new connectivity features in Release 2.4:

• “Support for the Microsoft .NET Framework” (page 10)

• “Updated Neoview JDBC Type 4 Driver” (page 10)

Support for the Microsoft .NET Framework

The Microsoft .NET framework is a Windows component that supports building and running

applications and XML Web services. Neoview Release 2.4 provides the ability to use the ODBC

.NET Data Provider collection of classes. For more information about Microsoft .NET framework,

see http://msdn.microsoft.com/en-us/netframework/default.aspx.

Updated Neoview JDBC Type 4 Driver

For Release 2.4, the updated JDBC Type 4 driver: