can I use “drop” statement in the utility “fload”?




Answers were Sorted based on User's Feedback



can I use “drop” statement in the utility “fload”?..

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

can I use “drop” statement in the utility “fload”?..

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

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,


what is the default character set in teradata,,?

2 Answers   IBM, TCS,


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.

2 Answers  


What's the difference between timestamp (0) and timestamp (6)?

0 Answers  






can we load 10 millions of records into target table by using tpump?

1 Answers   HP,


What are the various etl tools in the market?

0 Answers  


In Teradata, how do we Generate Sequence?

0 Answers  


What is meant by a Highest Cost Plan?

0 Answers  


what is differences between Fastload and Multiload as per DBA aspect ?

1 Answers   Wipro,


What is meant by a Least Cost Plan?

0 Answers  


what is single value and Multivalue ?

1 Answers   IBM, Wipro,






Categories