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.
Controls
-
ASE, SYC Sybase Adaptive
Server Enterprise -
DIR Sybase DirectConnect
-
I10 Informix
-
IN9 Informix
-
JDB JDBC
-
ODBC (if driver and back-end DBMS support this feature)
-
O90 Oracle9i
-
O10 Oracle 10g
-
ORA Oracle 11g
Syntax
|
1 |
DBGetTime=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
The number of seconds PowerBuilder waits |
Default
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
profileSelect 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.DbParameter="Async=1,DBGetTime=20"