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

Highlight the advantages of PPI(Partition Primary Index).

0 Answers  


What is the difference between global temporary tables and volatile temporary tables?

0 Answers  


What is a dimension table?

0 Answers  


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

7 Answers  


List out all forms of LOCKS that are available in Teradata.

0 Answers  






What are the multiload utility limitations?

0 Answers  


Explain the most common data types used in teradata?

0 Answers  


what are the default access rights in the teradata?

1 Answers  


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  


Explain the new features of teradata?

0 Answers  


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

0 Answers  


How do you determine the number of sessions?

0 Answers  


Categories