|
This is a multipart message in MIME format. -- [ Picked text/plain from multipart/alternative ] Gerald, 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? 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/17/2002 06:37 PM Please respond to midrange-l To: <midrange-l@midrange.com> cc: Fax to: Subject: Interactive SQL select verb bug??? I have an issue where the case of the select verb (SELECT vs select), in an interactive SQL session, was affecting the records selected for the result set. We have since determined that it has something to do with exiting and saving the interactive SQL session. After exiting and saving an inteactive SQL session, and then at the command line, we remove a library from the library list and then restart the saved sql session, the current library list appears to not be utilized (by the re-started sql session) but instead, the library list used is from when the session was ended/saved (it doesn't reflect the new library list after it was altered). Then during the restarted sql session, changing the case of the select verb will result in different record sets being displayed and if we display the job via sys-req #3 and look at the library list, (in either circumstance) the library lists are identical, but the records are from different files in different libraries (one of which is in a library that is no longer in the library list, (but it was in the library list in of the saved sql session, before the session was ended and the library list was changed)). Is there any way to remedy this annoyance? Is this a bug or a feature? We are running V5R1, and have all the current ptf's as of 8/2/2002. Thanks in advance. Jerry Kern _______________________________________________ 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.
As an Amazon Associate we earn from qualifying purchases.
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.