Search found 18 matches

by jeisma
Tue Mar 21, 2017 9:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to query a odbc datasource with field named date
Replies: 4
Views: 2030

hi,

that actually worked!

thank you!

(i would still argue to rename that field though.. :-)
by jeisma
Mon Mar 20, 2017 4:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to query a odbc datasource with field named date
Replies: 4
Views: 2030

It's a Progress RDBMS database. i would personally would have named it according to the purpose of the field (ie. trans_date, po_date, etc). I may be able argue to rename that field if indeed there is no way out of the error. And avoiding the finger-wagging and slapping :wink: I'd ask the rational w...
by jeisma
Mon Mar 20, 2017 12:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to query a odbc datasource with field named date
Replies: 4
Views: 2030

How to query a odbc datasource with field named date

hi, my odbc datasource has a field with name "date". I get error "... Syntax error in SQL statement at or about "date FROM PUB.my_table" (10713) i tried to manually the query using several combinations like: SELECT my_table.date FROM PUB.my_table SELECT [date] FROM PUB.my_ta...