Interested to Buy Any Domain ? << Click Here >> for more details...
can I use “drop” statement in the utility “fload”?
- 2 Answers
- 17042 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 |
How to run the Teradata jobs in unix environment ???
What is meant by a Virtual Disk?
If table have access lock.In the same table write lock is posible or not?
What is oltp?
What is difference between user and database in teradata?
How to find duplicates in a table?
How is MLOAD Teradata Server restarted after execution?
Explain the term 'primary key' related to relational database management system?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
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.
which option is used to restart the fastexport script ?
Find 2 highest sal from each dept who have completed 5 year in org
Teradata 
