|
Try this link - http://www.tools400.de/Downloads/Freeware/Code/sqlcli.zip And the manual at infocenter is essential. HTH Vern At 11:33 AM 11/18/2006, you wrote:
I have a stored proc as below, I like to write RPGLE by issuing CALL to stored proc to generate result set into a file? is that possible for below stored procedure format?CREATE PROCEDURE MyLib.MyProcedure IN ( VARIABLES; ) DYNAMIC RESULT SETS 1 LANGUAGE SQL BEGIN END. Vernon Hamberg <vhamberg@xxxxxxxxxxx> wrote: Donna - you have to use CLI (call level interface) to get result sets from stored procedures in RPG. It's not too hard - you could do a search in the list archives and find a link to some good starting out stuff. At 09:10 PM 11/17/2006, you wrote: >Hi > I have a stored proc as below which is very huge, when I try to > run STRQMQRY it says SQL length is big and its failing. > > I want to create a file out of this result set, since I > understood I won't be able to call stored proc from CL program and > QMQRY is nt working due to some constraints on my source files, I > decided to code RPGLE in which Iam going to call this stored proc , > my objective is when I call this RPGLE it should create a > file/report of my resultset out of stored proc. > > Some one advised me that I cannot return a result from a > procedure in RPGLE or SQL when dynamic result sets 1 (see below > code). You can only return a result set from a procedure when you > are using odbc or jdbc. Is that true? > > How do I create a file out of my result set in stored proc in > RPGLE? any examples/sample code or any pointers are highly appreciated. > > ------------------------------------------------ > I cant publish my stored proc since its very huge around 5000 lines. > > CREATE PROCEDURE MyLib.MyProcedure >IN ( > > >VARIABLES; > > >) >DYNAMIC RESULT SETS 1 >LANGUAGE SQL >BEGIN > > > > > >END. >---------------------------------------------------------------- > > >Thanks, > >Donna. > >--------------------------------- >Check out the all-new Yahoo! Mail beta - Fire up a more powerful >email and get things done faster. >-- >This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list >To post a message email: RPG400-L@xxxxxxxxxxxx >To subscribe, unsubscribe, or change list options, >visit: http://lists.midrange.com/mailman/listinfo/rpg400-l >or email: RPG400-L-request@xxxxxxxxxxxx >Before posting, please take a moment to review the archives >at http://archive.midrange.com/rpg400-l. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l. Thanks, Donna. --------------------------------- Everyone is raving about the all-new Yahoo! Mail beta. -- This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.