DB2 Store Procedure Using Fetch Cursor

humnova

New Member

Join Date: Jan 2008

Posts: 1
#1

DB2 Store Procedure Using Fetch Cursor

Feb 8 '08, 12:10 PM

hi,
can anybody send me a exampale of script of DB2 (AS/400) Store Procedure using Declare/Open/Fetch Cursor
thanks
Tags: None
sakumar9

Recognized Expert New Member

Join Date: Jan 2008

Posts: 127
#2

Feb 11 '08, 06:39 AM

Originally posted by humnova

hi,
can anybody send me a exampale of script of DB2 (AS/400) Store Procedure using Declare/Open/Fetch Cursor
thanks

You can refer to samples present in SQLLIB/samples/sqlproc. In this directory, you will find many SPs that uses cursors and FETCH SELECTS.

Regards
-- Sanjay
Comment

Comment