Connecting Tech Pros Worldwide Forums | Help | Site Map
bytes > topic > db2 > answers

DB2 Store Procedure Using Fetch Cursor

Newbie
  
Join Date: Jan 2008
Posts: 1
#1: Feb 8 '08
hi,
can anybody send me a exampale of script of DB2 (AS/400) Store Procedure using Declare/Open/Fetch Cursor
thanks

sakumar9's Avatar
Expert
  
Join Date: Jan 2008
Location: Bangalore
Posts: 127
#2: Feb 11 '08

re: DB2 Store Procedure Using Fetch Cursor

Quote:

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
Reply

« previous question | next question »

Similar DB2 Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,449 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved