Expected Results - IBM IMS/DC Interface for Teradata

IBM IMS/DC Interface for Teradata Reference

Product
IBM IMS/DC Interface for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2447
lifecycle
previous
Product Category
Teradata Tools and Utilities

Expected Results

The INSERT statement inserts MAXROWS (100 in this example) rows using the USING modifier, INSERT statement and data generated by the program.

The UPDATE statement changes I2 to be one greater than the field I.

The SELECT statement selects the sum of I (that is, 5050).

When a record-type parcel is received, the program displays:

SUM OF FIELD I = 5050

at the IMS terminal.

The table MY_USERID.T will contain 100 rows. Field I will contain the values 1,2,...100 and the field I2 will contain the values 2,3,...101.

Use BTEQ (see Basic Teradata Query Reference [B035‑2414]), or some other appropriate utility, to validate the results and drop the table.