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.
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
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 |
DBGetTime=0
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.
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"
