Binding with connection and startup parameters

Binding settings determine how data is pulled from the data source by the DataServer. When binding is turned on, query results are copied directly into the DataServer's memory, eliminating the need to do post-query calls to retrieve the data. When binding is not enabled, queries run independent of the data retrieval, and subsequent calls to the data source are required to retrieve the data.

The default setting is to use binding for both NO-LOCK and EXCLUSIVE-LOCK queries. You can override the default using the -Dsrv BINDING,nconnection parameter. The syntax is:

Syntax

-Dsrv BINDING,n;

The following table describes the BINDING options that you can specify with the -Dsrv parameter.

Table 35. Connection BINDING options
BINDING value	Description
0	Indicates that binding is not enabled at all.
1	Use binding for NO-LOCK queries only.
2	Use binding for EXCLUSIVE-LOCK queries only.
3	Use binding for both NO-LOCK and EXCLUSIVE-LOCK queries. This is the default value.