Answer Posted / mna

The process of using cursor is:
1. declare the cursor in working storage: You will write
the SQL query here
2. open the declared cursor : this is when the actual SQL
query is executed and the fetched rows are moved to the
cursor storage.
3. Fetch rows from cursor : Reading rows one by one on the
Cursor just like we read records from a sequential file
4. Close cursor : While fetching if we get an SQLCODE=+100
it is the end of the cursor just like we encounter eof
while reading records from a sequential file. Once this
condition is encountered we will close the cursor.

B37 abend during spufi?

1405

---

Give the name of some fields form sqlca.

1022

---

Which component is responsible for db2 startup and shutdown?

981

---

What is ibm db2 database?

951

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1018

---

How can you quickly find out the # of rows updated after an update statement?

985

---

What is db2 connect?

1009

---

Define data page.

1012

---

Is db2 a mainframe database?

943

---

Define declaration generator (dclgen).

1067

---

What is the information associated with sysibm.syslinks table?

1056

---

Can we update view in db2?

945

---

Is ibm db2 open source?

1013

---

List out the data types available.

1081

---

What does a deadlock mean in DB2?

1095

---