Answer Posted / kumar

Hi ............
try this one ....might be a logical one ... but have to
give customers what they want.....

Select count(*) into :ws-count from emp with ur;

Declare CURSOR cursor1 for
Select *(if possible better code all fields)
from emp where count(*) < :ws-count;
Open cursor
Fetch cursor.

Declare CURSOR cursor2 for
Select *(if possible better code all fields)
from emp where

count(*) >= :ws-
count;
Open cursor
Fetch cursor.

Explain the contents that are a part of dclgen.

1137

---

What db2 400?

1250

---

Which component is responsible for processing sql statements and selecting access paths?

1175

---

How to check table size in db2 sap?

1095

---

Define sqlca.

1165

---

What is the purpose of using commit?

1153

---

What is the physical storage length of timestamp data type?

1148

---

Is ibm db2 open source?

1127

---

What does db2 plan contain?

1085

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2410

---

What is the difference between cursor stability and repeatable read isolation levels?

1236

---

What is db2 optimizer?

1309

---

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

1166

---

What are the bind parameters ibm db2?

1099

---

What's The Percentage Free Space ?

1282

---