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

Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Wells Fargo, Infosys,


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

0 Answers  


what is meant by Hot amp?

2 Answers   Satyam, IBM,


Can we load a Multi set table using MLOAD?

2 Answers  






what is identity column in TD?

2 Answers   Wipro,


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


what are the file sizes in your project?

2 Answers  


Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,


what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,


how teradata fetches a row from primary index table?

1 Answers  


what is identity columns in teradata

2 Answers   Wipro,






Categories