Re: SQL equivalent of query/400 needed

["Jim Essinger" <dilbernator@xxxxxxxxx>]

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.