can I use “drop” statement in the utility “fload”?

Answer Posted / 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 :)

Is This Answer Correct ?    38 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dimension table?

610


What are the scenarios in which full table scans occurs?

538


Explain teradata utilities. What is multiload, fast load, tpump?

575


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

1960


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

570






Difference between star and snowflake schemas?

606


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

2906


What is a node in teradata? Explain

603


What is the purpose of indexes?

591


Explain teradata architecture in detail with a diagram.

618


What is the use of having index on table?

584


Which is more efficient group by or distinct to find duplicates?

646


In the Primary Index, what is the score of AMPs that are actively involved?

577


What are the things to be considered while creating secondary index?

633


What is TPD?

907