Answer Posted / girish kumar

805- Token not found.
806- LOad module not found.
S013-18- Member not found.
502 - cursor not closed.
922- Authorization failed.
818 - Time stamp mismatch.
811 - Cursor not declared.
911- Dead lock
305 - Null indicator not defined.
311 - Length is not given for Var char.
S322 - Time out error.
S122 - Job canceled by the operator.
S222 - Operator cancel the job and doesn't request for dump
200 - Host variables not created.
204 - Table already crated.
551 - ID has no privileges to access the table.
803 - Index violation.

If I have a view which is a join of two or more tables, can this view be updateable?

1086

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2170

---

What does db2 stand for?

961

---

What is with ur in db2?

1245

---

What is the default page size of buffer pools?

1073

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1182

---

What is cursor with hold option in db2?

1013

---

What is check constraint. Explain with example.

1047

---

What is the reason behind not using select * in embedded sql programs?

1047

---

What is host variable in db2 cobol?

1032

---

List out the three types of page locks that can be held.

1093

---

What types of tables are there in the db2 database?

1008

---

Can we update view in db2?

946

---

Which command is used to remove all rows from a table?

1041

---

What is the difference between nvl and coalesce?

1009

---