Anybody has experiences to connect Progress Database from DataStage ?
Use special stage, or only ODBC stage.
By the way, if I need to set up an ODBC connection to the Progress Database, do I need to install some Progress client software or ODBC drivers..
how to connect Progress Database ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
Years ago I did it using an ODBC driver on DS 4.0 for Windoze. You'll have to set it up on the DataStage server under System DSN like the others. Sorry I can't be more helpful.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can also run Progress utilities to dump data into flat file formats (even initiating these utilities from DataStage) and process those files. This approach allows hierarchical structures to be unpacked.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.