Re: StrSQL F4 invite

David FOXWELL wrote:

Birgitta Hauser wrote:

David FOXWELL wrote:

All of a sudden I can no longer press F4 to choose the
list of fields for SELECT. Unless I qualify the file
name with the library. Despite of course, the file
being in my library list.

Is this a known problem?

How are you qualifying your file, with Shash or Dot between Library and File? If it is dot, you moved to SQL naming and
SQL naming does not search the library list. In STRSQL Press
F13, Option 1 and change the naming conventions back to *SYS.

It wasn't that Birgitta, I compared 2 SQL sessions and found
one had *ALL for the library list, the other *LIBL. Switching
to *LIBL fixed it.

But of course an unqualified name using *ALL, the prompt request should be able to find [albeit slower & more CPU+mem] the named and existent database *FILE just as with *LIBL? To be clear, the *LIBL is a subset of *ALL. Thus the error message as result would seem to be in error.?

FWiW: There was an APAR SE21612 in v5r3 which boldly claims to have definitively corrected in a PTF, the condition SQL6048 [left unstated but presumably F/QSQILVL3] for having used F4=Prompt on the "SELECT fields" of a prompted SELECT statement. The origins for the message being issued incorrectly, are not stated in the APAR text.
http://www-01.ibm.com/support/docview.wss?uid=nas36b39fb1ef00f1a1e86257060004853a7

Regards, Chuck