Midrange News for the IBM i Community

Posted by: dougcmh
Columbus, OH
Host variables in Run SQL Scripts
has no ratings.
Published: 23 Nov 2011
Revised: 23 Jan 2013 - 1979 days ago
Last viewed on: 25 Jun 2018 (4094 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Host variables in Run SQL Scripts Published by: dougcmh on 23 Nov 2011 view comments(2)

I have a dumb question, but this has been plaguing me all morning.


I wrote a stored procedure (6.1, btw).

It has no result sets, but it does have some INOUT and OUT parms.

It is external - it calls an RPGLE program.


I wish to test the stored procedure now.

I am trying to test it in Run SQL Scripts.


My question - How, on God's glorious green globe, do I declare and use host variables in Run SQL Scripts?

Return to midrangenews.com home page.
Sort Ascend | Descend