insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9878In 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 19261I 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.
3264what 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 12577OUTER 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 6844Post New Syntel DB2 Interview Questions
How is a peoplecode function called?
What is an array in java?
Explain what are necessary tasks to install reportnet software?
How do I force delete a folder in windows 10?
How do I separate development from the production environment?
What are the formulas and functions of ms excel?
what is star schema? : Sas-di
what is credit management?
List some applications of tree-data structure?
what is meant by moulded case circuit breaker ?
How to restart app in objective c?
What is a z test?
How do I do a what if analysis in excel?
How to use values from other tables in update statements in ms sql server?
How blue prism interacts with an sap control to extend the functionality ?