What are the three lock types?
Answers were Sorted based on User's Feedback
Is Cursor exicutable ?
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..
wht are the restrictions for union ?
What is catalog database in db2?
How do I add a column to an existing table in db2?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What is the information associated with sysibm.syslinks table?
How do I add a column in db2?
How do you pull up a query which was previously saved in qmf?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to find primary key of a table in db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.