Db2 Sql Error 812
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community SQL error -812 when using Type 2 Universal Driver for Java under z/OS Loren Bergeson SQL error -812 when using Type 2 Universal Driver for Java under z/OS February 8, 2005 12:24 PM I am trying to start using the Type 2 Universal Driver for Java under Unix System Services on z/OS 1.4, DB2 V7.1. When I try to execute the Java program under Unix System Services, I get this error when I execute the first SQL statement in the program (which happens to be a SELECT): com.ibm.db2.jcc.t2zos.y: [IBM/DB2]T2zos/1 T2zosPreparedStatement.readOpenQueryInternal:nativeOpen:4019:DB2 engine SQL error, SQLCODE = -812, SQLSTATE = 22508, error tokens = HELLO2.5641324C52424272;DSNRRSAF; at com.ibm.db2.jcc.t2zos.x.a(x.java:48) at com.ibm.db2.jcc.t2zos.x.a(x.java:613) at com.ibm.db2.jcc.t2zos.x.a(x.java:688) at com.ibm.db2.jcc.t2zos.T2zosStatement.a(T2zosStatement.java:982) at com.ibm.db2.jcc.t2zos.T2zosPreparedStatement.h(T2zosPreparedStatement.java:187) at com.ibm.db2.jcc.c.zc.p(zc.java:1223) at com.ibm.db2.jcc.c.ad.d(ad.java:2248) at com.ibm.db2.jcc.c.ad.U(ad.java:489) at com.ibm.db2.jcc.c.ad.executeQuery(ad.java:472) at com.ibm.db2.jcc.sqlj.g.executeRTQuery(g.java:631) at sqlj.runtime.ExecutionContext$StatementFrame.executeQuery(ExecutionContext.java:1246) at sqlj.runtime.ExecutionContext.executeQuery(ExecutionContext.java:784) at com.ibm.itso.sg246435.sqlj.Hello.main(Hello.java:177) -812 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM program-name.consistency-token USING PLAN plan-name Explanation: A last or only entry in the package list for the plan contained asterisk (*) the 'collection-id ' which requires the 'CURRENT PACKAGESET' special register to be set to a nonblank 'collection-id' in order to form a qualified package name. System Action: The statement cannot be executed. Programmer Response: Set the 'CURRENT PACKAGESET' special register to the desired 'collection-id' or have your system administrator check the plan's package list for correctness. ----------------------------------------------- I assume
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and http://www.idug.org/p/fo/et/thread=19924 Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET http://knowledgebase.progress.com/articles/Article/6421 Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Man
from GoogleSign inHidden fieldsBooksbooks.google.comhttps://books.google.com/books/about/DB2.html?id=n3LzwyxGAHAC&utm_source=gb-gplus-shareDB2My libraryHelpAdvanced Book SearchGet Textbooks on Google PlayRent and save from the world's largest eBookstore. Read, highlight, and take notes, across web, tablet, and phone.Go to Google Play Now https://books.google.com/books?id=n3LzwyxGAHAC&pg=PA120&lpg=PA120&dq=db2+sql+error+812&source=bl&ots=G5pBm6GC2v&sig=p--keHG3FYRuiv5Bsrkmai9KXWg&hl=en&sa=X&ved=0ahUKEwie_eC0jb7PAhWG34MKHd2LA14Q6AEIRDAF »DB2ibmO ELO FORTE 0 Reviewshttps://books.google.com/books/about/DB2.html?id=n3LzwyxGAHAC Preview this book » What people are saying-Write a reviewWe haven't found any reviews in the usual places.Selected pagesTitle PageTable of ContentsIndexContentsPart 2 SQL return codes9 Chapter 2 Introduction11 Chapter 3 Successful SQL codes13 Chapter 4 Error SQL codes29 Part 3 DB2 codes161 Chapter 5 XC1 codes163 db2 sql Chapter 6 XC2 codes173 Chapter 7 XC3 codes209 Chapter 23 XE6 IFI abend codes605 Chapter 24 XE6 IFI reason codes609 Chapter 25 XE7 codes619 Chapter 26 XE8 codes637 Chapter 27 XE9 codes651 Chapter 28 XF1 codes653 Chapter 29 XF3 codes655 Chapter 30 XF7 codes701 MoreChapter 8 XC5 codes215 Chapter 9 XC6 code219 db2 sql error Chapter 10 XC8 codes221 Chapter 11 XC9 codes223 Chapter 12 XD1 codes257 Chapter 13 XD3 codes299 Chapter 14 XD4 codes463 Chapter 15 XD5 codes471 Chapter 16 XD6 codes473 Chapter 17 XD7 codes475 Chapter 18 XD9 codes485 Chapter 19 XE2 codes503 Chapter 20 XE3 codes515 Chapter 21 XE4 codes531 Chapter 22 XE5 codes583 Chapter 31 XF9 codes705 Part 4 IRLM messages and codes709 Chapter 32 IRLM messages711 Chapter 33 IRLM return and reason codes731 Chapter 34 IRLM abend codes747 Part 5 Appendixes749 Appendix A Abend codes for CICS transactions751 Appendix B SNA sense codes753 Appendix C Problem determination759 Appendix D SQLSTATE values common error codes769 Appendix E New changed and deleted codes793 Notices805 Glossary809 Bibliography843 Copyright LessCommon terms and phrasesabend reason code application program authorization ID class 4 trace clause code is issued Collect the following column console cursor database DB2 abend DB2 Diagnosis Guide DB2 has detected DB2 system DDM command DDM reply me