Db2 Sql Error Sqlcode=-516
Contents |
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 more about Stack Overflow the company Business Learn more db2 sql error sqlcode list about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Db2 Sql Error Sqlcode 305
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping db2 sql error sqlcode 440 sqlstate 42884 stored procedure each other. Join them; it only takes a minute: Sign up What does SQLCODE: -516 signify up vote 0 down vote favorite I am able to retrieve data from the same database table but am not able to http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n516.html isert The error which i get is DB2 SQL error: SQLCODE: -516, SQLSTATE: 26501, SQLERRMC: null sql db2 sqlcode share|improve this question edited Apr 28 '11 at 6:55 Joachim Sauer 183k35392500 asked Oct 19 '09 at 10:21 Gourav 2512515 1 What was wrong with IBM's DB2 documentation? What part of the reference manual for DB2 was confusing or incomplete? –S.Lott Oct 19 '09 at 10:28 add a comment| 2 Answers 2 active oldest votes up vote http://stackoverflow.com/questions/1587934/what-does-sqlcode-516-signify 4 down vote IBM's documentation suggests that the currentSchema property does not match the schema name of the tables and indexes that you created. (Although the above is for z/OS, I would expect that the Java DB2 implementation is the same) share|improve this answer answered Oct 19 '09 at 10:27 Brian Agnew 187k21234333 Thanks .. Its actually ment that there is a mismatch of columns. I was inserting 17 columns through frontend while in the backend there was one more extra coloumn. –Gourav Oct 19 '09 at 10:54 add a comment| up vote 2 down vote When you got SQLCODE that retreive from DB2 you can use following command for describe DB2 ? SQL-
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time https://www.experts-exchange.com/questions/28326300/URGENT-DB2-connect-problem.html Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > URGENT: DB2 connect problem Want to Advertise Here? Solved URGENT: DB2 connect problem Posted on 2013-12-27 DB2 db2 sql Oracle Database Windows Server 2003 1 Verified Solution 1 Comment 4,067 Views Last Modified: 2014-01-03 Hi experts, my db2 client is installed in the directory C:\DB2INST: (c) Copyright IBM Corporation 1993,2007 Command Line Processor for DB2 Client 9.7.8 I've problems to connect to the database DB2 from SQL Developer, below are the steps that I have done: db2 sql error - I added (in SQL Developer) the following jdbc driver from the directory C:\DB2INST\java db2jcc4.jar db2jcc.jar db2jcc_license_cisuz.jar db2jcc_license_cu.jar - These are the connection parameters that I used: Hostname: test.local Port: 1600 Dbname: TESTDB2 Username: test password: test Test connection: Status: Success BUT when I try to blow up the connection to view the tables I get the following errors: An error was encountered performing the requested operation: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=3.64.114 Vendor code -204 An error was encountered performing the requested operation: DB2 SQL Error: SQLCODE=-516, SQLSTATE=26501, SQLERRMC=null, DRIVER=3.64.114 Vendor code -516 An error was encountered performing the requested operation: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.64.114 Vendor code -514 also if I try to run the query: SELECT * FROM SYSCAT.SCHEMATA; I get these errors: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=SYSCAT.SCHEMATA, DRIVER=3.64.114 Anyone have any idea how I can fix this connection problem? Thanks in advance! 0 Question by:ralph_rea Facebook Twitter LinkedIn Google LVL 57 Active today Best Solution bygiltjr Does the userid test have