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 ?    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

Post New Answer




More Teradata Interview Questions

What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,


what is the difference between start schma and Fsldm?

5 Answers   Intel,


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?

1 Answers   TCS,


How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  






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?

5 Answers   HCL,


How a Referential integrity is handled in Teradata?

5 Answers  


what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,


What is the process to restart the multiload if it fails?

7 Answers  


What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,


which join mostly use in realtime?

2 Answers   TCS,


What are the differences between TerdataV2R5 and V12 Versions please??

3 Answers  






Categories