hi there - for DB2 issues that's an external dialect supported by IBM, please post at https://groups.google.com/forum/#!forum/ibm_db
On Fri, Oct 12, 2018 at 11:46 AM Brian T <btrautma...@gmail.com> wrote: > > I'm running SQLAlchemy 1.2.12. When trying to autoload a DB2 table, it gives > me a "no such table" error for a table referenced in a foreign key, even > though that table exists. > > import sqlalchemy > > cnxstr = 'ibm_db_sa://xyzzy' > db2 = sqlalchemy.create_engine(cnxstr) > meta = sqlalchemy.MetaData(db2) > tbl = sqlalchemy.Table('child_table', meta, schema='plugh', > autoload_with=db2) > > NoSuchTableError: parent_table > > Not that this code works fine -- SQLAlchemy is able to find the parent table > in other contexts. > > tbl = sqlalchemy.Table('parent_table', meta, schema='plugh', > autoload_with=db2) > > I'm also able to construct the tables by hand using the inspector. It's only > when I use Autoload that I run into this problem. Is there a way to fix the > autoload? > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.