Re: SQLRPG getting the library where the file exists -- RPG400-L

Subject: Re: SQLRPG getting the library where the file exists
From: "Joe D" <nike@xxxxxxxxxxxxxx>
Date: Mon, 3 Mar 2008 08:28:44 -0800
List-archive: <http://archive.midrange.com/rpg400-l>
List-help: <mailto:rpg400-l-request@midrange.com?subject=help>
List-id: RPG programming on the AS400 / iSeries <rpg400-l.midrange.com>
List-post: <mailto:rpg400-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@midrange.com?subject=unsubscribe>

----- Original Message -----

From: <MWHopkins@xxxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Monday, March 03, 2008 8:11 AM
Subject: SQLRPG getting the library where the file exists

Is there a way to get the library name where a file is found in an sql
statement?

If the file is also defined in your F-Specs you could use the INFDS.

Or you could use the RtvObjD API.

I have used both techniques to determine the location of a file. I am not sure how overrides affect the two.

I do not know of a way using pure SQL to retrieve the library name, but it seems logical that there is one.

hth,
JD

Follow-Ups:

Re: SQLRPG getting the library where the file exists , rob

This mailing list archive is Copyright 1997-2026 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.