DSXchange

Hi,

I have a question regarding to bulkload.

Our datastage server and DB2 server are located on different servers
Is it possible to create INPDATA.DAT and ULOAD.BAT, etc at the DB2 server machine, i.e. to make export and load locally at the db2 server?

Thanks,

Carol

You can run a subsequent pair of jobs to FTP the control and data files to the other server. Or simply run the FTP from a BAT file, perhaps from an after-stage or after-job subroutine.
You can use a "remote shell" or "remote execution" or "remote login" script (BAT file) to execute the bulk loader. Search for these terms on the Forum; the technique has been discussed before.