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
- 11430 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 teradata?
what is object level locking ? where do appear this type of locking ?
What is meant by a Least Cost Plan?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is primary index and secondary index?
Why teradata is used?
Highlight a few of the important components of Teradata?
What is the use of stored procedures in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How do you define Teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
How many sessions of MAX is PE capable of handling at a particular time?
if collect stats but it show low confidence why?
