what is a multi statement request in TD?
what is the diif b/w V2R5 & TD12?
what is the diff b/w MACRO & STORED PROCEDURE?

Answer Posted / yuvaevergreen

macro - consists of one or more sqls. cannot consists of
more than one ddl,dcl.
stored procedure - more like a programming language.
consists of looping statements, conditional branching, input
and output variables.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the available primary index types?

720


What tools would you use for that?

571


Explain teradata architecture?

636


What is collect statistics?

589


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3002






Can you fastexport a field, which is primary key by putting equality on that key?

711


Name the five phases that come under MultiLoad Utility.

586


What are the uses of bynets in multi-node systems?

590


Highlight the limitations of TPUMP Utility.

608


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 ?

1900


In Teradata, what is the significance of UPSERT command?

597


What are the frequently used data types in teradata?

602


How can we check the version of Teradata that we are using currently?

595


What is the meaning of Caching in Teradata?

695


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1965