: MIDRANGE dot COM Mailing List Archive

Re: SQL & Library lists


AddThis Feed Button


This is not surprising as we don't have a QPGMR library. I guess it is
using
the User Name as a default schema name. How can I get it to use the library
list?
1. drop the procedure DROP PROCEDURE Lib/ProcName
2. change your current library to QGPL or none (*CRTDFT)
3. create your procedure CREATE PROCEDURE Procname
in/out parms
LANGUAGE RPGLE
NOT DETERMINISTIC
MODIFIES SQL DATA
EXTERNAL NAME Procname
PARAMETER STYLE GENERAL

Now you can query the file QSYS2/SYSROUTINE and look at EXTNAME.  If it
says *LIBL/Procname all should be ok

Craig Jacobsen





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2007 by MIDRANGE dot 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 here. If you have questions about this, please contact

.

counter