erkki <mail125@operamail.com> wrote:

> Hi,
>
> I have problem with db2 8.1.2. I guess that the origin of the problem
> could be my select clause because I use IN operand with huge amount of
> items like 'SELECT * FROM TABLE WHERE FIELD IN (1, 2, ...,400)'.
>
> The error that db2 gives randomly is
>
> [IBM][CLI Driver][DB2/NT] SQL0805N Hakusuunnitelmaobjektia
> "NULLID.SYSLH203 0X5359534C564C3031" ei ole löytynyt. SQLSTATE=51002
>
> That finnish part 'Hakusuunnitelma' means something like IndexObject and
> 'ei ole löytynyt' means not found.

SQL0805 says: Package not found.

I strongly doubt that this has anything to do with your IN clause. Make
sure that all the packages are properly bound (CLI and such).
Unfortunately, I don't know what kind of package SYSLH203 is...

--
Knut Stolze
Information Integration
IBM Germany / University of Jena