ADS 8.5 Dev 12.56
DB2 Z/os 8.0
Northwind Database
Created a table named CAPS_TEST
created 2 indexes with the same name inx_1 - one in caps and one in lower case with different columns
When i take the table property, I get the below exception. It doesnt happen with DB2 Z/OS 9.0 only happnes with the lower version
com.ibm.db2.jcc.b.co: D.IMPLICIT IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE, OR IS NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.53.71
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.fm.c(fm.java:2475)
at com.ibm.db2.jcc.b.fm.d(fm.java:2452)
at com.ibm.db2.jcc.b.fm.a(fm.java:1953)
at com.ibm.db2.jcc.b.fm.a(fm.java:1931)
at com.ibm.db2.jcc.t4.db.g(db.java:133)
at com.ibm.db2.jcc.t4.db.a(db.java:38)
at com.ibm.db2.jcc.t4.t.a(t.java:32)
at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
at com.ibm.db2.jcc.b.fm.bb(fm.java:1924)
at com.ibm.db2.jcc.b.fm.a(fm.java:2782)
at com.ibm.db2.jcc.b.fm.a(fm.java:604)
at com.ibm.db2.jcc.b.fm.executeQuery(fm.java:588)
at \\...\\ .\\हिñçêČάй語简�?한\\.w⧸ᡘ⡄⠊ extends.e(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.w⧸ᡘ⡄⠊ extends.d(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.X̮ꉇꁨꊁ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\._̯̘᠈⢠ while final.a(Unknown Source)
at com.aquafold.datastudio.mainframe.ActionHandler.actionPerformed(Unknown Source)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
happens for all the tables properties - it is not just a problem with the naming of indexes. If you do a Tool - ER Diagrammer then for all the tables, the same error is generated
db2 extract table storage v8 doesn't have implicit information for databases...
issue fixed...
db2 extract table storage v8 doesn't have implicit information for databases...
issue fixed...
Issue #3845 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
happens for all the tables properties - it is not just a problem with the naming of indexes. If you do a Tool - ER Diagrammer then for all the tables, the same error is generated