SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-67
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-214.
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: -2147483520 through 2147483647.
The default is -1.
Attribute Setting
SAVE_DROPPED_TABLE
_DDL
Controls whether definitions of dropped tables are saved to
enable them to be recovered.
If set to ON, DDL information for a dropped table is saved to a
file called catalog.schema.tablename-yyyymmdd-
timestamp.ddl in the OSS directory /usr/tandem/sqlmx/ddl.
For example, if a table called CAT.SCH.T123 is dropped at
12:53:31 PM on July 29, 2003, the full OSS path name of the
saved DDL file would be:
/usr/tandem/sqlmx/ddl/CAT.SCH.T123-20030729-
125331.ddl
To drop the table you must have write access to this directory
or you receive error 1232:
*** ERROR[1232] A file error occurred when saving dropped
table DDL for table table to /usr/tandem/sqlmx/ddl.
If the table name contains a delimited identifier, characters that
are not permitted in OSS file names are replaced by
underscores. Quotes delimiting the identifier are removed.
For example, if the table CAT."S&C%H"."T*A*B?01" is dropped
at 12:57:15 am on April 24, 2003, the saved DDL file would be:
/usr/tandem/sqlmx/ddl/CAT.S_C_H.T_A_B_01-
20030424-215715.ddl
Attribute Setting