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
- 10023 Views
- HCL, I also Faced
- E-Mail Answers
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
What are the uses of bynets in multi-node systems?
What are different table types used in teradata?
Did you write stored procedures in teradata?
How many codd's rules are satisfied by teradata database?
What is the syntax for case when statement?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain and compare pros and cons of snow flake schemas?
What are the various indexes in teradata?
Explain amp in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is the use of fallback?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are tpump utility limitations?
