5 pts.
 Export tabels from SQL Server to iSeries
I have a need to export a table on an SQL server to a file on the iSeries. I would also like this to be automated so that when the table is populated, the information is automatically exported to the file on the iSeries. I have tried using DTS/Enterprise Manager, but to no avail. Any help would be greatly appreciated.

Software/Hardware used:
ASKED: January 22, 2008  4:51 PM
UPDATED: August 12, 2009  6:14 PM

Answer Wiki:
You can use FTP First CRTPF FILE(YOURLIB/FTPIN) RCDLEN(80) Use DBU or UPDDTA put in the FTP commands to signon to the server and retrieve the file Set up a CLP that does CRTPF FILE(QTEMP/FTPIN) RCDLEN(80) OVRDBF FILE(INPUT) TOFILE(YOURLIB/FTPIN) OVRDBF FILE(OUTPUT) TOFILE(QTEMP/FTPOUT) FTP (HOSTNAME) Now you will have your flle and you can do whatever you want with it.
Last Wiki Answer Submitted:  August 12, 2009  6:14 pm  by  CharlieBrowne   32,825 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,825 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _