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
- 10000 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
Highlight a few of the advantages that ETL tools have over Teradata.
Describe the set operators in teradata.
What are the steps involved in the process flow of the sql statement through channel attached system?
Why are oltp database designs not generally a good idea for a data warehouse?
what are the uses of fact table and dimension table in banking project?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Steps to create a data model?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the functions involved in shared information architecture?
In BTEQ, how are the session-mode parameters being set?
In Teradata, what is the significance of UPSERT command?
Describe primary index in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What do you mean by fastexport in teradata?
What happens in a conflict? How do you handle that?
