Expected Results - IBM IMS/DC Interface for Teradata

IBM IMS/DC Interface for Teradata Reference

Product
IBM IMS/DC Interface for Teradata
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
jah1488824663543.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2447
lifecycle
previous
Product Category
Teradata Tools and Utilities

After first entry the following is displayed at the terminal:

1 PASS COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATION

If you type YES, then the following message displays:

2 PASSES COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATION

This process continues until you type NO. Then the following message displays and the conversation terminates.

TRANSACTION COMPLETED. USE BTEQ/ITEQ TO CHECK RESULTS

The table my_userid.MYTABLE2 contains 50 rows for each “YES” response. Thus, if “you enter YES” 7 times, then the table my_userid.MYTABLE2 contains 350 rows with the values 1,2,...350 for the field F1 and 2,3,...351 for the field F2.

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