× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2010-04-05T23:11:58Z  · last modified 2010-04-06T17:50:15Z

Index with same name - lowercase and upper - Db2 z/os 8.0


Priority Low
Complexity Trivial
Component App - Visual Editing
Version 09.0

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)

Issue #3845

Closed
Fixed
Resolved 2010-04-06T17:50:15Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017