step size
Set the number of rows the connector selects from the DBMS in each step of the Uniface stepped hitlist.
USYS$Mnemonic_PARAMS =
step size : Number | single
USYS$Mnemonic_PARAMS =
step : Number | single
Use
| Applies to | Mnemonic | Connector Syntax |
|---|---|---|
| DB2 connector | DB2 | USYS$DB2_PARAMS
|
| MS SQL connector | MSS | USYS$MSS_PARAMS
|
| MySQL connector | MQL | USYS$MQL_PARAMS
|
| ODBC connector | ODx | USYS$ODx_PARAMS
|
Description
This option specifies the step size of the Uniface stepped hitlist mechanism. The number specified must be in the range from 0 through 32,767. If you specify 0, the stepped hitlist mechanism is disabled, causing Uniface to internally finish the hitlist each time, before returning control to the application.
If not specified, the step size defaults to 10.
Note: If printing large amounts of data in batch mode
with the Clear (C) printing option, it is not advisable to disable the stepped
hitlist. Without the stepped hitlist, Uniface would have to select everything before starting to
format the print file; the time gained with the C option would be lost.
USYS$MSS_PARAMS step size : 100
