SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-81
Table Management
For more information about these defaults, see SQL/MX Queuing and
Publish/Subscribe Services.
Table Management
These attributes enable NonStop SQL/MX to manage tables:
STREAM_TIMEOUT The time in hundredths of seconds for a cursor fetch operation using
stream access to wait for more rows before timing out. Setting this
default directs NonStop SQL/MX to not wait for more rows beyond
the specified time but to return with error code 8006.
This default is valid for compile-time stream timeout. For run-time
stream timeout, see SET TABLE TIMEOUT Statement
on
page 2-297.
Using a low value can result in a timeout before all rows are returned
(due to delays between processes). If you use a low value (for
example, 300), the application unblocks and either closes the cursor
to not wait any longer or retrieves the fetch.
Any value < 0 directs NonStop SQL/MX to wait indefinitely until there
are no more rows to return. Setting it to RESET changes it back to
the value in effect at the start of the session.
Allowable values: -2147483648 through 2147483647.
The default is -1.
Attribute Setting
DEFAULT_BLOCKSIZE Enables you to specify the default behavior when database
objects are created that do not specify a BLOCKSIZE.
Valid values are:

4096— for database objects created without explicitly
stating the BLOCKSIZE attribute, the block size will be 4
KB. This is the system default value.

32768— for database objects created without explicitly
stating the BLOCKSIZE attribute, the block size will be 32
KB.
Attribute Setting