473,387 Members | 1,575 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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
2 7598
docdiesel
297 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

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

Similar topics

1
by: Stefano Tesini | last post by:
Hi all, when i drop a table, i take his error : SQL0902C System error (REASON CODE = "122"). Why ? Ver UDB Server nt 7.1.0 Ver UDB Cli 7.1.0 Win 98 or XP the error is the same.
1
by: Michael Lueck | last post by:
If I issue the following SQL in the script center... SELECT NULLID.PRODTEXT.TEXT FROM NULLID.PAGES,NULLID.PAGEPRODLINK,NULLID.PRODUCTS,NULLID.PRODTEXT WHERE (((((NULLID.PAGES.ID = '00000020' )...
4
by: prasad | last post by:
I am getting sql error during binding a program which access a temporary table. The temporary table declaration and access methods are given below. EXEC SQL DECLARE GLOBAL TEMPORARY TABLE TEM88...
5
by: Santiago Ordax Solivellas | last post by:
Hi. We have almost all our tables defined on library lib1 and some on lib2. We have alias defined on lib1 to access tables on lib2 so there is no need to qualify library name. Alias for tables on...
4
by: acemann7 | last post by:
Windows 2000 udb v 7.2 Got the latest fixpak 13 Applied it. Still can't get a single java sp to run. I used to get reason "2"... now reason "0" - reason 0 is not even documented. I point...
3
by: Satish | last post by:
I get the following error when i compile the view given below. @f3n11:/home/satish/views/> db2 -td@ -f sat.vw DB21034E The command was processed as an SQL statement because it was not a valid...
8
by: Brian Tkatch | last post by:
Server: DB2/SUN 8.1.6 Client: DB2 Connect Personal Edition (No 11) <URL:ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winIA32v8/fixpak/FP11_WR21365/FP11_WR21365_CONPE.exe> ...
9
by: shorti | last post by:
db2 V8.2 I have been looking for a good way to log the 'reason code' when we hit an sqlcode that uses them. From what I can tell the reason code is stored in sqlca.sqlerrmc. But, there seems...
5
by: Rahul Babbar | last post by:
Hi, I am facing an issue here. I had to drop a number of columns (around 20) from a table, which I tried to do all at the same time using the following command. Alter table table_name drop...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.