can I use “drop” statement in the utility “fload”?
- 2 Answers
- 9843 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 ? | 37 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 |
What is Difference b/w PI & PPI?how to implement PPI?
what is the difference between start schma and Fsldm?
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, Spiro Solutions, South Nests Software Solution,
Which Teradata concept allows more than one model generation?
How to copy teradata scripts from ur remote desktop to server machine?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
How a Referential integrity is handled in Teradata?
what is referential constraints?how do you implement RI in teradata?
What is the process to restart the multiload if it fails?
What is meant by MATCHTAG in multiload utility?
which join mostly use in realtime?
What are the differences between TerdataV2R5 and V12 Versions please??
Teradata 
