Answer / yuvaevergreen

dynamic sql is invoking SQL inside a stored procedure during
run time. execute immediate or call can be used to invoke
dynamic sql.

where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,

---

Difference between stored procedure and macro?

0 Answers  

---

what is the difference between start schma and Fsldm?

5 Answers   Intel,

---

Explain the term 'primary key' related to relational database management system?

0 Answers  

---

What is use of compress in terdata?Explain?

11 Answers  

---

What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  

---

How do you do backup and recovery in teradata?

0 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

When tpump is used instead of multiload?

0 Answers  

---

What are the uses of bynets in multi-node systems?

0 Answers  

---

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

---