ODBC stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mimi
Participant
Posts: 26
Joined: Tue Jul 27, 2004 6:59 am

ODBC stage

Post by mimi »

Hello,
I trying to use an ODBC stage with a Access Database. The connection is OK, but when i try to make a query on one ODBC access table, it dosen't work.
In fact, in access database, table have some column name composed by two word like this : tableA.purchase order.
How can i read this table ?

Thanks for your help !
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Because the table name contains a space, the entire table name or column name must be quoted. If one were to follow the ODBC standard, which was written by Microsoft, one would use double quote characters, for example "TableA"."purchase order" - if that doesn't work, because Microsoft does not follow their own rules, use backtick characters, for example `TableA`.`purchase order`.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply