Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11608 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / tdguy
multistatementrequest: TD considers two or more sqls to be
processed during a single transaction. Example is BTET.
BT;
update emp set fname='tdguy';
update emp1set lname='tdguy';
ET;
Both the above sqls are considered as single transaction
and any error would lead to rollback of both the tables.
This is multistatement request.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is smp and mpp platforms?
What are the functions of a teradata dba?
How can bottlenecks be identified?
Difference between star and snowflake schemas?
Describe the between keyword in teradata?
How do you determine the number of sessions?
Explain the most common data types used in teradata?
What is meant by a Channel Driver?
What does Amp contain and what are all the operations that it performs?
How many sessions of MAX is PE capable of handling at a particular time?
What is a dimension table?
What are the various indexes in teradata? How to use them?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the different functions included in the server software?
What is the multi-insert?
