MIDRANGE dot COM Mailing List Archive



MIDRANGE-L » February 2013

Re: File Overrides and STRSQL vs embedded SQL



OVRSCOPE(*JOB)

-sjl



"TheBorg" wrote in message news:mailman.16868.1361906163.10847.midrange-l@xxxxxxxxxxxx...

I issued the following command:
OVRDBF FILE(FAA0005) TOFILE(XXXXXXXXX/FAA00005)

The library XXXXXXXXXX is NOT in the library list for my interactive job.

Now, using STRSQL to start the green-screen SQL interpreter, I can do:

Select *from FAA0005

and get data.

However, If I try to run a QM query or a program which has embedded SQL
referencing FAA0005 *without* qualifying the file and library, I get an
SQL0204 message:

FAA0005 in *LIBL type *MEM not found.

Is it safe to conclude that QM Query and HLL programs containing embedded
SQL don't respect file overrides?






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact