Answer Posted / aarsh dave

Create an empty file before each set of DML statements.
Write the BTEQ as below:

bteq << EOF

.logon tdpid/user,password;

.OS if [-f bteq_restart.txt];then else {touch bteq_restart.txt};

.run file bteq_restart.txt;

.label INSDML;

INSERT STATEMENT 1;

INSERT STATEMENT 2;

.IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

.label DELDML;

DELETE STATEMENT 1;

DELETE STATEMENT 2;

.IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

.IF ERRORCODE <> 0 THEN .OS echo '.GOTO UPDTDML' >
bteq_restart.txt;

.LABEL UPDTDML;

UPDATE STATEMENT 1;

UPDATE STATEMENT 2;

.IF ERRORCODE <> 0 THEN .EXIT ERRORCODE;

.OS rm -f bteq_restart.txt;

.EOF

What is the primary index in teradata?

1179

---

What do you mean by teradata intelliflex?

1078

---

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

1154

---

what is object level locking ? where do appear this type of locking ?

3478

---

How to identify ppi columns?

1166

---

What are the steps to create a data model?

1031

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1101

---

What is TPD?

1358

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3609

---

if collect stats but it show low confidence why?

1675

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

815

---

What are the components provided on node?

1024

---

What is difference between user and database in teradata?

1057

---

Highlight the points of differences between the database and user in Teradata.

1095

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2409

---