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 |
What is spool space?
How to run a query in teradata?
What is meant by a node?
What is teradata? Also, list out some of the primary characteristics of teradata.
I want to write one query How to get Matched records and unmatched records in table?
What is the difference between fastload and multiload?
Explain vproc in teradata?
What is bteq utility in teradata?
What is a common data source for the central enterprise data warehouse?
How do you define Teradata?
what are the uses of fact table and dimension table in banking project?
How to view every column and the columns contained in indexes in teradata?