|
I've got a query that uses 3 common-table expressions along with a subquery in the where clause.
When I run it from STRSQL, I get an SQL0204 error: Message ID . . . . . . : SQL0204
Message . . . . : *QUERY0000 in QTEMP type *FILE not found.
Cause . . . . . : *QUERY0000 in QTEMP type *FILE was not found. If this is an ALTER TABLE statement and the type is *N, a constraint was not found. If this is not an ALTER TABLE statement and the type is *N, a function, procedure, or trigger was not found.
When I run the query from QueryManager or Ops-Nav I get a slightly different error: Message ID . . . . . . : SQL0204
Message . . . . : *QUERY0000 in QTEMP type *MEM not found.
Pete Hall pbhall@xxxxxxxxxxxxx http://www.pbhall.us/
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
