Re: Interactive SQL select verb bug???

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
The option 14 will tell you which library it is picking it from.  While
you may 'know' this based on the content of the data, it is nice to verify
this.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Gerald P. Kern" <gkern@buckeye-express.com>
Sent by: midrange-l-admin@midrange.com
08/19/2002 10:14 PM
Please respond to midrange-l


        To:     <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        Re: Interactive SQL select verb bug???


Rob,

Not sure I understand your comment:

"If you do your SELECT statement and have in on your 5250, and then hit
sysreq 3, option 14, which library contains the file?
And, there is nothing under option 15 which may apply, is there?"

I'm not sure what you are saying in the portion "have in on your 5250".

What happens is that the records shown are from a file that is no longer
in
the job's library list (when the verb is all uppercase - it appears the
saved SQL statement uses the library list from when the sql session was
saved). When the verb is lowercase the records are from the file that is
in
the library list.

And there are no overrides active at any time.

Gerald


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.