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
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is meant by a dispatcher?
What are the joins in teradata and how many types of joins are there in teradata?
What is the use of having index on table?
Name the five phases that come under MultiLoad Utility.
What is the command in bteq to check for session settings ?
What is the primary index in teradata?
Define views in teradata with syntax.
Why teradata is used?
Highlight all the modes that are present under Confidence Level.
How do you determine the number of sessions?
What are the functions performed by bynet?
What is the difference between teradata and oracle?
Highlight the differences between Primary Key and Primary Index.
What are the different functions performed in development phase?