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
How to view every column and the columns contained in indexes in teradata?
What do you mean by teradata intellicloud?
What are the functions performed by bynet?
Explain and compare pros and cons of start schemas?
What are the various indexes in teradata?
What is the command in bteq to check for session settings ?
What are the different design perspectives used in teradata?
What can be achieved by using the teradata rdbms?
What are the components used in smp and massively parallel processing (mpp) machines?
What is meant by a Channel Driver?
What are the different methods ot loading a dimension table? A fact table etc?
Explain amp in teradata?
Define views in teradata with general syntax.
What are aggregate tables? How do you design them using teradata?
What is meant by a Virtual Disk?