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

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

4 Answers   Mphasis,


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  


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,


How do you Generate Sequence in Teradata?

3 Answers   TCS,


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  






Can any one plz provide the teradata interview questions?

10 Answers  


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

3 Answers   Wipro,


in teradata level primary in table level allows duplicates why?

1 Answers   TCS,


what is the default character set in teradata,,?

2 Answers   IBM, TCS,


What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,


what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,


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

2 Answers   Mphasis,






Categories