SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-222
C Examples of SET TABLE TIMEOUT
•
This SET TABLE statement has no effect; the PARTS table still uses the lock
timeout value of 30 seconds (set earlier for all tables):
EXEC SQL SET TABLE PARTS TIMEOUT RESET;
•
Reset all the lock timeout settings. All tables will use the static lock timeout values
set during explicit SQL/MX compilation:
EXEC SQL SET TABLE * TIMEOUT RESET;
•
Set all streams to use a timeout of two minutes, and then reset the stream timeout
to its original compile-time value:
EXEC SQL SET TABLE * STREAM TIMEOUT 12000;
EXEC SQL SELECT col1, col2 FROM STREAM(myqueue);
...
EXEC SQL SET TABLE * STREAM TIMEOUT RESET;
•
Use a host variable to set a timeout value entered by a user:
/* Input timeout value into a host variable */
scanf("%ld",&hv_timeout);
/* Set timeout value for ORDERS table from host variable */
EXEC SQL SET TABLE orders TIMEOUT hv_timeout;