README for HP Neoview Release 2.4 Service Pack 1

retCode = SQLSetCursorName(hstmtC1, (SQLCHAR*) "C1", SQL_NTS);

checkSQL_3_0("Set C1 cursor name ",SQL_HANDLE_STMT,hstmtC1,retCode);

retCode = SQLSetStmtAttr(hstmtC1, (SQLINTEGER)SQL_ATTR_CURSOR_HOLDABLE,

(SQLPOINTER)SQL_HOLDABLE, SQL_IS_INTEGER);

checkSQL_3_0("Set C1 holdable ",SQL_HANDLE_STMT,hstmt,retCode);

To specify a non-holdable cursor in an ODBC client application, use SQL_NONHOLDABLE

instead of SQL_HOLDABLE. In Neoview SQL, the default is a non-holdable cursor.

MAINTAIN OVERRIDE Option NEW!

Release 2.4 SP1 introduces a new option, OVERRIDE, to the REORG task of the MAINTAIN

command. The OVERRIDE option forces the Encapsulated SQL Access Manager (ESAM) to

perform a REORG operation. For example, if you want to change the slack space or reclaim free

blocks, use the OVERRIDE option. If you do not specify the OVERRIDE option, ESAM uses a

set of heuristics to determine if a REORG operation is necessary. If you specify OVERRIDE, as

the following example shows, ESAM skips the heuristics and initiates a REORG operation:

MAINTAIN TABLE t1, REORG ', OVERRIDE';

For the complete syntax and semantics of the MAINTAIN command, see the Neoview SQL Reference

Manual.

Automated Update Statistics and Reorganize Operations

You can now specify materialized views in addition to nonvolatile user tables when configuring

automated UPDATE STATISTICS. For more information about automating UPDATE STATISTICS,

see the Neoview Database Administrator's Guide. That manual will not be updated for this release;

therefore, please note the following updates:

• On page 106, the Neoview Database Administrator's Guide should provide the following

information:

HP_USTAT.CHG_AUTO_LIST() Stored Procedure

'table' is the name of the database table or materialized view. To specify all existing

tables or materialized views, use '*'. If you specify '*' for the table, you must

also specify '*' for the schema parameter.

Considerations

— To add all existing tables to the list of automated tables, call this stored procedure:

CHG_AUTO_LIST('insert', '*', '*', ?)

After calling the procedure, automated UPDATE STATISTICS adds new nonvolatile

user tables and materialized views to the list of tables at the start of every maintenance

window.

— If you call this stored procedure, automated UPDATE STATISTICS deletes all table

entries in the list, and the automated list become static:

CHG_AUTO_LIST('delete', '*', '*', ?)

In this case, automated UPDATE STATISTICS does not automatically generate

histograms for any table or materialized view.

• On page 108, the Neoview Database Administrator's Guide should provide the following

information:

HP_USTAT.USTAT_AUTO_LIST View

The USTAT_AUTO_LIST view contains all the automated tables. Because the row width of

the view is less than 80 characters, long table and schema names might become truncated

in the view. For full column data, query the USTAT_AUTO_LIST_DETAIL view instead.

See Table 2.