• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Send a Spool File from AS/400 with a Specific Subject Line and Message Body

    May 23, 2007 Hey, Ted

    Note: The code accompanying this article is available for download here.

    A while back, I was working on a project that required an e-mail to be sent with a resulting spool file as an attachment and with a specific subject line and specific message body. I had no trouble figuring out how to send the spool file as a document and how to create the message body. The hard part was customizing the subject line of the e-mail. This was important because the subject line would have provided the users a hint about the urgency of the task they need to perform.

    Any time the command SNDDST is used to send an e-mail with the TYPE parameter specified as *DOC, the name of the document pre-fills the subject line of the e-mail by default. I spent hours to find out how to get around it.

    I wrote the Send Email Spool File (SNDESPF) command to send an spool file of any length as an e-mail attachment. Source code for the command and its command-processing program, ASNDESPF, are available for download.

    There are two things to consider before using the utility.

    1. Make sure for SMTP server properties, the value for Message Split Size is set to No Maximum. This is required for large spool files.
    2. Make sure QDLS directory is not restricted for access or at least you have access to it to create folders.

    To prevent users from sending e-mail to outside addresses, I hard coded the domain name. You can change that if you wish. The e-mail address parameter of the command does not require the domain name. If the domain name of your company is more than 15 bytes, adjust the size of the parameter &INTADD. Also it needs to be mentioned that if no spool number is provided in the command, the last spool file of the job (this is useful in batch processing) will be sent.

    –Manouchehr Babakhani

    Thanks to Manouchehr for sharing his utility with us. I have no doubt he’s having great success with it in his shop. I know that e-mailing from the System i can be a challenge at times, so I was glad to pass his code along to the readers.

    –Ted



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    Midrange Dynamics North America

    Accelerate Change & Integration on IBM i

    Good change management unites IBM i and open systems development for productive collaboration. Developers work with their preferred tools and IDEs. Ultimate version control and traceability mean fast bug fixes and less stress. Rollback to a stable version in seconds.

    Change management gives managers, operations teams, and auditors the visibility they need, and developers can focus on what they like best: building great applications.

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the Annual 2008 conference, March 30 - April 3, in Nashville, Tennessee Help/Systems:  SEQUEL is the single solution for all your business intelligence needs
    LaserVault:  AES Encryption for secure AS/400 backups with no changes to your system

    IT Jungle Store Top Book Picks

    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    IBM: SOA Fits Skills Shortage to a ‘T’ ICS Finds the Sophisticated Side of PHP

    Leave a Reply Cancel reply

Volume 7, Number 20 -- May 23, 2007
THIS ISSUE SPONSORED BY:

WorksRight Software
ProData Computer Services
LaserVault

Table of Contents

  • Send a Spool File from AS/400 with a Specific Subject Line and Message Body
  • Searching for Wildcard Characters
  • Admin Alert: i5 IPL Pre-Planning and Post-Planning Checklists

Content archive

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

Recent Posts

  • To Comfort The Afflicted And Afflict The Comfortable
  • How FalconStor Is Reinventing Itself, And Why IBM Noticed
  • Guru: When Procedure Driven RPG Really Works
  • Vendors Fill In The Gaps With IBM’s New MFA Solution
  • IBM i PTF Guide, Volume 27, Number 27
  • With Power11, Power Systems “Go To Eleven”
  • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
  • Izzi Buys CNX, Eyes Valence Port To System Z
  • IBM i Shops “Attacking” Security Concerns, Study Shows
  • IBM i PTF Guide, Volume 27, Number 26

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