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 |
Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance
What are normalization, first normal form, second normal form and third normal form?
What happens in a conflict? How do you handle that?
List out some of the primary characteristics of teradata.
What do high confidence, low confidence and no confidence mean in explain plan?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
How do you do backup and recovery in teradata?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Explain how spool space is used.
What are default access rights in teradata?