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
What are default access rights in teradata? What explicit right can be given to a user?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is a clique?
Explain the term 'database' related to relational database management system?
How many codd's rules are satisfied by teradata database?
What are the string manipulation operators and functions associated with teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How do you verify a complicated sql?
What are the multiload utility limitations?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight the points of differences between the database and user in Teradata.
What are the design features involved in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com