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
INF Informix
IN9 Informix
ODBC (if driver and back-end DBMS support this feature)
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
DBGetTime=value
|
Parameter |
Description |
|---|---|
|
value |
The number of seconds PowerBuilder waits for a DBMS response while waiting to retrieve the first row of a DataWindow object, query, or report |
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:
SQLCA.DBParm="Async=1,DBGetTime=20"
See also
