Db2 Sql Error Code 204
Contents |
new Controller DB Technote (troubleshooting) Problem(Abstract) Administrator is sqlsyntaxerrorexception db2 sql error sqlcode=-204 sqlstate=42704 attempting to connect to (or create a new) Controller com.ibm.db2.jcc.am.sqlsyntaxerrorexception db2 sql error sqlcode=-204 database, which is based on DB2. Administrator launches Controller Configuration, and launches the 'Database sqlcode=-104 sqlstate=42601 Conversion Utility'. User clicks 'Create DB'. An error appears. throws an error that includes "DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=
Sqlcode=-204 Sqlstate=42704 Sqlerrmc
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;
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/20919298/db2-sql-error-sqlcode-204-sqlstate-42704 and policies of this site About Us Learn more about Stack Overflow https://support.microsoft.com/en-us/kb/2899685 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 Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it db2 sql 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 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 db2 sql error 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 connection using the IBM Data Server Driver for JDBC and SQLJ con = DriverManager.getConnection (url, user, password); // Commit changes manually con.setAutoCommit(false); System.out.println("**** Created a JDBC connection to the data source"); stmt = con.createStatement(); con.createStatement(); System.out.println("**** Created JDBC Statement object"); // Execute a query and generate a ResultSet instance rs = stmt.executeQuery("select *from TestTable"); System.out.println("**** Created JDBC ResultSet object"); } catch (ClassNotFoundException e) { System.err.println("Could no
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft