Hey Booth - glad I could help out.


On 1/13/2019 12:18 AM, Booth Martin wrote:
This list is important to me because the answers usually are direct, specific, and correct.  Your response made me revisit the issue. For about the 14th time.  Turns out you are 100% right. Thank you Vern.

On 1/12/2019 11:06 PM, Vernon Hamberg wrote:
SQLCOD -204 has a message for that - SQL0204 - have you seen what that message is? It should be in your joblog - it says "File not found" - there should be some further info as to which file, but it is probably BIGFILE - there's nothing too complex about this - see where BIGFILE is on your system and be sure your LIBL is correct when running the SELECT statement.

Just for the future - if you need information on an SQLCOD, make a message ID by taking the letters SQL and follow them with a 4-digit form of the SQLCOD. If SQLCOD is in the 30,000 range, use SQ plus the number as the message ID. Look up in QSQLMSG - DSPMSGD SQLxxxx QSQLMSG.

I suspect there is nothing related to RRN in this error, other than the file you specify is not found, but that is also true about the FROM clause.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].