Answer / sat!sh

YES,

But you have to declare it out of the FLOAD Block it means
it should not come between .begin loading,.end loading

FLOAD also supports DELETE,CREATE,DROP statements which we
have to declare out of FLOAD block

in the FLOAD Block we can give only INSERT

----
Hi Friends Got a Best ANS share with us :)

Answer / tdguy

FLOAD--PHASES--2;
MAXIMUM TABLES that can be loaded--1;
DML STATEMENTS SUPPORTED--INSERT;
DDL STATEMENTS SUPPORTED--CREATE,DROP;
ERROR TABLES TO BE DEFINED--YES;
WORK TABLES TO BE DEFINED--NO;

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,

---

What is upsert statement in teradata?

0 Answers  

---

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

---

any one answer me how they can analyzing the project using data ware housing?

0 Answers  

---

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  

---

What is called partitioned primary index (ppi)?

0 Answers  

---

Hash collision?

3 Answers   Satyam,

---

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

0 Answers  

---

What is collect State in Teradata ? what it use and how it works??

3 Answers   TCS,

---

What is the maximum number of dml can be coded in a multiload script?

0 Answers  

---

Explain about Skew Factor?

6 Answers   TCS,

---

teradata support to automatically increase the character length or not?

1 Answers  

---