Db2 Sql Error Description
Contents |
sql; lei; davs; db2 code DB2; LCLSX Technote (FAQ) Question You are using db2 sql error sqlcode=-904 the new DB2-enabled feature for Domino 7.x to create query views or DAVs. db2 sql error sqlcode=-803 You would like to know how to get the details of SQL error numbers. This information would also be helpful when using http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/db2z_n.html LEI or LCLSX connections. Answer Open the DB2 Command Line Processor and type in the error code using this format: ? SQLXXXX where XXXX is the error number. Here is an example returned by error 1024 db2 => ? SQL1024 SQL1024N A database http://www-01.ibm.com/support/docview.wss?uid=swg21214740 connection does not exist. Explanation: There is no connection to a database. Other SQL statements cannot be processed unless an SQL CONNECT was previously executed. The command cannot be processed. User Response: If the error occurred when disconnecting from the database, continue processing. If the error occurred on another SQL statement, issue an SQL CONNECT statement and resubmit the command or statement. sqlcode : -1024 sqlstate : 08003 db2 => Document information More support for: Lotus End of Support Products Lotus Domino Software version: 7.0 Operating system(s): AIX, HP-UX, IBM i, Linux, Solaris, Windows, z/OS Reference #: 1214740 Modified date: 2005-08-31 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
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 http://stackoverflow.com/questions/10877205/db2-lookup-error-db2-error-code 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 only takes a minute: Sign up db2 ? lookup error db2 error code up vote 1 down vote favorite I don’t know which is the db2 sql shortest way to look at the error descriptions like “ERRORCODE=-4463, SQLSTATE=42601” Generally I google such kind of error descriptions and I can get the result somewhat anyways. But this turns out to be very inefficient, sometimes it is just difficult to get description regarding the error code and sql state. I know the db2 built in command like : db2 ? SQL0443N will provide information about specific SQLCODE But when encountered error description db2 sql error like that above , how do I turn that into a SQLCODE, so that I can lookup it quickly using db2 ? db2 share|improve this question asked Jun 4 '12 at 6:35 zinking 2,25322152 2 I thought the 4-digit number was the SQLCODE, although I could be wrong about that (it is for the iSeries version). Does the command not work if you pass it an SQLSTATE? If I'm remembering right, the only real difference between states and codes is that states are supposed to be universal, while codes tend to be vendor-defined (although there are some commonalities). There's also a listing online, which may help. –Clockwork-Muse Jun 4 '12 at 16:18 @X-Zero , I know I can get the final answers online, but I was just trying to provide more information about the failure quickly. just passing the SQLSTATE to the command doesn't works. –zinking Jun 5 '12 at 1:19 @X-Zero seems passing the SQLSTATE works now, weird. maybe I made some stupid mistakes. –zinking Jun 5 '12 at 1:45 yep, encountered this again. $db2 ? 08001 DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL1024N A database connection does not exist. SQLSTATE=08003 –zi
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 14:51:40 GMT by s_hv978 (squid/3.5.20)