Mateus F. Ribeiro wrote:
> Hello!
>
> I'm using SQuirreL to access a remote DB2 database
> using an JDBC-ODBC bridge driver. I have 2 questions
> and would be very grateful if you could answer them:
>
> 1) I'm able to see the PKs and FKs for some tables of
> some squemas... but for the majority of tables
> SQuirreL simply doesn't show any PK or FK... Do you
> know the reason? Is there anything to do with the
> JDBC-ODBC driver?
>
> 2) I've added some tables to a new graph, but the
> operations like "add all related tables" simply don't
> work. The "PK" and "FK" symbols also don't appear,
> even if I click in the option to do so... I also don't
> know how to connect manually the tables (in the worst
> case) and if is there possible to generate a graph
> from an particular schema (ideal scenario)...
I'm pretty sure that your problems are caused by the JDBC-ODBC bridge.
It has quite some limitation especially with respect to meta data and
the Graph plugin does a lot of meta data accesses.
>
> Thank you,
>
> Mateus Ribeiro
>
> P.S.: I'm using a jdbc-odbc bridge driver because I
> couldn't establish a connection with my JDBC driver.
> The database is in a mainframe.
Perhaps this link may help you:
http://www-03.ibm.com/servers/eserver/iseries/toolbox/
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|