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 scenarios in which full table scans occurs?

730


Why is the case expression used in teradata?

780


What is meant by a dispatcher?

748


Highlight all the modes that are present under Confidence Level.

727


Which is faster fastload or multiload?

795


How does hashing happens in teradata?

815


Explain the term 'foreign key' related to relational database management system?

727


If a Node is busy what are the steps you can take to avoid ?

2076


Explain the advantages of partitioned primary index in a query?

753


What are the different softwares used with their functions in teradata?

758


Difference between stored procedure and macro?

894


What are differences between teradata and ansi session modes in teradata?

845


What are the functions of a teradata dba?

775


How would you load a very large file in teradata in general? What utility would you use for it? Why?

830


What are the various indexes in teradata?

752