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|
What is meant by MATCHTAG in multiload utility?
What is the Maximum number of volatile tables that can be created?
in teradata level primary in table level allows duplicates why?
what is differences between Fastload and Multiload as per DBA aspect ?
If a Node is busy what are the steps you can take to avoid ?
what is identity column in TD?
teradata support to automatically increase the character length or not?
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
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
what is meant by Hot amp?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE