× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



We have been looking into various ways of creating stored procedures on
the iSeries.

We don't have SQL installed on our 400s. Still trying to find out if
it's on the CD but has not been installed. 

Several attempts to find out what it costs. Still don't know. Ops Mgr
got a quote on Sequel.....

My boss has an old release of iSeries Navigator; I don't have any, yet.
We are both supposed to get the latest tomorrow.

We have been able to create a stored procedure using 'ROWSET' viewer
and also with iSeries Navigator and  SQLServer.

I also created a stored procedure from source in an SQLSRC file I
created. The object is a *PGM (CLE). Haven't figured out how to call it
from a CL pgm, yet. The compile fails : Can't find the 'definition'. 

My questions are:
What are the advantages of creating a stored procedure using iSeries
Navigator vs SQLServer tool vs C source vs RPGLE source? 

If we ever find out how much it costs, will it add to the functionality
of stored procedures if we can purchase SQL (and all its bits and
pieces)?

I know this sounds like we don't know what we are doing.....guess
what?? It's true. We've been reading forums, manuals, redbooks, etc.
(Hard to believe, isn't it?)

Thanks for any help you can throw our way.


Fran Denoncourt
Sr. Programmer/Analyst
Pinal County Treasurer's Office
Florence, AZ 85232
(520) 866-6404

Receipt of this message does not grant you permission to send me 
Unsolicited Commercial Email


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.