insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9044In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
8 17176I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
2955what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
2 11675OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
1 6298Post New Syntel DB2 Interview Questions
Define test strategy.
What do you discuss in daily stand up meeting?
What is variable trace?
Why overfitting occurs?
If possible send me screenshot doc for installation of ecc6
Why does abstract class have constructor?
Does weight affect how far you jump?
what is Property......End Property loop? how to write sript for it in QTP
What is difference between metadata and manifest?
How many rows can an access table hold?
What will happen to exchange 2013 rtm version when 120 days trial period expires?
How will you change the instance type for instances which are running in your application tier and are using Auto Scaling? Where will you change it?
explain about mergers & aquisitions? asked on 30/7/09
How to prepare HSD statements in tally
Are you planning to continue your studies and training at Farmfoods?