Database Software

Hello,

I'm connectiing via Heterogeneous Services through ODBC to a Progress database, which contains my source data. I have this setup in OWB successfully. I can see tables and column names in the explorer panel. Unfortunately, the vendor of the application that runs on Progress used dashs within column names (out of my control). I need to build a Mapping from the source table (accessible over a db link through HS) to a target table. When I drag the source table into the Mapping Editor, I get an error "API0402: Illegal character - not allowed.". I'm guessing it's the dashes in the column names.

If I put double-quotes around the column name in SQL, I can see the data just fine. For example:

SELECT "port-type" port_type, COUNT(*) cnt
FROM "PUB"."PORTFOLIO"@trading1_tst
GROUP BY "port-type";

My point is OWB needs to also deal with the dashes in the column names by applying double-quotes and keeping the case as well (as shown in my example). Is there a way to get OWB to do likewise and get past the "invalid character" error? This is a show-stopper for me.

- Dan Clamage