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;

What is the difference between fastload and multiload? Which one is faster?

0 Answers  

---

What is the diffrence between Multiload & Fastload interms of Performance?

8 Answers   Cap Gemini, Intel,

---

How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,

---

How do you see a ddl for an existing table?

0 Answers  

---

Why does varchar occupy 2 extra bytes?

0 Answers  

---

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

---

What is the use of having index's on table?

1 Answers  

---

What do you mean by parsing?

0 Answers  

---

What is inner join and outer join?

0 Answers  

---

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

0 Answers  

---