Sending pcn files to the iseries

55 pts.
Tags:
Application development
AS/400
Development
RPG
RPGLE
I have excel files on our server that I pass to the iseries as physical files. I do this through Client access ustn the data transfer to ISeries utility. I provide the PC location and file name, the system I wnat to go to and the library and file in the Iseries I want to wind up in. Does anyone have an example of how I can automate this in a CL program. Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll need to read up on the “IFS”, then have your users save their spreadsheets (as .csv) to the “IFS”. Then you can read the spreadsheet with RPG.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EgamiEsrever
    As mentioned, you could store them in .csv and read them directly from RPG. A Google search will show a ton of examples. Also, you could store them on the IFS in .CSV format and use the CPYFRMIMPF in a CL that would drop them nicely into a database file. Again, a Google search should turn up an example for that. You may also be able to map the server directory directly on the AS/400 as a share. At which point you could probably read the file from the PC server directly from an RPG.
    0 pointsBadges:
    report
  • Rajeshvasan
    Hi! Try CPYFRMIMPF with STRDLM(',')
    0 pointsBadges:
    report
  • DaddyCOZ
    There is no shortage to good solutions to this problem. First, you can transfer to the as/400 ifs using Windows Explorer, or you can access the PC directly from the AS/400 using QNTC file system. In either case, use the POI classes from jakarta.apache.com directly from RPG (you do not need to know Java) to access the xls file directly. No need for csv files or cpyfrmpcd or iseries access data transfer. There are lots of examples on the net using POI classes from RPG. Another solution is to use a PC based FTP to transfer to the AS/400. I have used iSeries Access and given users an icon for a one click file transfer. Lots of ways to go. I like the java solution because it is the most direct and straight forward.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following