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?
- 3 Answers
- 10001 Views
- HCL, I also Faced
- E-Mail Answers
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
Explain the term 'row' related to relational database management system?
What are the various indexes in teradata? How to use them?
What are different table types used in teradata?
What is dimensional modeling?
Explain amp in teradata?
Why do you get spool space errors? How do trouble-shoot them?
How you will check the version of teradata?
What is bteq utility in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are types of partition primary index (ppi) in teradata?
how many modules are there in telecome domain?how to explain the architecture?
How to select first n records in teradata?
What is the use of fallback?
What are the 5 phases in a multiload utility?
Highlight the advantages of PPI(Partition Primary Index).
