Db2 Error Code 80n
Contents |
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and db2 error code 551 Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking db2 error code 911 SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre
Db2 Error Code 302
bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox http://www.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/codes/src/tpc/n805.html for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this http://database.ittoolbox.com/groups/technical-functional/db2-l/sqlcode-805-sqlstate-51002-invalid-application-state-from-db2-udb-for-aix-tokens-aqd1tpsql-0x1910df620df1cd04-4468917 is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. SQLCODE = -805, SQLSTATE = 51002, INVALID APPLICATION STATE FROM DB2 UDB for AIX TOKENS AQD1.TPSQL 0X1910DF620DF1CD04 tspdba001 asked Oct 16, 2011 | Replies (3) Hello Experts, We are getting this error when we try to access DB2 on AIX from DB2 on zOS via Native SQL Stored procedure. The whole reason for doing this is we want to do inserts on a table that resides in DB2 on AIX. For some reason we decided to use Native SQL stored procedure(because this uses ziip engine on mainframe). We already made setup of CDB and also we did a test with SPUFI by binding SPUFI packages on mainframe side, it works for both select and inserts. But when we write a native stored procedure(on Mainframe) to do a simple select from table on AIX we get this error. At this point I tried looking fo
:: View next topic Author Message Siddheart22BeginnerJoined: 11 Apr 2005Posts: 42Topics: 19Location: India Posted: Fri Jun 09, 2006 6:10 am Post subject: Moving SQLCODE ie: s9(09) comp to s9(10) hi, In many existing Stored Procedures in my application, the SQLCODE is moved into a var that is s9(10). When I check the value of this o/p variable on SP http://www.mvsforums.com/helpboards/viewtopic.php?t=6563&sid=12aea49154445cbaf555e743a5d36a20 Builder, it is 80N or 80 L etc. Can someone help me with the conversion table. I would like to undertsand what is meant by 80N , 80L Thanks, Back to top acevedoBeginnerJoined: 03 Dec 2002Posts: 127Topics: 0Location: Europe Posted: Fri Jun 09, 2006 6:56 am Post subject: type 80N in any edit member and then set HEX ON and you'll see 80N FFD 805 now, try the same with 80L... Back to top shekar123AdvancedJoined: 22 Jul 2005Posts: 510Topics: 87Location: Bangalore India Posted: Fri Jun 09, 2006 7:33 am Post subject: Siddheart22, Please use this sheet to db2 error interpret. Code: ********************************************************************** * VALUES: * * 1 = A -1 = J EXAMPLES: NUMBER REPRESENTATION * * 2 = B -2 = K 10 00000001{ * * 3 = C -3 = L db2 error code 105 00000010E * * 4 = D -4 = M 0 00000000{ * * 5 = E -5 = N -234 00000023M * * 6 = F -6 = O -30 00000003} * * 7 = G -7 = P * * 8 = H -8 = Q * * 9 = I -9 = R * * 0 = { -0 = } * ********************************************************************** +---------------------------------------------------------------+ | Last Character will be | | | represented as below for.. | 0 1 2 3 4 5 6 7 8 9 | +---------------------------------------------------------------+ | If the Number is +ve | { A B C D E F G H I | +---------------------------------------------------------------+ | I