insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9735In 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 18946I 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.
3198what 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 12413OUTER 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 6751Post New Syntel DB2 Interview Questions
Does stringutils isempty check for null?
How are extents allocated to a segment?
Tell me when does the condition 'rendezvous' arise?
What command do we use to rename a db, a table and a column?
What is the purpose of behaviour driven development (bdd) methodology in the real world?
What is windows host process rundll32 virus?
Tell us two differences between new () and malloc ()?
What are the major errors in bw and r3 pertaining to bw?
What is composite data type in pl sql?
How do I count days in excel?
How to delete file in php?
How do you summarize data in excel?
Is it possible make a call to server side event of any button using javascript?
What is the advantage of linq over stored procedures?
Is it possible to configure the system to pick up a different exchange rate type for a particular transaction?