DBGetTime
database parameter
Description
Specifies the number of seconds PowerBuilder waits for a response
from the DBMS when you retrieve rows in a DataWindow object or query.
When you set the Async parameter to 1 to enable asynchronous operation,
you can also set the DBGetTime parameter for those DBMSs that support
this parameter.
If DBGetTime is set to 0 (the default), PowerBuilder waits
indefinitely for a DBMS response (the request never times out). If the
DBGetTime value expires before the first row is retrieved, your request
is automatically canceled.
Applies to
ASE, SYC SAP Adaptive Server Enterprise
DIR SAP DirectConnect
I10 Informix
IN9 Informix
JDB JDBC
ODBC (if driver and back-end DBMS support this feature)
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
|
1 |
DBGetTime=value |
|
Parameter |
Description |
|---|---|
|
value |
The number of seconds PowerBuilder waits for a DBMS |
Default value
DBGetTime=0
Usage
Requirements for using DBGetTime
To use the DBGetTime parameter, you must do both of the
following:
-
Set the Async parameter to 1 to enable asynchronous operation,
as shown in the Examples. -
Code a RetrieveRow event for a DataWindow object or
report.
Examples
To enable asynchronous operation and set the DBGetTime parameter
to 20 seconds:
-
Database profile
Select the Asynchronous check box and type 20 in the Number Of
Seconds To Wait box on the Transaction page in the Database Profile
Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="Async=1,DBGetTime=20"
See also