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
- 11501 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 are some primary characteristics of teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Difference between star and snowflake schemas?
What are the multiload utility limitations?
What do you mean by teradata sql assistant?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are differences between teradata and ansi session modes in teradata?
Explain some differences between mpp and smp?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the various indexes in teradata?
Explain the meaning of Amp?
Explain BYNET.
What is the purpose of using case expression in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain the term 'database' related to relational database management system?
