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 different design perspectives used in teradata?

550


What is a three-tier data warehouse?

632


What are the main components of teradata system?

583


How to select first n records in teradata?

611


What are normalization, first normal form, second normal form and third normal form?

628






What is a node in teradata?

585


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

687


List out all forms of LOCKS that are available in Teradata.

556


Why teradata is used?

578


Which is faster fastload or multiload?

596


What do you mean by teradata intelliflex?

632


Write a program to show the parser component used in teradata?

550


What is multi insert?

628


Give a justifiable reason why Multi-load supports NUSI instead of USI.

676


What do you mean by caching in teradata?

609