What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

What is null value in db2?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

---

What is the function of logging in the db2 database?

0 Answers  

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

---

Which components manage deadlocks in db2?

0 Answers  

---

What is the difference between Primary key and unique index?

6 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What language is db2 written in?

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---