Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » DB2 zSeries
DB2 zSeries [message #33167] Mon, 23 July 2007 01:37 Go to next message
Eclipse UserFriend
Originally posted by: jddietrich.yahoo.com

Drilling down through DSE DB->schemas->tables->columns the primary key
is not indicated on the primary key column, though the FK is. Also,
showing constraints, the constraint name is shown, but the constraint
table name is shown as 'implicit', (ie. XXX(->IMPLICIT). Why implicit?
Have others found these same things? If this is incorrect, where do I
start debugging?

The DB2 system is version 8.1, new function.
The same definitions in a UDB windows system show correctly (both PK
indicator and constraint XXX(->tableName)).

Eclipse 3.2, DTP 1.5.

Thanks in advance.
Re: DB2 zSeries [message #39708 is a reply to message #33167] Fri, 07 December 2007 21:25 Go to previous message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
I found this old post while searching for info on the same problem. This
can actually be seen in the SAMPLE database shipped with DB2. If you look
at the DEPARTMENT table Constraints->RDE, you will see a reference to
"Implicit" instead of what should be "EMPLOYEE".

The underlying model appears to be wrong, which is what is probably
causing this behavior in the UI. The same schema on a different DB seems
to work just fine, so my guess is that the DB2 model may not be loading
correctly.

This appears to be causing a bug in Dali JPT - 198580. I have submitted
bug 212306 to address this issue.

Neil


jim dietrich wrote:

> Drilling down through DSE DB->schemas->tables->columns the primary key
> is not indicated on the primary key column, though the FK is. Also,
> showing constraints, the constraint name is shown, but the constraint
> table name is shown as 'implicit', (ie. XXX(->IMPLICIT). Why implicit?
> Have others found these same things? If this is incorrect, where do I
> start debugging?

> The DB2 system is version 8.1, new function.
> The same definitions in a UDB windows system show correctly (both PK
> indicator and constraint XXX(->tableName)).

> Eclipse 3.2, DTP 1.5.

> Thanks in advance.
Re: DB2 zSeries [message #589264 is a reply to message #33167] Fri, 07 December 2007 21:25 Go to previous message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
I found this old post while searching for info on the same problem. This
can actually be seen in the SAMPLE database shipped with DB2. If you look
at the DEPARTMENT table Constraints->RDE, you will see a reference to
"Implicit" instead of what should be "EMPLOYEE".

The underlying model appears to be wrong, which is what is probably
causing this behavior in the UI. The same schema on a different DB seems
to work just fine, so my guess is that the DB2 model may not be loading
correctly.

This appears to be causing a bug in Dali JPT - 198580. I have submitted
bug 212306 to address this issue.

Neil


jim dietrich wrote:

> Drilling down through DSE DB->schemas->tables->columns the primary key
> is not indicated on the primary key column, though the FK is. Also,
> showing constraints, the constraint name is shown, but the constraint
> table name is shown as 'implicit', (ie. XXX(->IMPLICIT). Why implicit?
> Have others found these same things? If this is incorrect, where do I
> start debugging?

> The DB2 system is version 8.1, new function.
> The same definitions in a UDB windows system show correctly (both PK
> indicator and constraint XXX(->tableName)).

> Eclipse 3.2, DTP 1.5.

> Thanks in advance.
Previous Topic:SQL Results View - large objects
Next Topic:DataTypeMapping synchronization issue
Goto Forum:
  


Current Time: Thu Nov 26 08:02:30 GMT 2020

Powered by FUDForum. Page generated in 0.02195 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top