Program Output - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Preprocessor2
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2023-11-20
dita:mapPath
nyr1691484085721.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
xfi1470440464166
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