FairCom RTG V3 Update Guide

Insert Multiple Value Sets

Multiple rows can now be inserted with a single INSERT statement using multiple value sets.

Note: Use of parameters is not supported with multiple value sets.

Example

ISQL>create table mult (f1 int, f2 int);

ISQL>insert into mult values (1,1),(2,2),(3,3);

3 records inserted.

ISQL> select * from mult;

F1 F2

-- --

1 1

2 2

3 3

3 records selected