Db2 Sql Error Sqlcode 922
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 db2 sql error sqlcode 803 Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back
Db2 Sql Error Sqlcode 104 Sqlstate 42601
CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries
Db2 Sql Error Sqlcode 206 Sqlstate 42703
Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi bluesguyAZ59 Iqbalyk Clinton Jones http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/codes/src/tpc/n922.html blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox 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 http://database.ittoolbox.com/groups/technical-functional/db2-l/how-to-resolve-dsnt408i-sqlcode-922-error-5385111 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 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. How to Resolve DSNT408I SQLCODE = -922 Error Santa asked Dec 16, 2013 | Replies (1) While debugging a cobol-db2 program getting DSNT408I SQLCODE = -922 error when trying to open a cursor. Can anyone suggest a solution? Join this group Popular White Paper On This Topic Best Practices for a BI and Analytics Strategy 1Reply Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Angelo Sironi replied Dec 16, 2013 Hi Santa, I guess you get the error while trying to
MainFrame >> DB2 Suggest New Category What is sqlcode -922 ? Question Posted / guest 2 Answers 16697 Views I http://www.allinterview.com/showanswers/6146/what-is-sqlcode-922.html also Faced E-Mail Answers Answers were Sorted based on User's Feedback http://www.ibmmainframeforum.com/db2/topic6828.html Answer / sudha authorization failure Is This Answer Correct ? 25 Yes 0 No Answer / kanagaraj Yes correct. In this case plan is exist but your racf doesn't have privilage to access that plan. It will be reslove by below command grant execute planname to PUBLIC you need to execute this db2 sql command under creator of the plan because plan owner have the full access. Is This Answer Correct ? 15 Yes 2 No Post New Answer Categories COBOL (884)JCL (728)CICS (459)DB2 (684)IMS (80)IDMS (42)Natural (43)ADABAS (9)REXX (23)Assembler (31)CLIST (6)QMF (30)MVS (12)OS390 (8)OS 2 (6)VSAM (177)QSAM (4)Sysplex (5)IBM MainFrame AllOther (160) More DB2 Interview Questions How to resolve -803 sql code in DB2? 3 Answers Cap Gemini, db2 sql error Is Cursor exicutable ? 3 Answers TetraSoft, is there any restrictions for unions ? 4 Answers Patni, What Utility is used to migrate DB2 from one release to the next? 1 Answers insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help? 3 Answers Syntel, Bind concepts in DB2 cobol 10 Answers TCS, IBM, Virtusa, TRD, What information can you find in SYSIBM.SYSLINKS table? 1 Answers TCS, i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its 5 Answers EDS, What is a result table? 1 Answers Are views updatable ? 4 Answers What are leaf pages? 3 Answers If we have 100 records in the PF, we deleted all the records then what is the Size of the PF? 2 Answers For more DB2 Interview Questions Click Here Copyright Policy | Terms of Service | Site Map | Contact Us Copyright © 2016 ALLInterview.com. All Rights Reserved.
- 922 IBM's flagship relational database management system Post a reply Previous topic • Next topic • 4 posts • Page 1 of 1 SQL error - 922 by p19689 » Tue Dec 20, 2011 10:35 pm Hi , We are getting 922 on one of our COBOL programs after potential RACF changes and the RACF guy is on leave. This happens when it tries to do a INSERT into the Table 'EMPLOYEE'. I have checked all DB2 privilleges and looks OK but couldn't locate the error ! The Table OWNER is 'ABC' and Package owner is also 'ABC' and it's bound to a Collection (An old program) and ABC has execute on collection. the program runs via CA7 by the user XYZ . The user 'XYZ is a member of RACF group 'ABC' , which is the table owner. Could someone shade some light on this please ? What's I'm missing here , Thanks in advance. p19689 Posts: 63Joined: Fri Oct 01, 2010 1:13 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQL error - 922 Top Re: SQL error - 922 by Akatsukami » Tue Dec 20, 2011 11:05 pm Please give the error type and reason code. "You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day Akatsukami Global moderator Posts: 988Joined: Sat Oct 16, 2010 2:31 amLocation: Tottering-on-the-Brink Hasthanked: 6 times Beenthanked: 46 times Top Re: SQL error - 922 by p19689 » Wed Dec 21, 2011 1:57 pm That's one of the problems I'm having. I can't see any error type and reason code it just shows the message 'Update failed - SQL CODE : 00000922 - Contact IT Department ' . How can can I display the error type and the reason code please ? p19689 Posts: 63Joined: Fri Oct 01, 2010 1:13 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: SQL error - 922 by NicC » Wed Dec 21, 2011 5:19 pm If your RACF guy is on leave he should have a stand-in so ask that person. If there is no s