Reason for DB2 error code Sql0204n

[sudhakaryelleti]

Iam getting the error with code SQL0204N.can anyone tell why am I gettin that error

[docdiesel]

Hi,

without posting your sql query definitely nobody can tell you why you're getting the SQL0204N error, I'm sorry.

Regards, Bernd

SQL0204N "MISSING.QUERY" is an undefined name.

[naval123]

HI

As you have not written your SQL query here so it become little bit typical to identify the cause. But still i am sending some possible reasons, hopefully it helps you


This error is caused by one of the following:

o The object identified by "<name>" is not defined in the
database.

o A data type is being used. This error can occur for the
following reasons:

- If "<name>" is qualified, then a data type with this name
does not exist in the database.

- If "<name>" is unqualified, then the user's function path
does not contain the schema to which the desired data type
belongs.

- The data type does not exist in the database with a create
timestamp earlier than the time the package was bound
(applies to static statements).

- If the data type is in the UNDER clause of a CREATE TYPE
statement, the type name may be the same as the type
being defined, which is not valid.



Naval