Search found 2 matches
- Tue Apr 26, 2005 6:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Database name included in SQL in ODBC stage
- Replies: 7
- Views: 3362
- Mon Apr 25, 2005 4:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Database name included in SQL in ODBC stage
- Replies: 7
- Views: 3362
Database name included in SQL in ODBC stage
I imported the table definition for a SQL Server table. I use this table in an ODBC stage. When I look at the SQL, the columns are fully qualified and the SQL looks like this: select "dbname.dbo.column1","dbname.dbo.column2" from "dbname.dbo.table_name" My database name...