Re: COPY from a remote machine in Datastage

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 10/05/2018 09:18 AM, Ravi Krishna wrote:

Hello, if you need to use COPY command from remote machine and you use some libpq bindings (aka ruby pg gem for example), you can use functions associated with COPY command (https://www.postgresql.org/docs/10/static/libpq-copy.html). They should be provided by bindings of postgres library you're using.

If you can share more info, at least how do you access postgres (via Ruby gem for example or from client's console), I can try to be more descriptive.

We not writing any Ruby/Python code.  We are using Datastage. Datastage has in built features for most of the stuff. For example to bulk load data from csv files

into Oracle/DB2 etc, it has a BULK loader feature. However DS has no support for PG directly and we are piggy backing on ODBC where there is no BULK loader.

The only recourse for us is to type in SQL as DS allows user code.

Can you install the postgres client software (psql) on the client machine and then have Datastage spawn "psql -c 'COPY ...'"?

--
Angular momentum makes the world go 'round.