Re: Retrieve iSeries data in Excel spreadsheet

thats a good point, and depending on your network or
login line speed, the less data you FTP the better the
response, not everyone has remote DSL or T1 services,
but a lot of this has to do with "how much" excel work
you have to do..

for me it was a convience choice, I log in to our i from different
locations, however, all my excel macro work and documents are
only on my office workstation.
so.. I found it much easier to do 95% of my work in sql on the
i and have my data "ready to publish". that way I can grab that
data file from any web app and my calculations and other
data are housed on a site I can get to from anywhere.
and all my work is protected by system backups. my pc work
has to be backed up manually by me.

as far as the 2 step process.. well, once written, most of the
files are built nightly using a CL in the i scheduler to call my sql jobs







The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not send electronic mail to this entity. Instead, contact this office by phone or in writing.