Adding to above,assuming usage of a simple restart table, below logic can

in a BTEQ we have 2 insert 2 del 2 update statment.
when the BTEQ is restarted i need to run the BTEQ from
after DEL statment(means no need to run the insert & del
stat).what is the logic for the above requirement?

Question Posted / yuvaevergreen

2 Answers
17158 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / yuvaevergreen

Adding to above,assuming usage of a simple restart table,
below logic can be used. Below sql will not take care of
insert or delete statement failure. If the update statement
fails, the script would be restarted from update statement.
If the insert or delete statements fail, the script
would be started from insert statement.

bteq << EOF

.logon tdpid/user,password;

SELECT * FROM RESTART_TABLE WHERE STATUS='RESTART';
IF .ACTIVITYCOUNT=1 THEN .GOTO UPDTDML;
IF .ACTIVITYCOUNT=0 THEN .GOTO INSDML;

.label INSDML;
INSERT STATEMENT;

.IF ERRORCODE <> 0 THEN .EXIT;

.label DELDML;
DELETE STATEMENT;

.IF ERRORCODE <> 0 THEN .EXIT;

.LABEL UPDTDML;
UPDATE STATEMENT;

.IF ERRORCODE <> 0 THEN .GO TO REST;

.IF ERRORCODE = 0 THEN .GO TO REST1;

.LABEL REST;
DEL FROM RESTART_TABLE;
INSERT INTO RESTART_TABLE ('RESTART');
.EXIT;

.LABEL REST1;
DEL FROM RESTART_TABLE;
.EXIT;

.EOF

Is This Answer Correct ?

7 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1041

Differentiate primary key and partition key?

1034

How do you define Teradata?

1087

What does Amp contain and what are all the operations that it performs?

1055

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1128

What are the updated features of teradata?

1093

what are the uses of fact table and dimension table in banking project?

4603

List out all forms of LOCKS that are available in Teradata.

1011

What are the main components of teradata system?

1196

How to identify ppi columns?

1249

What are the different functions included in the server software?

1084

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1086

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1082

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2242

What is the difference between global temporary tables and volatile temporary tables?

1242