File library parameter with *SQL -- WEB400

Subject: File library parameter with *SQL
From: "Tom Deskevich" <thomas.l.deskevich@xxxxxxxxxxxxx>
Date: Mon, 1 Mar 2010 10:00:08 -0500
List-archive: <http://archive.midrange.com/web400>
List-help: <mailto:web400-request@midrange.com?subject=help>
List-id: Web Enabling the AS400 / iSeries <web400.midrange.com>
List-post: <mailto:web400@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/web400>, <mailto:web400-request@midrange.com?subject=unsubscribe>

I found a mention on this list that stated that you do not have to hard code
the library name in a stored procedure created on the AS/400. I was
wondering if someone has an example of this. I have tried to pass the
library name to the stored procedure and do a SET SCHEMA, but it seems to
ignore this.

All of our stored procedures have LIBRARYNAME.FILENAME, and am told this is
the only way to do this.

Tom Deskevich

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.