Error 4460
Contents |
JDBC; SELECT invalid parameter: unknown column name errorcode=-4460 AS Technote (troubleshooting) Problem(Abstract) SQL queries fail with "Unknown
Usejdbc4columnnameandlabelsemantics
column name" error in IBM Rational Integration Tester (RIT) of IBM Rational Test
[ibm][db2][jcc][10150][10300] Invalid Parameter: Unknown Column Name
Workbench (RTW). Symptom When running a SELECT AS in the SQL Query test action you see an error such as the
Usejdbc4columnnameandlabelsemantics Example
following: >[jcc][10150][10300][4.14.88] Invalid parameter: Unknown column name
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 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss http://www-01.ibm.com/support/docview.wss?uid=swg21635332 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 query Unknown column name ERRORCODE=-4460, SQLSTATE=null up vote 2 down vote favorite A co-worker has baffled us all with http://stackoverflow.com/questions/15884794/db2-query-unknown-column-name-errorcode-4460-sqlstate-null a query that is failing for reasons we can't divine. I can confirm that ENOTE.EN_FILTER_VALUE_L.FILTER_VALUE_DECODE does exist in the database. At least three people have stared at it trying to find misspellings. The Query: SELECT sub.ID, sub.USER_ID, sub.EN_TYPE_CODE, typ.EN_TYPE_DESC, typ.APPL_CD, filterval.FILTER_VALUE_DECODE AGENCY_TYPE, sub.EN_TYPE_CODE CONCAT ' | ' CONCAT typ.EN_TYPE_DESC ENOTE_STRING, org1.ORG_LVL1_CD, org1.ORG_LVL1_DC, org2.ORG_LVL2_CD, org2.ORG_LVL2_DC, org3.ORG_LVL3_CD, org3.ORG_LVL3_DC, org4.ORG_LVL4_CD, org4.ORG_LVL4_DC FROM ENOTE.EN_SUBSCRIPTION_T sub LEFT JOIN ENOTE.EN_TYPE_L typ ON sub.EN_TYPE_CODE = typ.EN_TYPE_CODE LEFT JOIN ENOTE.EN_FILTER_OFFICE_T filteroffice ON sub.ID = filteroffice.SUBSCRIPTION_ID LEFT JOIN UMC.ORG_LVL4_L org4 ON org4.ORG_LVL4_CD = filteroffice.ORG_LVL4_CODE AND org4.ORG_LVL3_CD = filteroffice.ORG_LVL3_CODE AND org4.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE AND org4.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE AND org4.STRUCTURE_CD = filteroffice.STRUCTURE_CODE LEFT JOIN UMC.ORG_LVL3_L org3 ON org3.ORG_LVL3_CD = filteroffice.ORG_LVL3_CODE AND org3.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE AND org3.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE AND org3.STRUCTURE_CD = filteroffice.STRUCTURE_CODE LEFT JOIN UMC.ORG_LVL2_L org2 ON org2.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE AND org2.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE AND org2.STRUCTURE_CD = filteroffice.STRUCTURE_CODE LEFT JOIN UMC.ORG_LVL1_L org1 ON org1.ORG_LVL1_CD = filteroffi
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 http://www.idug.org/p/fo/et/thread=35461 GroupBecome an IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community Java error with the https://pdn.pega.com/support-articles/63-sp1-install-fails-errorcode-4460-sqlstatenull SQL containing UNION after moving to DB2 9.1 for z/OS CM Vidya Attuluri Java error with the SQL containing UNION after moving to DB2 9.1 for z/OS CM March 18, 2010 10:47 PM Hi, The below SQL that was executing fine from Java code suddenly gives invalid parameter: error in java as follows: [3/18/10 13:28:00:522 EDT] 0000002f SystemErr R com.marriott.ir.oneyield.dao.security.OYSecurityDAOSysException: Unable to execute sql statement:com.ibm.db2.jcc.b.SqlException: [jcc][10150][10300][3.53.70] Invalid parameter: Unknown column name URA_PROP_CODE. ERRORCODE=-4460, SQLSTATE=null This is happening after one of our subsystem is upgraded to DB2 9.1 CM. we are using type 2 JDBC driver. Did anyone experience this? The SQL executes successfully on Mainframe invalid parameter: unknown side using SPUFI and thru Development center also . Only when java is receiving the results of this SQL, it is throwing above exception. One thing with the above column URA_PROP_CODE is (in the remaining parts of the UNION we have selected PT_PROP_CODE and I think that should not matter right?). The SQLNAME should contain the first select Column names from UNION and which is URA_PROP_CODE. SELECT DISTINCT URA_USER_ID, URA_PROP_CODE, PRA_PRIVILIDGE_ID, PRA_RESOURCE_ID FROM OYT_USER_ROLE_ASSC, OYT_PROPERTY, OYT_PRIV_ASGNMNT WHERE URA_USER_ID = ? AND URA_AUTH_LEV_ID = 1 AND PRA_RESOURCE_ID IN(0, 1, 5, 6, 7, 8) AND PT_PROP_CODE = ? AND URA_PLU_REGION_ID = PT_PLU_REGION_CODE AND PRA_PRIVILIDGE_ID = ? AND URA_ROLE_ID = PRA_ROLE_ID UNION SELECT DISTINCT URA_USER_ID, PT_PROP_CODE, PRA_PRIVILIDGE_ID, PRA_RESOURCE_ID FROM OYT_USER_ROLE_ASSC, OYT_PROPERTY, OYT_PRIV_ASGNMNT, OYT_USER_PROP_ASSC WHERE URA_USER_ID = ? AND UPA_USER_ID = ? AND URA_AUTH_LEV_ID = 3 AND PRA_RESOURCE_ID IN(0, 1, 5, 6, 7, 8) AND UPA_PROP_CODE = ? AND PRA_PRIVILIDGE_ID = ? AND URA_ROLE_ID = PRA_ROLE_ID AND URA_ROLE_ID = UPA_ROLE_ID AND UPA_PROP_CODE = PT_PROP_CODE UNION SELECT DISTINCT URA_USER_ID, PT_PROP_CODE, PRA_PRIVILIDGE_ID, PRA_RESOURCE_ID FROM OYT_USER_ROLE_ASSC, OYT_PROPERTY, OYT_PRIV_ASGNM
Data Management Pega Mobility User Interface Products Accessibility Framework Autonomic Event Services (AES) Business Intelligence Exchange (BIX) Decision Strategy Manager Pega Cloud Pega Cloud Collaboration Services PegaSurvey Pega Web Mashup System Management Application (SMA) Legacy Chordiant PegaDISTRIBUTION Manager PegaWORKS Products Predictive Analytics Director for PRPC Applications Pega Customer Service Pega Field Service Pega Marketing Pega Sales Automation Applications by Industry Communications & Media Energy Financial Services Government Healthcare Insurance Life Sciences Manufacturing & High Technology Academy My Self-Study My Classroom Course Catalog New Pega 7.2 Core Curriculum Pega PASS Subscriptions My Certifications Verify Certification Learning Paths Contact Pega Academy Support Pega Support Product Support Community Pega Upgrade Center Downloads Pega 7 Personal Edition Licensed Software Pega 7 Update Software Hotfix Catalog Deployments & Upgrades Deployment Guides Pega 7 Platform Support Guide PRPC 5 & 6 Platform Support Guide Online Help Systems Large File Transfer Application Communities Customers Customer Success Program Pega Can Awards Customer Advisory Board Resources PegaTube Pega TechTalk Pega Exchange Business Architect Central Pega Sites Search form Search Sign InContact Us Sign In × Status message You must login to access this content. Email: Password: Sign In Forgot password?Don't have an account?Create one US: +1 (617) 374 9600 UK: +44(0) 118 9591150 Australia: +61 2 9581 7000 Contact Us Privacy & Security Terms of Use Trademarks ©2016 Pegasystems Inc.