467,209 Members | 1,345 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

Reason for DB2 error code Sql0204n

Iam getting the error with code SQL0204N.can anyone tell why am I gettin that error
Aug 29 '07 #1
  • viewed: 7316
Share:
2 Replies
docdiesel
Expert 100+
Hi,

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

Regards, Bernd

Expand|Select|Wrap|Line Numbers
  1. SQL0204N "MISSING.QUERY" is an undefined name.
Aug 29 '07 #2
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
Aug 30 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Stefano Tesini | last post: by
1 post views Thread by Michael Lueck | last post: by
5 posts views Thread by Santiago Ordax Solivellas | last post: by
3 posts views Thread by Satish | last post: by
8 posts views Thread by Brian Tkatch | last post: by
9 posts views Thread by shorti | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.