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
- 11756 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 is the purpose of indexes?
What is the function of parser component in teradata?
what is object level locking ? where do appear this type of locking ?
What is the use of fallback?
Differentiate database data and data warehouse data?
What is multi insert?
What type of indexing mechanism do we need to use for a typical data warehouse?
What is the difference between fastload and multiload? Which one is faster?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is the use of having index on table?
What is meant by a dispatcher?
Explain the new features of teradata?
What is upsert statement in teradata?
What are some commonly used bteq scripts?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
