can I use “drop” statement in the utility “fload”?
Answers were Sorted based on User's Feedback
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 :)
Is This Answer Correct ? | 38 Yes | 1 No |
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;
Is This Answer Correct ? | 8 Yes | 0 No |
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What do you mean by tpt in teradata?
why varchar takes 2 extra bytes?
What is logical data model?
What are the various indexes in teradata? How to use them? Why are they preferred?
what is single value and Multivalue ?
If table have access lock.In the same table write lock is posible or not?
Highlight the need for Performance Tuning.
what is the default character set in teradata,,?
During the Display time, how is the sequence generated by Teradata?
What is the process to restart the multiload if it fails?
What are default access rights in teradata? What explicit right can be given to a user?