After first entry the following is displayed at the terminal:
1 PASS COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATIONIf you type YES, then the following message displays:
2 PASSES COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATIONThis process continues until you type NO. Then the following message displays and the conversation terminates.
TRANSACTION COMPLETED. USE BTEQ/ITEQ TO CHECK RESULTSThe 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.