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
- 11475 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
macro - consists of one or more sqls. cannot consists of
more than one ddl,dcl.
stored procedure - more like a programming language.
consists of looping statements, conditional branching, input
and output variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / yuvaevergreen
multi statement request consists of more than one sql
statements. Semi colon placed in middle or beginning of sql
requests identifies the multi statement request. Only DML
statements can be included in the MSR. In ansi mode, multi
statement requests are to be committed by COMMIT. In
teradata mode, explicitly by BT and ET or implicitly.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the syntax for case when statement?
What are the enhanced features in teradata v2r5 and v2r6?
What is meant by Teradata Gateway?
Highlight a few of the important components of Teradata?
Fast Load Script is failed and error tables are available then how do you restart?
Highlight the points of differences between the database and user in Teradata.
What are the various indexes in teradata? How to use them? Why are they preferred?
If a Node is busy what are the steps you can take to avoid ?
What is the command in bteq to check for session settings ?
What is difference between user and database in teradata?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
Can we collect statistics on table level?
Teradata 
