RE: where are stored procedures on IBM i (Birgitta Hauser) -- MIDRANGE-L

Subject: RE: where are stored procedures on IBM i (Birgitta Hauser)
From: Timothy Feldmeier <Timothy.Feldmeier@xxxxxxxx>
Date: Mon, 11 Apr 2022 12:11:01 +0000
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

Stored procedures are in the PROCEDURES table. Do this to see what is in that library

SELECT * FROM PROCEDURES WHERE PROCSCHEMA = 'THELIBRARY' <---- Must be Capital

The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

RE: where are stored procedures on IBM i (Birgitta Hauser) , Rob Berendt

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.