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?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the advantages of partitioned primary index in a query?
What are the design features involved in teradata?
Highlight the points of differences between the database and user in Teradata.
Highlight a few of the important components of Teradata?
What is the purpose of indexes?
Explain the types of join supports by teradata?
Explain the term 'primary key' related to relational database management system?
What is the difference between fastload and multiload? Which one is faster?
How can we check the version of Teradata that we are using currently?
What is the command in bteq to check for session settings ?
what are the day to day activities of teradata DBA ?
Explain amp in teradata?
What is inner join and outer join?
What is the syntax for case when statement?
How does hashing happens in teradata?