Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1243


What is meant by a dispatcher?

1022


What are the joins in teradata and how many types of joins are there in teradata?

1008


What is the use of having index on table?

1006


Name the five phases that come under MultiLoad Utility.

989


What is the command in bteq to check for session settings ?

1180


What is the primary index in teradata?

1206


Define views in teradata with syntax.

1081


Why teradata is used?

1011


Highlight all the modes that are present under Confidence Level.

971


How do you determine the number of sessions?

1064


What are the functions performed by bynet?

1043


What is the difference between teradata and oracle?

1028


Highlight the differences between Primary Key and Primary Index.

1095


What are the different functions performed in development phase?

1082