42704 Sql Error
Contents |
using DbConv to create new database Technote (troubleshooting) Problem(Abstract) Administrator creates brand new (blank) DB2 database. Administrator logs onto the Controller application server, launches 'Controller Configuration' and creates a new database connection to sqlcode=-204 sqlstate=42704 sqlerrmc= the database. Administrator clicks 'connect' and then clicks 'Create DB'. An error appears. sqlcode 204 sqlstate 42704 ibm-db2 Symptom Depending on the environment the error may appear slightly differently, but it will be similar to: ** ERROR: com.ibm.db2.jcc.am.io: DB2 error code: -204, sql state: 42704 SQL Error: SQLCODE=-204, SQLSTATE=-42704, SQLERRMC=CONTRO, DRIVER=3.57.82 ** ERROR: Invalid datbase, XFRANGO is empty Cause There are many potential causes for similar-looking DB2 errors. NOTE: This Technote *only* relates to the scenario where the error contains sql state 42704 postgres the codes: SQLCODE=-204, SQLSTATE=-42704 In this scenario, there are several possible causes for the errors: Scenario #1 - DB2 database server is not using 'Oracle Compatibility Mode'. TIP: In this scenario, the error message will typically contain the word 'USER_TABLES' Scenario #2 - DB2 database client (installed on the Controller application server) has "Enable operating system security for DB2 objects" enabled. Scenario #3 - DB2 database has not been created
Is An Undefined Name.. Sqlcode=-204, Sqlstate=42704
correctly. Diagnosing the problem IMPORTANT: It is vital that you check the exact 'SQLCODE' and 'SQLSTATE' error numbers, to help you troubleshoot the root cause. Make sure that you check the error code reference numbers precisely. If they are different, then search IBM Technotes for different/specific advice for your error code. Resolving the problem Scenario #1 Delete the database. Re-configure the DB2 database server to use 'Oracle Compatibility Mode'. Re-create the DB2 database. Re-try. For more information, see separate IBM Technote #1613531. Scenario #2 There are two different methods you can choose: (1) Uninstall DB2 client (from the Controller application server), and re-install DB2 client. During the installation wizard do NOT enable "Enable operating system security for DB2 objects" or (2) Add the group " Everyone" to the Windows security local group " DB2USERS" on the Controller application server For more information see separate IBM Technote #1504470 Scenario #3 Delete the 'bad' database, and recreate the DB2 database using the correct settings. TIP: For full details, see separate IBM Technote #1570572 Related information 1613531 - "DB2 SQL Error: SQLCODE=-204 SQLSTATE=42704" 1504470 - "Standard Error ... 5 ... Object variable or 1570572 - How to create a brand new blank DB2 database Document information More support for: Cogn
here for a quick overview of the site Help Center Detailed
Sql0204n Is An Undefined Name. Sqlstate=42704
answers to any questions you might have Meta Discuss the db2 sql error: sqlcode=-727, sqlstate=56098 workings and policies of this site About Us Learn more about Stack Overflow the company sqlcode=-204 sqlstate=42704 in mainframe 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.ibm.com/support/docview.wss?uid=swg21681892 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 SQL Error: SQLCODE=-204, SQLSTATE=42704 up vote 4 down vote favorite 1 I created local database in DB2 called "TestDB" then I http://stackoverflow.com/questions/20919298/db2-sql-error-sqlcode-204-sqlstate-42704 created table called "TestTable". I found that the table is put under schema name is "yasmin". I am trying to connect to the DB2 database using JDBC but I got this exception R SQLException information [1/4/14 11:32:59:289 EST] 0000004d SystemErr R Error msg: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TESTTABLE, DRIVER=3.61.86 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R SQLSTATE: 42704 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R Error code: -204 [1/4/14 11:32:59:290 EST] 0000004d SystemErr R com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.TESTTABLE, DRIVER=3.61.86 I tried many solutions on the internet Like set schema but unfortunately doesn't work. This is the JDBC code I used String urlPrefix = "jdbc:db2:"; String url; String user; String password; String empNo; Connection con; Statement stmt; ResultSet rs; url = urlPrefix + "//127.0.0.1:50000/TestDB"; user = "db2admin"; password = "db2admin"; try { // Load the driver Class.forName("com.ibm.db2.jcc.DB2Driver"); System.out.println("**** Loaded the JDBC driver"); // Create the connecti
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.dbforums.com/showthread.php?1673040-Getting-error-SQLCODE-204-SQLSTATE-42704 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 https://bytes.com/topic/db2/answers/185391-db2-sql-error-sqlcode-204-sqlstate-42704-a 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 204 sqlstate 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 is an undefined 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
help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 P: n/a tmugavero Hello, This is my first time starting a topic here so I hope this is the right place. I am having problems running SQL queries on a Version 8 DB2 database for Windows Server using the type 4 driver. I get a connection but when I run a query, I get this error: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 For example if my query was "SELECT * from TABLE" , I would get the error: "DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704 DB2ADMIN.TABLE" [SELECT * FROM IDSC.TABLE] I looked at the error codes online and they do not provide me with any information I did not already know. Any help would be greatly appreciated. Kindest Regards, Tony Nov 12 '05 #1 Post Reply Share this Question 1 Reply P: n/a Mark A "tmugavero"