insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 8301In 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 16114I 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.
2745what 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 11121OUTER 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 5953Post New Syntel DB2 Interview Questions
What are synchronous and asynchronous operations?
How many types of keys are there?
What are the special stocks used in mm?
Is the session factory thread safe?
who are the biggest bank of 2008 as the purpose of home loan services
Is mcafee slowing down my pc?
What is currency filter?
What is the quickest way to fetch the data from a table?
How to detect if a given key was pressed during application during startup?
what is enumset?
Which sorting algorithm is best for large data?
What are the features of eager execution?
What are the ecb and cbc modes?
What is the report to activate a feature?
Explain the term solrcloud.