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
- 10027 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
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is the opening step in basic teradata query script?
Explain fallback in teradata?
What interface is used to connect to windows based applications?
What is inner join and outer join?
Why managing the data is important?
What is the purpose of joins in teradata and what are the available join types?
What is multi insert?
what are the day to day activities of teradata DBA ?
What are different table types used in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Can we collect statistics on table level?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the difference between union and union all in teradata?
Explain vproc in teradata?
