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
- 11757 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 the different table types supported by teradata?
How do you determine the number of sessions?
In the Primary Index, what is the score of AMPs that are actively involved?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is node? How many nodes and amps used in your previous project?
Can we collect statistics on multiple columns?
What are the steps involved in the process flow of the sql statement through channel attached system?
What do you mean by teradata intelliflex?
What is dimensional modeling?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is meant by a Least Cost Plan?
What are differences between teradata and ansi session modes in teradata?
Explain vproc in teradata?
How is the teradata different from oracle?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
