insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9647In 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 18723I 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.
3161what 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 12334OUTER 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 6692Post New Syntel DB2 Interview Questions
What is explain in db2?
Explain the available thread states in a high-level?
To write messages to the screen without using "document.write()"?
Define bare-metal node?
how to find Developments system to get authorised?
Why null is not allowed in treemap?
What is meant by mysqli?
How can I get access to the web application of sap cloud platform integration to be able to configure the cloud integration packages?
Are c# references the same as c++ references?
Suppose the production is more and sales less then what will happen
What is tuple with example?
What is sql server and ase?
How do I change directory in cmd to desktop?
List similarities and differences between oracle & sybase.
Describe wild pointers in c?