DSXchange

Hi, I tried calling the postgres function using the select query from the odbc stage as suggested by you, and it does run without any errors. But the output is not as expected. The same function gives correct results when I run it on postgres server. So the function is fine. Let me explain it in det...

Possibly not in such an old version of DataStage. Version 8.x has been out of support for five years already. >>>>> So is this functionality available in higher versions of Datastage? Can you use an ODBC connection? >>>>> Yes i am able to connect to postgres DB using ODBC Connection. However, I am n...

Im trying to execute a postgres stored procedure having input and output parameters from datastage. I am doing this using the stored procedure component. In the General tab of this component, there is an option to select the Database vendor and I am not able to see Postgres in the dropdown list. Is ...