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
- 10860 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
Difference between multiload and tpump?
Did you write stored procedures in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What do you mean by teradata intelliflex?
What is the purpose of indexes?
How many codd's rules are satisfied by teradata database?
What is the maximum number of dml can be coded in a multiload script?
What are the various indexes in teradata? How to use them?
What is teradata? What are some primary characteristics of teradata?
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?
What is the purpose of upsert command?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the primary index in teradata?
How do you set the session mode parameters in bteq?
