insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9762In 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 19006I 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.
3218what 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 12450OUTER 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 6766Post New Syntel DB2 Interview Questions
What is equals method?
How is catalog the different content tab in sap hana?
Which bit wise operator is suitable for checking whether a particular bit is on or off?
What is difference between mysql and mariadb?
What is typeofchecks in angular 8?
What is the significance of placenta?
What is post recovery scenario?
Tell us about the spring framework.
What are expressions c#?
How to parse xml?
CDPATH shell variable is in(c-shell)
Will windows use linux kernel?
How to declare a function in scala?
Is mongodb free for commercial?
What is vocoder?