Re: SQL0204 -- *QUERY0000 not found???

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

Are you on V5R1 by any chance? We just resolved a problem that sounds very 
similar. IBM produced 3 test fixes that solved the problem. The PTFs are 
SI10980, SI10981 and SI10982. I don't know if the problem carries forward 
to V5R2, and I don't know if they're available yet, but you might mention 
them when you call.

At 12:54 1/7/2004, CWilt@xxxxxxxxxxxx wrote:
> 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/