Db2 Sql Error Sqlcode 204 Sqlstate

new Controller DB Technote (troubleshooting) Problem(Abstract)

Db2 Sqlcode 204 Sqlstate 42704

Administrator is attempting to connect to (or create a sqlcode 204 sqlstate 42704 ibm-db2 new) Controller database, which is based on DB2. Administrator launches Controller Configuration, and

Is An Undefined Name.. Sqlcode=-204, Sqlstate=42704

launches the 'Database Conversion Utility'. User clicks 'Create DB'. An error appears. throws an error that includes "DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, sqlcode=-727, sqlstate=56098 SQLERRMC=.USER_TABLES". Symptom When the 'Create DB' button is pressed: Creating new empty Database Running DB Step: initial Running script batch: script/db2_createDB.batch Running script: script/db2/sequence_xdbtrickle_seq.sql Running script: script/db2/table_xdb00.sql ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=DECLARE sSql VARCHAR2(4000); BEGIN ;BEGIN-OF-STATEMENT;, DRIVER=3.57.82 ** ERROR: com.ibm.db2.jcc.am.io: DB2 sql0204n is an undefined name. sqlstate=42704 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=.USER_TABLES, DRIVER=3.57.82 When the 'Connect' button is pressed: ** ERROR: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=.USER_TABLES, DRIVER=3.57.82 Cause There are several possible causes for similar "SQLCODE=-204, SQLSTATE=-42704" errors. TIP: See separate IBM Technote #1681892 for more examples. This Technote specifically relates to the scenario where the cause is that the USER_TABLES object does not exist in the DB2 Controller tablespace. In turn, this is because the database was not created when the DB2 server was using/running-in Oracle Compatibility Mode. More Information: "SQLCODE=-204, SQLSTATE=42704" is a DB2 error code indicating 'object does not exist'; in this case, it is indicating that either the USER_TABLES object is not present, or that the user does not have access to read this. USER_TABLES is an Oracle compatibility feature. Theref

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn

Sqlcode=-204 Sqlstate=42704 In Mainframe

more about Stack Overflow the company Business Learn more about hiring developers or sqlstate 42704 postgresql posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community

Ibm Technote #1681892

Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and http://www-01.ibm.com/support/docview.wss?uid=swg21613531 WebSphere App Server? up vote 3 down vote favorite There are numerous web pages where people show this message as a symptom (with the value after SQLERRMC and the driver level varying): DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=M51Dev.CUSTOMER, DRIVER=3.61.65 including several here on StackOverflow. The error codes mean that an object -- nearly always a table -- is not found, and the value of the SQLERRMC parameter contains http://stackoverflow.com/questions/24144538/why-do-i-get-sqlcode-204-sqlstate-42704-with-db2-luw-and-websphere-app-server the name of the object in question. In every other occurrence of this I can find, the solution was just that they needed to qualify the table name with the schema name. However, as you can see from the line above, that isn't the case here. The schema is M51Dev, and the table is CUSTOMER, and both of them exist. The environment is WebSphere Application Server (7.0.0.31 in this particular case, but I somehow doubt that's relevant) running on Windows Server 2003 R2, with DB2 9.7.300.3885 on an old XP machine. The datasource is defined in WAS and retrieved via JNDI. the application is written in Java, and our SQL is executed using JDBC via Spring's JdbcTemplates. The datasource definition in WAS includes a custom property called currentSchema, which is set to M51Dev. This is the relevant line of SQL (or one of them, as we get the same symptom for every table): SELECT rundateOverride FROM customer WHERE customerId=1 And here's an extract from the stack trace. I can provide more if it helps. bad SQL grammar [SELECT rundateOverride FROM customer WHERE customerId=1]; nested exception is com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=M51Dev.CUSTOMER, DRIVER=3.61.65 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:233) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.j

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About http://stackoverflow.com/questions/1588687/db2-connection-problem-with-java Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the http://www.dbforums.com/showthread.php?1673040-Getting-error-SQLCODE-204-SQLSTATE-42704 Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Db2 connection problem with java 204 sqlstate up vote 7 down vote favorite 3 I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When i try to connect to database it is success full and while running any simple select query it give me following error:- DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.LOGIN, DRIVER=3.57.82 I have a database named onp and a table in it sqlcode 204 sqlstate called 'login' in which there is one table called 'login' with two fields username and password. Query that i am running Select * from login; gives me error DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.LOGIN, DRIVER=3.57.82 Select * from system.login; gives me error:- (//system is schema name) DB2 SQL Error: SQLCODE=-551, SQLSTATE=42501, SQLERRMC=DB2ADMIN;SELECT;SYSTEM.LOGIN, DRIVER=3.57.82 I have tried all the resources on the net and exhausted completely. Please help me java jdbc db2 db2-luw share|improve this question edited Jul 21 at 19:47 mustaccio 10.7k41933 asked Oct 19 '09 at 13:33 RishiPatel 801211 add a comment| 4 Answers 4 active oldest votes up vote 8 down vote accepted I don't know a lot about DB2, but looking up the error codes... The first error is because you didn't specify a schema, so it couldn't find the login table. SQLCODE -204 Object not defined to DB2 DB2 apparently requires you to specify the schema name or it looks in the schema with the same name as your login user. You must use SET SCHEMA or fully qualify the table name. The second error is because you don't have the privileges to perform that select: SQLCODE -551, Error: DOES NOT HAVE

be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 15 of 15 Thread: Getting error SQLCODE:-204 SQLSTATE:42704 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-29-11,03:49 #1 dubeyanurodh View Profile View Forum Posts Registered User Join Date Dec 2011 Posts 7 Unanswered: Getting error SQLCODE:-204 SQLSTATE:42704 Hi, I am facing issue accessing db2 table. getting SQLCODE: -204 SQLSTATE: 42704. I am able to access same table from command line but not through JDBC. Other tables in same schema are accessible but tables which are created at run time are not accessible. not sure whether it is DB2 or JDBC issue. DB2 version is 9.5 and OS is AIX. Can any one please help me out. Thanks in advance. Reply With Quote 12-29-11,04:02 #2 tonkuma View Profile View Forum Posts Registered User Join Date Feb 2008 Location Japan Posts 3,483 Please see 2) in http://www.dbforums.com/db2/854783-m...e-posting.html tables which are created at run time Publish complete statements to create the tables. and may be more information neccesary, depending on your response ... Reply With Quote 12-29-11,04:49 #3 dubeyanurodh View Profile View Forum Posts Registered User Join Date Dec 2011 Posts 7 Here is command I am using to create table: create table schemaName.tblName(field1 varchar(2),field2 varchar(30)); I am able to access this through following command: db2 "select * from schemaName.tblName" but with JDBC it give SQLCODE=-204 SQLSTATE:42704. Reply With Quote 12-29-11,09:25 #4 stolze View Profile View Forum Posts Visit Homepage Registered User Join Date Jan 2007 Location Jena, Germany Posts 2,721 SQLCODE -204 corresponds to message SQL0204: SQL0204N So I guess you are not showing us exactly what you do in the Java code (or you are connecting to a different database or DB2 instance). Or you have not committed the CREATE TABLE yet. Knut Stolze IBM DB2 Analytics Accelerator IBM Germany Research & Development Reply With Quote 01-02-12,02:26 #5 dubeyanurodh View Profile View Forum Posts Registered User Join Date Dec 2011 Posts 7 Hi Knut, Thanks for your reply. Here is my java code to connect to database and execute sql: ------------Code to establish connection -- Class.forName("com.ibm.db2.jcc.DB2Driver"); S