Re: Registering SQL stored procedures

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

In the view QSYS2/SYSPROCS. QSYS2 is where the system catalog is located - 
PDM has nothing to do with SQL.

Vern

At 05:30 PM 9/13/2004, you wrote:
> I just registered a trivial RPG test program as my first SQL external
> stored procedure (using Colin Bell's "SQuirreL" SQL client). It works
> exactly as intended, but I'm curious:
>
> Just where does this registration get stored? The Stored Procedures
> redbook example (which demonstrates registering the stored procedure using
> iSeries Navigator) shows it appearing in the library as seen from iSeries
> Navigator, but when I look at the library in PDM, I don't find anything
> that wasn't there before I registered the stored procedure; neither does a
> DSPOBJD on the name, with both the library and OBJTYPE set to *ALL, turn
> up anything new. Yet from SQuirreL, it definitely shows up, and persists
> even after I close it down.
>
> Just how are these things stored?
>
> --
> JHHL
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.