Search found 2 matches

by rdsarbo
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

Yes, I realize I can edit it but that's an additional step I'd like to avoid.
by rdsarbo
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...