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
- 10051 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 scenarios in which full table scans occurs?
What is the opening step in basic teradata query script?
Explain the advantages of partitioned primary index in a query?
What are tpump utility limitations?
What is the use of stored procedures in teradata?
What are the various indexes in teradata? Why are they preferred?
Name the five phases that come under MultiLoad Utility.
Why are oltp database designs not generally a good idea for a data warehouse?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Can we collect statistics on table level?
What do you mean by teradata intelliflex?
Explain and compare pros and cons of start schemas?
Highlight the need for Performance Tuning.
What is logical data model?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
