can I use “drop” statement in the utility “fload”?
Answers were Sorted based on User's Feedback
Answer / sat!sh
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|
Answer / tdguy
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|
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
What is the default join strategy in Teradata???
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.
What is a pseudo key? What is its use???
What is the Maximum number of volatile tables that can be created?
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.
How to copy teradata scripts from ur remote desktop to server machine?
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
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"
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
If the script is aborted. why it is aborted and how can you identify ?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?