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

Pete,

Thanks for the info.  I'll check those out and if I'm still having a problem
after loading the database and HIPER group PTFs I'll give IBM a call.

Charles


> -----Original Message-----
> From: Pete Hall [mailto:pbhall@xxxxxxxxxxxxx]
> Sent: Wednesday, January 07, 2004 8:44 PM
> To: Midrange Systems Technical Discussion; midrange-l@xxxxxxxxxxxx
> Subject: Re: SQL0204 -- *QUERY0000 not found???
> 
> 
> 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/
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion 
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>