Answer Posted / om prakash yadav

Note= Before i given the query it is worng pleas ignopre it.
Thanks.
========================================

using cursors you can do>


CURSOR Crs_trs IS
SELECT empno, empname, sal, deptno from emp WHERE empno
between 100 and 200;

vr_empno.empno%type;
vr_empname.empname%type;
vr_sal.sal%type;
vr_deptno.deptno%type;

BEGIN
OPEN Crs_trs;
IF crs_trs%ISOPEN THEN
LOOP
FETCH Crs_trs INTO vr_empno, vr_empname, vr_sal, vr_deptno;

dbms_output.put_line('empno__'||vr_empno );
dbms_output.put_line('empname__'||vr_empname);
dbms_output.put_line('empsalary__'||vr_empsal );
dbms_output.put_line('empdeptno__'|| vr_deptno);

EXIT WHEN Crs_trs%NOTFOUND;
END IF;
END LOOP;
CLOSE Crs_trs;
END;

What is schema in db2?

1007

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3141

---

What is copy pending status in db2?

1104

---

What is buffer pool in the db2 database?

1081

---

i want to maintain uniqueness on pdf without make lf??????????

2147

---

What is lock escalation in db2?

1006

---

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

1116

---

What is the physical storage length of date data type?

1234

---

What is table space in db2?

1006

---

Define declaration generator (dclgen).

1098

---

What is the physical storage length of timestamp data type?

1075

---

What is cobol db2?

982

---

what is utility for parm lib

2350

---

How to fetch the last row from the table in SQL (db2)?

1632

---

How do you pull up a query which was previously saved in qmf?

1138

---