Program Output - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
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