Re: SQL equivalent of query/400 needed

I'm not sure I like that last bit. If I explicitly name a library.file, and
then someone sets the current schema to a different library, it ignores my
pointing to where I wanted it to go in the first place? What happens
when/if the file is not found the the current schema?

Jim

On 9/28/07, CRPence <crp@xxxxxxxxxxxxxxxxxxxx> wrote:

Kind of a nit pick, so only in an attempt to clarify [yet surely to
further confuse some unfamiliar with the naming options], I will respond
with...
Effectively. But if library.FILE1 naming is allowed, then it
would not be a library-list issue, but instead an issue with a specific
library due to NAMING(*SQL). That naming would have the unqualified
file name FILE1, being searched and found in the library name matching
the authorization ID; i.e. the name of the user performing the SQL, due
to an implicit SET CURRENT SCHEMA USER
To further confuse, if the SET CURRENT SCHEMA aLibrary had been
issued, then that library aLibrary instead. And in that case, that
named library would be used, irrespective of the specified NAMING().

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor views of my
employer

Jim Essinger wrote:

As others have said, it may be a library list issue, There are things

that

you can try, and one is to point the query to the correct library like

this;

SELECT COUNT(*) FROM libname.FILE1 A, libname.FILE2 B
where
A.SBKRNM = B.SRCDTA
AND( A.SQCDE IN('SA', 'SB', 'SD', 'SG', 'SH'))

That way you eliminate any doubt about what file is being used.

--
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.