SET CTC

Set Commit Count

This directive allows basic to set the commit count for an SQL DataServer.

Syntax

SET CTC disk-specifier, commit-count [,ERR=line-ref|,ERC=error-code]

disk-specifier: is a positive integer-value or string-value containing the name of a logical disk directory.
commit-count: is a positive integer-value representing the new commit count for an SQL DataServer.
line-ref: is the program line number or label to branch to if an error is produced by this function.
error-code: is a programmer-defined error code. Valid values are positive or negative whole numbers.

This function is generally available starting with release level 8.6.1.

If an invalid disk device is specified, an ERR=14 results.

If the specified disk device does not access one of the SQL DataServers , an ERR=14 results.

If there is a problem communicating with the specified SQL DataServer, an ERR=150 results.

If the specified commit count is not an integer, an ERR=41 results.

Starting with release 8.7.1, disk devices DA-DZ and Da-Dz can be referenced by disk number.

Starting with release 8.7.1, if the specified commit-count is greater than 65535, an ERR=17 results.

SET CTC “DS”,1000

sets the commit count for the SQL DataServer accessed via disk device DS to 1000.

SET CTC 28,1000

has the same result as the previous example except that the disk number is used instead of the disk device.

SET CTC “DO”,99999

results in an ERR=17 because the new commit count value is greater than 65535.