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
- 11557 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 the use of fallback?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Highlight the limitations of TPUMP Utility.
Comment whether bottleneck is an error or not.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
If a Node is busy what are the steps you can take to avoid ?
How can bottlenecks be identified?
What is teradata?
What is the difference between global temporary tables and volatile temporary tables?
What do you mean by fastexport in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How is MLOAD Client System restarted after execution?
What are the various reporting tools in the market?
In general, how do you optimze any sql in teradata?
What is the basic syntax for teradata select statement?
