DB2 zSeries [message #33167] |
Mon, 23 July 2007 01:37 |
Eclipse User |
|
|
|
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 |
Neil Hauge 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 |
Neil Hauge 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.
|
|
|
Powered by
FUDForum. Page generated in 0.03267 seconds