Program Output - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

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