• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • FTP’ing a Library

    September 25, 2002 Timothy Prickett Morgan

    Hey, Ted:

    I think there is a way to FTP an entire library to a PC file and then restore the PC file to another iSeries machine. I just don’t know where to look. Can you tell me what to do?

    — Darrell

    FTP only transfers files, Darrell, so the only way to FTP a library is to put the library into a file. In this case, you need to use a save file.

    First, create a save file and then save the desired objects to it:

    CRTSAVF   FILE(bbb/XYZ)
    SAVLIB   LIB(aaa) DEV(*SAVF) +
       SAVF(bbb/XYZ) TGTRLS(*CURRENT)
    

    Be sure to specify the proper release in the TGTRLS parameter.

    When you FTP the save file to the PC, use a binary transfer. I like to use the extension .savf on my PC files that contain save files. That’s not necessary, but when I see the file sitting on my hard drive months later, I know what it is.

    Let’s suppose you wish to transfer save file XYZ to PC file XYZ.SAVF in the TEMP directory. If you are doing the transfer from the PC side, use these FTP commands:

    bin
    quote   site   namefmt   0
    get   bbb/xyz    c:/temp/xyz.savf
    

    When you copy the save file from your PC to the second iSeries machine, you have to take steps to make sure the data winds up on the iSeries as a save file, not as a physical file. There are two ways to do this.

    If you are using name format 0 (library/file.member), you must create the save file on the iSeries before running the FTP transfer. You can either create the save file during a terminal session, or use QUOTE RCMD to create the save file from your FTP session:

    quote   rcmd   crtsavf   ccc/xyz
    quote   site  namefmt   0
    put  c:/temp/xyz.savf  ccc/xyz
    

    If you use name format 1 (QSYS.LIB/library.LIB/file.SAVF), you do not have to create the save file in advance:

    bin
    quote  site  namefmt  1
    put   c:/temp/xyz.savf    /qsys.lib/ccc.lib/xyz.savf
    

    This is a good question, Darrell. I think this is one of those techniques that every iSeries programmer, operator, and administrator should know.

    — Ted

    Sponsored By
    WORKSRIGHT SOFTWARE

    On June 30, 2002,
    $$$$$$$$    Postal Rates went UP!    $$$$$$$$

    On July 1, 2002,
    $$$$$    you wanted your postage bill to go down.    $$$$$

    We have the solution! CASS certify your mailing names and addresses and presort your outgoing mail and save. Our CASS certification software ensures that your address files have valid ZIP Code and address information. Our presort software ensures that you can properly prepare you mail for delivery to your Post Office.

    WorksRight Software, Inc. is the number-one source for iSeries and AS/400 CASS, presort, ZIP Code, and area code software and data.

    Visit our Web site – www.worksright.com – to learn more about our CASS and presorting software, or contact WorksRight Software, Inc., phone 601-856-8337,
    e-mail software@worksright. com .

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 73 -- September 25, 2002

    Sponsored by
    DRV Tech

    Get More Out of Your IBM i

    With soaring costs, operational data is more critical than ever. IBM shops need faster, easier ways to distribute IBM applications-based data to users more efficiently, no matter where they are.

    The Problem:

    For Users, IBM Data Can Be Difficult to Get To

    IBM Applications generate reports as spooled files, originally designed to be printed. Often those reports are packed together with so much data it makes them difficult to read. Add to that hardcopy is a pain to distribute. User-friendly formats like Excel and PDF are better, offering sorting, searching, and easy portability but getting IBM reports into these formats can be tricky without the right tools.

    The Solution:

    IBM i Reports can easily be converted to easy to read and share formats like Excel and PDF and Delivered by Email

    Converting IBM i, iSeries, and AS400 reports into Excel and PDF is now a lot easier with SpoolFlex software by DRV Tech.  If you or your users are still doing this manually, think how much time is wasted dragging and reformatting to make a report readable. How much time would be saved if they were automatically formatted correctly and delivered to one or multiple recipients.

    SpoolFlex converts spooled files to Excel and PDF, automatically emailing them, and saving copies to network shared folders. SpoolFlex converts complex reports to Excel, removing unwanted headers, splitting large reports out for individual recipients, and delivering to users whether they are at the office or working from home.

    Watch our 2-minute video and see DRV’s powerful SpoolFlex software can solve your file conversion challenges.

    Watch Video

    DRV Tech

    www.drvtech.com

    866.378.3366

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    JD Edwards Dates, Revisited Reader Feedback and Insights:

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 73

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights: Displaying Menu Options
    • FTP’ing a Library
    • OPNQRYF Date Arithmetic

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • The Power11 Transistor Count Discrepancies Explained – Sort Of
    • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
    • Big Blue Delivers IBM i Customer Requests In ACS Update
    • New DbToo SDK Hooks RPG And Db2 For i To External Services
    • IBM i PTF Guide, Volume 27, Number 33
    • Tool Aims To Streamline Git Integration For Old School IBM i Devs
    • IBM To Add Full System Replication And FlashCopy To PowerHA
    • Guru: Decoding Base64 ASCII
    • The Price Tweaking Continues For Power Systems
    • IBM i PTF Guide, Volume 27, Numbers 31 And 32

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle