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
- 11439 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
multistatementrequest: TD considers two or more sqls to be
processed during a single transaction. Example is BTET.
BT;
update emp set fname='tdguy';
update emp1set lname='tdguy';
ET;
Both the above sqls are considered as single transaction
and any error would lead to rollback of both the tables.
This is multistatement request.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / yuvaevergreen
macro - consists of one or more sqls. cannot consists of
more than one ddl,dcl.
stored procedure - more like a programming language.
consists of looping statements, conditional branching, input
and output variables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What are the steps to create a data model?
What is meant by MATCHTAG in multiload utility?
How can we load single row of data into teradata database. please give me the process.
What is oltp?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
List out all forms of LOCKS that are available in Teradata.
What are the different design perspectives used in teradata?
What are the different functions included in the server software?
Hash collision?
How do you eliminate duplicates?
What is the purpose of joins in teradata and what are the available join types?
List the logical and conditional operators that are used with teradata along with their meanings?
Teradata 
