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

Which is faster fastload or multiload?

673


how do you manage the production space. what are the proactive methods you can take ?

1561


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

618


Explain teradata architecture?

720


What is a three-tier data warehouse?

700






What is the difference between fastload and multiload? Which one is faster?

726


Explain the types of join supports by teradata?

664


What is the difference between teradata and oracle?

651


What are the various indexes in teradata? How to use them? Why are they preferred?

681


What is node? How many nodes and amps used in your previous project?

756


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

736


What is collect statistics?

669


What are aggregate tables? How do you design them using teradata?

731


What are some primary characteristics of teradata?

638


How is MLOAD Client System restarted after execution?

689