ODBC Server Reference Manual

Using Pass-Through Mode

HP NonStop ODBC Server Reference Manual—429151-002

6-5

Setting the Cursor Default Mode

The following command sets the server option SQL_CURSOR_DEFAULT_MODE,

which controls the degree of database access given by default to SQL cursors.

specifies that cursors not otherwise defined default to the read-only mode.

specifies that cursors not otherwise defined default to the read/write mode. This is

the default for this option.

Setting the Maximum Number of Rows Returned

The following SET command configures the server option SQL_MAX_ROWS, which

controls the maximum number of database rows returned in SELECT statements.

value

specifies the maximum number of database rows to be returned in response to a

SELECT statement. If value is zero, the NonStop ODBC Server can return all

rows. Zero is the default value for SQL_MAX_ROWS.

If a client request generates a greater number of rows than the maximum number

specified, the rows in excess of that number are discarded and are not returned to

the client.

Setting the Isolation Level

The following SET command configures the server option SQL_TXN_ISOLATION,

which specifies the isolation level to be applied to SQL statements.

SELECT "TDM: SET SQL_CURSOR_DEFAULT_MODE { RO } "

{ RW }

SELECT "TDM: SET SQL_MAX_ROWS value"

SELECT "TDM: SET SQL_TXN_ISOLATION level"