After the following setup SQL is executed against the database:
create table employee(employee_number integer);
insert into employee(1);
insert into employee sel employee_number+1 from employee;
insert into employee sel employee_number+2 from employee;
insert into employee sel employee_number+4 from employee;
the output from this sample program is:
USER : WEEKLY
USER : WEEKLY
USER : WEEKLY
WAIT FOR SELECT1 REQUEST COMPLETED.
USER : WEEKLY
EMPLOYEE NUMBER : 2
EMPLOYEE NUMBER : 5
EMPLOYEE NUMBER : 9
EMPLOYEE NUMBER : 7
EMPLOYEE NUMBER : 4
EMPLOYEE NUMBER : 6
EMPLOYEE NUMBER : 8
EMPLOYEE NUMBER : 3
EMPLOYEE NUMBER : 1
ERROR/WARNING DETECTED IN FETCH EMPCUR1
SQL CODE : 100
ERROR CODE: 0
MSG : No (or no more) rows of data satisfy the request
WAIT ALL COMPLETED.
USER : WEEKLY
EMPLOYEE NUMBER : 2
EMPLOYEE NUMBER : 5
EMPLOYEE NUMBER : 9
EMPLOYEE NUMBER : 7
EMPLOYEE NUMBER : 4
EMPLOYEE NUMBER : 6
EMPLOYEE NUMBER : 8
EMPLOYEE NUMBER : 3
EMPLOYEE NUMBER : 1
ERROR/WARNING DETECTED IN FETCH EMPCUR2
SQL CODE : 100
ERROR CODE: 0
MSG : No (or no more) rows of data satisfy the request
EMPLOYEE NUMBER : 1