After the first entry, the following is displayed at the terminal:
1 PASS COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATIONIf you type “YES” the following message is displayed:
2 PASSES COMPLETED ENTER YES TO CONTINUE OR NO TO END CONVERSATIONThis process continues until you type “NO”. Then the following message is displayed and the conversation is terminated.
TRANSACTION COMPLETED. USE BTEQ/ITEQ TO CHECK RESULTSThe table my_userid.MYTABLE2 contains 50 rows for each “YES” response.
Thus, if “YES” is entered 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.