Can I use FETCH statements on SPUFI in DB2

sakthivel_t100 · New User Joined: 03 Aug 2007 Posts: 10 Location: chennai

Hi All,
Can I use FETCH statements on SPUFI in DB2 ? If possible can you please give me Syntax of the FETCH statemnts ?

Thanks

ashwinreddy · Posted: Thu Aug 23, 2007 12:56 am

Hi,

You can't do it man, why you need it all the data would be displayed in the output screen.

Cheers
Ashwin

ashwinreddy · Posted: Thu Aug 23, 2007 12:59 am

Hi,

Do you mean the same questions or you have missed anything or was a typo mistake.

Please send us your extact question.

Cheers
Ashwin

Craq Giegerich · Posted: Thu Aug 23, 2007 1:00 am

dick scherrer · Posted: Thu Aug 23, 2007 3:08 am

Hello,

SPUFI can/will return multiple rows for your SELECT.

In a program, you use a cursor when your SELECT might return more than 1 row.