15.10 - Program Output - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

prodname
Preprocessor2 for Embedded SQL
vrm_release
15.10
category
Programming Reference
featnum
B035-2446-035K

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