Operation of CLI2SCI
This program initiates the following set of requests in sequence.
Each request is a separate transaction.
1 DROP TABLE T;
2 CREATE TABLE T (I INT,I2 SMALLINT);
3 USING V (INTEGER),V2(SMALLINT)INS INTO T VALUES(:V,:V2);
4 UPDATE T SET I2 = I + 1;
5 SEL SUM(I) FROM T;
Data values are generated by the program. The data generated for the INSERT statement are the integers 1,2,...MAXROWS for the fields I and I2 (equal values are inserted for the fields I and I2). MAXROWS can be adjusted to set the total number of rows inserted.