Export tabels from SQL Server to iSeries
Home > IT Answers > Development > Export tabels from SQL Server to iSeries
As400coder
5 pts.
0
Q:
Export tabels from SQL Server to iSeries
SQL, iSeries programming commands, Export
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.
ASKED: Jan 22 2008  4:51 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
CharlieBrowne
6540 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Aug 12 2009  6:14 PM GMT by CharlieBrowne   6540 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0