On 26 Feb 2013 13:36, CRPence wrote:
On 26 Feb 2013 12:38, rob@xxxxxxxxx wrote:
(select * from aaakey) with data;
exec sql create table qtemp/deleteme as
AAAKEY in *LIBL type *FILE not found.
I am not aware of any relationship between the above SQL and that of
the OP. Although responding to my message, my comments are about the
above SQL and error noted by Rob. Instead of embedded, I used STRSQL:
At least in v5r3, there is a probable defect according to what I
recall as the accepted convention for processing overrides. The
override is honored by that DDL statement for its DML request, but only
if the named FILE() exists wherever the SQL naming expects to find the
file on the from-clause; i.e. as an unqualified name, in the CURRENT
SCHEMA of either *LIBL or the authorization identifier, or when
qualified, in the specified\qualified library name.
The override should enable the SELECT to pass validation without an
error both when a file by that name does exist and when a file by that
name does not exist, as long as the TOFILE() could pass validation if
specified explicitly in the from-clause; i.e. the validation of the
statement should occur against the overridden-to file.
I can never recall any past issue that was not considered a defect,
whereby a file by the name specified in FILE() of an OVRDBF request must
exist for the query to function. Thus IMO, the error for that DDL is
incorrectly being issued, and should be pursued as a defect.