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
- 10040 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
What is the purpose of using case expression in teradata?
How do you define Teradata?
Where is teradata rdbms used?
How do you do backup and recovery in teradata?
What are the different softwares used with their functions in teradata?
Explain the most common data types used in teradata?
What is a dimension table?
What happens when a node suffers a downfall?
Did you write stored procedures in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What exactly do you know about catching in teradata?
Why managing the data is important?
What is meant by Teradata Gateway?
What are the 5 phases in a multiload utility?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
