insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 8307In 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 16130I 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.
2749what 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 11128OUTER 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 5958Post New Syntel DB2 Interview Questions
How can we add the new menu to drupal admin section?
Define nic?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
Can we alter stored procedure?
Is bgp layer 3 or 4?
Explain the difference between cfm (cubic feet per minute) and scfm (standard cubic feet per minute)?
What are the features of the c language?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What are the key business process in SAP SRM?
How I can control asset documents without GR/IR?
What are the name and the uid of the administrator user?
What are decorators in angular?
That Schema is Best in Performance?
explain about group scopes? : Windows server 2003
From where apache names comes?