Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column Delimiter

437985Mar 30 2007 — edited Apr 4 2007

Hi all.

I'm setting up an ETL interface for a Progress target database.

I noted that Progress database requires that both columns and objects be enclosed by double quotes in query statements (e.g: SELECT "name" FROM "myTable")

In ODI Topology Manager->Progress Properties->Language, I filled in the Object Delimiter field with the " value.

The problem is that I don't know where can I set up the value for column delimiter, and for this reason I'm getting SQL syntax error when ODI executes the step of loading data.

Any alternatives?

Thanks

Denis

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2007

Added on Mar 30 2007

#business-intelligence-applications, #data-integrator, #system-management-and-integration

5 comments

1,237 views