AW: STRQMQRY Library List Issue Possibly Related to 7.1 Upgrade

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Is WEIRDLIB the user profile that executes the query?
In either way check the query manager profile that runs the QMQuery if SQL
or System Naming is used.
If SQL naming is used try to change the profile to system naming.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Emily Smith
Gesendet: Tuesday, 01. November 2011 16:51
An: 'midrange-l@xxxxxxxxxxxx'
Betreff: STRQMQRY Library List Issue Possibly Related to 7.1 Upgrade

Here's my query (field and file names obfuscated due to company policy).

SELECT FIELD1, FIELD2, FIELD3, FIELD4
FROM FILE1
LEFT OUTER JOIN FILE2
ON FIELD1 = FIELDA
ORDER BY FIELD1 ASC, FIELDB ASC

Prior to upgrading this was run from a CLLE program using the STRQMQRY
command and used 'FILE1' and 'FILE2' from the user's library list. Since
upgrading (which I know may just be coincidence), the STRQMQRY command
fails. A check of the user's job  log reveals the following:
FILE1 in WEIRDLIB type *FILE not found
RUN QUERY command failed with SQLCODE -204.

What I can't figure out is where WEIRDLIB is coming from. It isn't
hard-coded in the query. The library does exist, but is not anywhere in the
users library list. I've also verified that WEIRDLIB isn't set as the users
CURLIB.
If I run the STRQMQRY command myself from a command line it also fails
trying to find FILE1 in WEIRDLIB. However, it runs to completion with no
errors if I run the query using option 9 from 'Work With Query Management
Queries'.

What am I missing?

Emily Smith
CONFIDENTIALITY NOTICE:  This email message is private, confidential
property of the sender, and the materials may be privileged communications
intended solely for the receipt, use, benefit, and information of the
intended recipient, you are hereby notified that any review, disclosure,
distribution, copying, or taking of any other action in reference to the
contents of this message is strictly prohibited, and may result in legal
liability on your part.  If you have received this message in error, please
notify the sender immediately and delete this message from your system.  We
believe that this email and any attachments are free of any virus or other
defect that might affect any computer system that it is received and opened
in, however, it is the responsibility of the recipient to ensure that it is
virus free and the sender accepts no responsibility for any loss or damage.