Hi,
I wish to connect to postgres database. I am using standard unixodbc v2.0.0 drivers that ship with RedHat 4 enterprise edition.
I am able to connect to the database and can load data from a database table to a sequential file. But 'create table' & 'drop table' functionalities of ODBC stage are not working.
I can create & drop tables through 'isql' prompt which uses the same drivers, so i guess problem is not at drivers end but at DataStage end.
Please Suggest some solution(or any alternative way to connect to the database - without writing customized stages).
tia,
manish
Postgres connectivity
Moderators: chulett, rschirm, roy
Hi,
No access here to ver 8 & docs, so no idea if it is even supported
You can try invoking a sql script via command line, that should work even if your DB is not supported, as long as it supports sql script running via command line .
IHTH (I Hope This Helps),
No access here to ver 8 & docs, so no idea if it is even supported
You can try invoking a sql script via command line, that should work even if your DB is not supported, as long as it supports sql script running via command line .
IHTH (I Hope This Helps),
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org