Automate copying a spoolfile to a pc

Posted on 2009-05-14
Last Modified: 2013-12-06
What are the cl command to copy a spoolfile to a pc to be imported into a excel spreadsheet
rpg cl

Open in new window

Question by:cherylny
  • 4
  • 2
LVL 35

Accepted Solution

Gary Patterson earned 125 total points
ID: 24390920
There are lots of options.  I'll give you two easy ones:

Use the CPYSPLF command to a database file, then download the database file using your favorite file transfer mechanism:  CPYTOIMPF, CPYTOSTMF, Client Access File Transfer, FTP, etc.

You can also use iSeries Navigator (a Windows application that come sith iSeries Access) to download the spooled file as a text file.

- Gary Patterson

Author Comment

ID: 24399774
I am working remotely .  How can I connect to my Iseries Navigator if I am not using VPN to connect.  I am using Mocha Soft to connect.  I tried using the ip address I use to connect with Mocha to no avail.
Any suggestions.
LVL 35

Expert Comment

by:Gary Patterson
ID: 24400169
Depends entirely on your network configuration.  You'll probably need to work with your network administrator (this is probably going to be true for any mechanism you want to use to download from ther AS/400 if you are not on a VPN.  Ports are going to need to be opened on your firewall, and services may beed to be started on teh AS/400.  This is a BIG security exposure, and I would almost never recommend it, especially for a productions system.

If you are working remotely with no VPN, then you must either be working on an AS/400 this is directly exposed to the internet, or behind a firewall with port 23 opened (and NAT configured if the AS/400 is privately-addressed) in order to be able to use the TN5250 protocol.  

To use Navigator in the same fashion, you network admin would have to open the various ports for the various services you want to use, and start those various AS/400 services if they aren't already srtarted.

This is VERY insecure and I don't recommend it.

- Gary Patterson
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 35

Expert Comment

by:Gary Patterson
ID: 24400178
When we configure remote access for our clients, we almost always set up a VPN - this guarantees that only authorized users can access private client resources.

- Gary Patterson
LVL 27

Expert Comment

ID: 24415420
Minor note... If MochaSoft is being used, it _ought_ to be via telnet-ssl (port 992 usually) rather than simple telnet (port 23 usually). If telnet-ssl is opened through the firewall, then the various SSL ports for Navigator might also be opened. With a reasonably high key length, it shouldn't be significantly less secure than VPN with a similar key-length.

LVL 35

Expert Comment

by:Gary Patterson
ID: 24423184

Good point.  I keep finding shops that just poke a hole in the firewall at port 23 and let anyone in.  Hopefully that isn't the case here.  TN5250 over SSL is much better than naked TN5250 .

- Gary Patterson

Author Comment

ID: 24452143
It is ssl enabled..Private internet address.  It is secure...

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how enable gpedit.msc in W10 Home edition? 8 586
Tablets in POS (point of sale) environment 5 176
Mac Laptop - Water Spill 12 141
SCCM firewall status and security group members 4 56
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
Windows 7 does not have the best desktop search built in. This is something Windows 7 users have struggled with. You type something in, and your search results don’t always match what you are looking for, or it doesn’t actually work at all. There ar…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question