Another SQL-newbie UDF question: qualifying with a library passed as a variable -- MIDRANGE-L

Subject: Another SQL-newbie UDF question: qualifying with a library passed as a variable
From: James Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Date: Fri, 29 Apr 2011 09:05:02 -0700
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Situation: I have a UDF that, because it's using unqualified filenames on SELECTs, can get confused about where to go for its data, if the library list is the list bit funky.

But the target library is not known at creation time.

I'd like to pass the library as a parameter. But is there a way to qualify the filename on a SELECT, using a variable (in this case, a parameter) as the library name?

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Another SQL-newbie UDF question: qualifying with a library passed as a variable , Dennis
RE: Another SQL-newbie UDF question: qualifying with a library passed as a variable , Schutte, Michael D

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.