How many sub queries can you combine together ?
Answers were Sorted based on User's Feedback
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What is db2 bind process?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
How do you filter out the rows retrieved from a Db2 table ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
max number of columns in a db2 table?
What is bind and rebind in db2?
How to rename a table in DB2 ?
Explain the contents that are a part of dclgen.
What is a LIKE table and how is it created?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..