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

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  


What is the default join strategy in Teradata???

5 Answers   IBM,


Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


What is a pseudo key? What is its use???

2 Answers   Mphasis,


What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,






Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  


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

3 Answers  


IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Infosys, Cap Gemini, IBM,


Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,


Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,


If the script is aborted. why it is aborted and how can you identify ?

1 Answers  


How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   IBM, Comsys,






Categories