can I use “drop” statement in the utility “fload”?
- 2 Answers
- 11282 Views
- Accenture, CTS, NTT Data, I also Faced
- E-Mail Answers
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 u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
What is meant by MATCHTAG in multiload utility?
what is the default character set in teradata,,?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
What's the difference between timestamp (0) and timestamp (6)?
can we load 10 millions of records into target table by using tpump?
What are the various etl tools in the market?
In Teradata, how do we Generate Sequence?
What is meant by a Highest Cost Plan?
what is differences between Fastload and Multiload as per DBA aspect ?
What is meant by a Least Cost Plan?
what is single value and Multivalue ?
Teradata 
