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