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
multi statement request consists of more than one sql
statements. Semi colon placed in middle or beginning of sql
requests identifies the multi statement request. Only DML
statements can be included in the MSR. In ansi mode, multi
statement requests are to be committed by COMMIT. In
teradata mode, explicitly by BT and ET or implicitly.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the various reporting tools in the market?
What are the different design perspectives used in teradata?
In Teradata, how do we Generate Sequence?
What is a node in teradata? Explain
What are the primary characteristics of the Teradata.
How would you load a very large file in teradata in general?
What is the use of stored procedures in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is bteq utility in teradata?
Explain Teradata performance tuning and optimization?
How do you see a ddl for an existing table?
List the logical and conditional operators that are used with teradata along with their meanings?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is a level of granularity of a fact table?
What are the functions of a Parser?