Import Table Definitions

[poorna_76]

We are trying to import TableDefintions from the
Manager -ImportTableDefinitions -ODBC TableDefinitions.

If we are trying to import the TableDefinitions from the default Database defined for the ODBC connection(DSN), it works fine.
If we try to import the TableDefinitions from the different Database using the same ODBC connection(DSN), it does not work.

We tried to import using Plug-in MetaDefinitions, but the defintions are not matching with definitions on SQL Server.

Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?

Thanks in Advance

[chulett]

Is there a way we can define a generic ODBC connection for different Databases on the same server, so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?

No that I'm aware of.

[I_Server_Whale]

Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?

Hi Poorna,

I don't think that is ever possible unless all databases have same drivers. The reason we create different ODBC connections for different databases is because of the unique drivers for each database.

Thanks,
Naveen.

[ray.wurlod]

Talk to IBM about the Information Integrator product.

[poorna_76]

Is there a way we can define a generic ODBC connection for different Databases on the same server,
so that we can import table definitions for all the tables in all databases on that Server, using the same DSN?

Hi Poorna,

I don't think that is ever possible unless all databases have same drivers. The reason we create different ODBC connections for different databases is because of the unique drivers for each database.

Thanks,
Naveen.

Hi All,

Thanks for all the suggestions.

I mean different databases(DB1,DB2...) on
one RDBMS ( SQL Server in my case).

I don't mean different Databases as Oracle,SQL Server,DB2 etc.


Currently we have ODBC connection(DSN) defined at Server with no default database selected.


All my DataStage jobs works fine, even though they read data from different databases(DB1,DB2..) using same ODBC connection, if we prefix the table name with Database name.

Only issue we are facing is while importing the TableDefinitions.

Thanks in Advance.