insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
3 9613In 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 18645I 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.
3147what 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 12287OUTER 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 6668Post New Syntel DB2 Interview Questions
How we can communicate (voice communication) in LAN by using core java?
how many students appear in gate exam
What does the f4 key do?
Which sorting is best for large data?
How can you find overfitting in tensforflow ? How can you avoid it ?
What is the function func_num_args() used for?
What are the components?
What is the singleton pattern?
What is UNIX?
What are the new security features added in sql server 2012? : sql server security
What is an asynchronous api?
How can you pass a variable by reference?
What are the different servers and difference between them?
What percentage increase in sales did you contribute to you previous companies?
Explain the different steps that are involved in final inspection process?