The following configuration properties were added for version 12.6.1.
(CR400180) Disables a lock that is created on a read-only cursor. It is part of the Target Interaction subsection of properties.
DisableROLock=[yes | no]
no
yes disables the lock on the read-only cursors.
no retains the lock on the read-only cursors.
(CR378901) Removes the configured character string from the beginning of an incoming language event. It is part of the Client Interaction sub-section of properties.
StripString=character string
blank
character string is the configured string that is to be removed from the beginning of the incoming language string. It must match the incoming language string exactly, including case and spaces.
Sets the number of rows DirectConnect will fetch into the receive buffer. It is part of the Transfer sub-section of properties.
TransferBatch=integer
1 (one)
integer is the number of rows that DirectConnect will send and fetch in one batch to ASE.
1 (one) is the default value.
(CR396955) Delimits the statements in batch. It is part of the Transfer sub-section of properties.
TransferBatchSeparator=; (semicolon)
space
; (semicolon) indicates that the target database is DRDA.
space indicates that the target database is ASE.
When required, set the property to a semicolon.
The packet size between DirectConnect and the target database. It is part of the Transfer sub-section of properties.
TransferPacketSize=integer
512
integer must be in multiples of 512 and must not exceed the target packet size; otherwise, the connection will fail.
WARNING! If you increase the packet size beyond the capabilities of ASE, the transfer login to the secondary database will fail.
You can determine the ASE packet size by using sp_configure:
To return the default packet size:
sp_configure “default network packet”
To return the maximum size:
sp_configure “max network packet”
(CR 426212, CR 426209) The following replaces the property description.
Specifies the maximum number of bytes an access service returns to the client application in a result set.
MaxResultSize=integer
0 – 2147483646
unlimited
integer is a number of bytes.
A value of 0 indicates that the result size is an unlimited value.
The MaxResultSize value is approximate in that the access service checks at the end of each row to see if the value is exceeded.
If the value is exceeded, the access service does the following:
Sends the entire row to the client application (not a partial row)
Does not send any of the remaining rows in the result set
(CR 426212, CR 426209) The following replaces the property description.
Specifies the maximum number of rows an access service returns to the client application in a result set.
MaxRowsReturned=integer
0 – unlimited
unlimited
integer is a number of rows.
A value of 0 indicates that the rows returned is an unlimited value.
If the MaxRowsReturned value is exceeded, the value is returned to the client as an error.