This function is used to set the maximum time allowed for an SQL query. If this time limit is exceeded, query execution is stopped and the *LOCKED reserved word is set to 1.
Notes:
This function is used to manage a query locking timeout for the ORACLE DBMS, which does not feature this capability, unlike DB2 and SQL_SERVER, which let you specify a timeout in their setup.
This function must be called in the logical server used for database access.
Context
Windows server,
Java server.
Parameters
NUM_BIN_2 |
Length |
Maximum wait time in seconds. Length must be a positive value or 0. If Length is set to 0, the system does not use a wait timeout. |
ALPHA(1) |
Type |
'P': the maximum wait timeout is set for all the queries submitted during the session. 'T': the maximum wait timeout is set for the next query submitted during the session. |
BOOL |
ReturnCode |
Return code for the operation: *TRUE if the operation was completed successfully. *FALSE if it was not. |
Example
Length = 15
Type = 'T'
CALL_DLL 'VATOOLBX.DLL' 'VaToolBxSetTimeOut' Length Permanent ReturnCode
List of the VaToolBx functions by topic