tag:blogger.com,1999:blog-9127696796045887209.post5865929609885848975..comments2023-11-22T10:29:10.462-08:00Comments on LK-TECH Academy: How To Create Stored Procedures Using iSeries NavigatorUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-9127696796045887209.post-71011756013254513702009-06-10T22:22:43.280-07:002009-06-10T22:22:43.280-07:00If you want to return result set of select command...If you want to return result set of select command, you can define a cursor for select command and open that cursor at the end of the SP. If you are planing to get a result using parameter you can define them as out parameters. You can do this when you create new SP using parameters tab and change In/Out value to OUT. Assign this OUT variable inside in the SP. You can directly read OUT parameter when you call your SP.nanhttps://www.blogger.com/profile/00897466355976896670noreply@blogger.comtag:blogger.com,1999:blog-9127696796045887209.post-682556929104223762009-06-10T07:29:42.121-07:002009-06-10T07:29:42.121-07:00Were you able to return result sets this way?Were you able to return result sets this way?chris miszturhttps://www.blogger.com/profile/09081816083041143049noreply@blogger.com