MIDRANGE dot COM Mailing List Archive



MIDRANGE-L » February 2013

File Overrides and STRSQL vs embedded SQL



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