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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by teradata sql assistant?

673


Explain the teradata primary index mechanics in detail with a diagram.

652


Explain the types of join supports by teradata?

664


What is teradata? Also, list out some of the primary characteristics of teradata.

663


Explain and compare pros and cons of snow flake schemas?

696






How is the teradata different from oracle?

710


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

1857


what is sysdba and sysdbc ? which has high priority ?

3439


Explain amp in teradata?

646


If RDBMS is halted what will you do ?

1794


What is the use of having index on table?

658


What are the joins in teradata and how many types of joins are there in teradata?

654


List out teradata data types?

633


What are the updated features of teradata?

670


Highlight the differences between Primary Key and Primary Index.

708