How to solve SQL Error -204: UNDEFINED NAME

mahesh.ajagtap · New User Joined: 30 Sep 2006 Posts: 6

how to slove this error....
SQLCODE = -204, ERROR: IS AN UNDEFINED NAME
SQLSTATE = 42704 SQLSTATE RETURN CODE
SQLERRP = DSNXOTL SQL PROCEDURE DETECTING ERROR
SQLERRD = -500 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION

prav_06 · Posted: Tue Jan 23, 2007 11:49 am

Check your table name inside your sql query , you might have mispelled it or prefix the table name by the owner name for eg..Ownername.tablename

select empno from user1.table1 where empsal > 5000;

siva001 · New User Joined: 12 Jan 2007 Posts: 9 Location: chennai

qw shows this mesage i hope u didn't metioned exact table name

Programmer Response: Verify that the object name was correctly specified
in the SQL statement, including any required qualifiers. If it is correct,
ensure that the object exists in the system before resubmitting the
statement.

mahesh.ajagtap · New User Joined: 30 Sep 2006 Posts: 6

thank....
now it work