Chapter 5: New Features in Adaptive Server Version 12.5.0.x

Global variables

There are several new global variables for CIS.

@@bulkarraysize

@@bulkarraysize shows the current setting of bulk array size. The following isql session illustrates the use of @@bulkarraysize:

1> select @@bulkarraysize
2> go

----------- 
50    <== default value

(1 row affected)

@@bulkbatchsize shows the current setting of bulk batch size. The following isql sessions illustrates the use of @@bulkbatchsize:

1> select @@bulkbatchsize
2> go

----------- 
0    <== default value

(1 row affected)