By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Reason for DB2 error code Sql0204n

P: 2
Iam getting the error with code SQL0204N.can anyone tell why am I gettin that error
Aug 29 '07 #1
Share this Question
Share on Google+
2 Replies


docdiesel
Expert 100+
P: 297
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

P: 14
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.