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?
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 |
How you will check the version of teradata?
What do you mean by fastexport in teradata?
Difference between Teradata V2R5 and Teradata V12 versions?
How do you eliminate duplicates?
write lock is compatiable with which type of lock?
how can i answer for question like teradat architecture in interveiw
Explain teradata vs. Redshift?
What is the purpose of indexes?
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What does Amp contain and what are all the operations that it performs?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
what is the difference between primary index and secondary index?.