Menu

#132 Tables not included with -i appears in relationship tab

open
5
2011-05-03
2011-05-03
Anonymous
No

I noticed that when specifying a subset of tables with -i, referenced tables are still included in the relationships tab, is this deliberate? I can reproduce the phenomena using db2 V9.5.5 on Linux given the following ddl:

create table t1 ( x int not null primary key);
create table t2 ( y int not null primary key, x int not null references t1 (x) );

using -i T2 results in both T1 and T2 being visible on the relationships tab. The link to T1 is broken

Cheers
/Lennart

Discussion

  • John Currier

    John Currier - 2011-05-04

    It looks like the ignore is working, but it subsequently finds references to the ignored table and treats it as if it's in another schema.

    Working on it when I can,
    John

     
  • John Currier

    John Currier - 2011-05-06

    The latest beta ( http://schemaspy.sourceforge.net/schemaSpy.jar ) should resolve the issue. Let me know how it works.

    Thanks,
    John

     
  • Anonymous

    Anonymous - 2011-05-10

    Sorry for the latency, I took the latest beta for a spin and it appears to be working just fine. Great!

     
  • John Currier

    John Currier - 2011-05-10

    Cool. Glad that resolved it.

    John

     

Log in to post a comment.