how to fetch multiple records without using cursor

Answers were Sorted based on User's Feedback



how to fetch multiple records without using cursor..

Answer / m4io

it is not possible in db2 v8 : you still need a cursor.
However : you can fetch 100 rows in one fetch.

01 host-variables.
05 HV-col1-ARRAY PIC s9(04) COMP OCCURS 100 TIMES.
05 HV-col2-ARRAY PIC x(40) OCCURS 100 TIMES.
05 HV-vcol3-ARRAY OCCURS 100 TIMES.
49 HV-vcol3-len-ARRAY PIC s9(04) COMP.
49 HV-vcol3-txt-ARRAY PIC x(40).
05 HV-IND2-ARRAY PIC s9(04) COMP OCCURS 100 TIMES.
I

DECLARE csr1 CURSOR WITH ROWSET POSITIONING for select
col1, col2, vcol3 from ...

open cursor

FETCH NEXT ROWSET FROM csr1 FOR 100 ROWS
INTO :HV-col1-ARRAY,
:HV-col2-ARRAY:HV-IND2-Array,
:HV-vcol3-ARRAY

Is This Answer Correct ?    13 Yes 2 No

how to fetch multiple records without using cursor..

Answer / rajni

U cant fatch the record without using cursor.

Is This Answer Correct ?    6 Yes 4 No

how to fetch multiple records without using cursor..

Answer / shailendra

its not possible.

Is This Answer Correct ?    3 Yes 3 No

how to fetch multiple records without using cursor..

Answer / om yaddav

hi srini......
how can do in DB@...
?
write with sentax with example.
thans

Is This Answer Correct ?    0 Yes 0 No

how to fetch multiple records without using cursor..

Answer / rookie

#6
I think that answer #6 is definately a food for thought.
Logically speaking that's definately possible, but can
anyone verify it practically:-)
I think it should work....nothing wrong in logic.

Is This Answer Correct ?    0 Yes 0 No

how to fetch multiple records without using cursor..

Answer / premil

It can be done with the help of dynamic sql queries
(prepare,execute).
but i dont remember the syntax...
sorry ...

Is This Answer Correct ?    0 Yes 0 No

how to fetch multiple records without using cursor..

Answer / mahyn

However if we want to fetch and process multiple rows
without using cursor, we can do with the below psuedo code.

assume that seq_num is unique.
h-seq initilized with spaces.

perform until sqlcode = +100 or h-seq >= 500
exec sql
select seq_num into :seq-num from tablename
where seq_num > :h-seq
order by Seq_num with ur;
fetch first 1 row only
end-exec
operations
move seq-num to h-seq
end-perform

Is This Answer Correct ?    0 Yes 0 No

how to fetch multiple records without using cursor..

Answer / chakradhar patra

Yes its possible in NATURAL using MULTI-FETCH Option.

Is This Answer Correct ?    0 Yes 0 No

how to fetch multiple records without using cursor..

Answer / ram g

if u r talking about host language app pgm its not
posssible dats d reason we are hving cursor logic...
in select stmt its quite possible by having condtn in whr
clause such a way it can fetch multiple record..

Is This Answer Correct ?    3 Yes 4 No

how to fetch multiple records without using cursor..

Answer / sivakumar sekharannair

None of the host languages can handle multiple records at a
time.
But i think if we know the number of rows that will be
retreived then we can load the records into a internal
table and then process it as required...
Any thoughts!!!!!!

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What does the CHECK Utility do ?

1 Answers  


What is a Database Request Module(DBRM)?

4 Answers  


what is different three logs in DB2?

1 Answers   Syntel,


What is the result of open cursor statement?

0 Answers  


How to execute stored procedures?

0 Answers  


How can we read records for specific member in CL? AND rpg?

0 Answers  


What is the meaning of -805 SQL return code?

3 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,


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,


cobol-db2 runjcl please?

2 Answers   DELL,


What is package in cobol db2?

0 Answers  


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

0 Answers  


Categories