24
Wed, Apr
0 New Articles
  1. You are here:  
  2. Home
  3. Analytics & Cognitive
  4. Document Management
  5. What You Need to Know to Convert Spooled Files to PDF (and More)!

What You Need to Know to Convert Spooled Files to PDF (and More)!

Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

The changes in 7.1 make life a whole lot easier!

 

Historically, converting spooled files on IBM i has been a bit of an arduous task, but in recent releases, it's become much easier. In April 2010, I wrote an article about how to convert AFP to PDF using native commands included in IBM i 6.1 at no charge. With the release of IBM i 7.1, we're fortunate that IBM has expanded on these abilities by adding a couple of neat features.

 

In IBM i 6.1, IBM added support to allow you to natively generate a PDF file from your application though the use of workstation customizing objects. In order to do this, you need to define or override a printer file with a device type of *AFPDS to use a workstation customizing object. You can use *PDF for the WSCST parameter, or you can specify a workstation customizing object with an attribute of CTXFORM. In any event, you also must identify the stream file where the resulting PDF output is created. The application can now generate a PDF file rather than the AFP spooled file. This support requires the IBM Transform Services for i and PASE licensed programs to be installed. Both of those licensed programs come with your OS at no charge.           

What's New in 7.1?

In IBM i 7.1, we now have the ability to convert spooled files natively to PDF by using Systems Director Navigator for i. This feature is not supported in the System i Navigator client unless you have Infoprint Server installed. I would assume this is just IBM intentionally moving more features away from the heavy Navigator client toward the Web interface.

 

If you select a spooled file, you can click the menu option View As PDF. This does the native conversion and displays the PDF on the screen.

 

You can also use the "Export as > PDF > to client file system" option, but don't be fooled by the other options listed; they don't work unless you have Infoprint Server installed. The first option in the list, Export as > PDF > to client file system is the only one offering native support for conversion. You can export your spooled file to a PDF in any directory you have authority to on your IFS, a shared drive, or a directory on your local computer. You can't get much easier than this, and many products out there offer this same feature for a cost that you can now eliminate.

Couldn't IBM Just Add Native Support to CPYSPLF?

Well...yes!

 

IBM i 7.1 PTF SI43471 augments the CPYSPLF command to now support copying spooled files into the Integrated File System (IFS)! IBM not only added new parameters to choose where the copied file is to be stored in the IFS, but also enabled support for the ability to choose a workstation customizing object (WSCST). By choosing an IBM-supplied WSCST, you can convert your spooled file to PDF and even TIFF (using either customizing objects QWPTIFFPB or QWPTIFFG4 ) or GIF (using QWPGIF) files on the fly. Unfortunately, there is no support yet for this PTF on IBM i 6.1, which is yet another reason for moving on up to 7.1 in the near future.

 

You need to install licensed programs IBM Transform Services for i and Transforms – AFP to PDF Transform for this feature to work.

 

To take advantage of this new function, specify the new *TOSTMF special value on the CPYSPLF TOFILE parameter. The spooled file will be converted based on the workstation customizing object specified in the Workstation customizing object (WSCST) parameter and the output placed in the stream file specified in the To stream file (TOSTMF) parameter. You must ensure the path exists on the IFS where you want to have the spooled file generate beforehand. It, of course, will not create directories as part of the conversion.

 

Here are the new parameters included with the CPYSPLF command, taken from the PTF cover letter:

 

To stream file (TOSTMF)
Specifies the stream file where the output data is to be written. All directories in the path name must exist. New directories are not created. This parameter must specify a value other than *NONE if the To data base file (TOFILE) parameter is *TOSTMF.

*NONE
The output is written to a user-defined physical file. This value is only valid if the To data base file (TOFILE) parameter specifies a user-defined physical database file.

path-name
Specify the path name for the stream file where the output data is to be written. This value is only valid if the To data base file (TOFILE) parameter specifies *TOSTMF.

Note: If the stream file exists, the CCSID associated with the stream file will not be changed.

Workstation customizing object (WSCST)
Specifies the workstation customizing object to use to transform the spooled file output to final form before writing it to a stream file. If the To data base file (TOFILE) parameter specifies a physical database file, the WSCST parameter is ignored. In order to convert a spooled file using the (WSCST) parameter, the device type (DEVTYPE) of the spooled file must be *SCS or *AFPDS.

*NONE
Specifies that no workstation customizing object is to be used.

If the To data base file (TOFILE) parameter specifies *TOSTMF and the device type of the spooled file is *AFPDS or *USERASCII, the spooled file data will be copied directly to the stream file.

If the stream file does not exist, the associated CCSID of the stream file will be set to 65535.

For other types of spooled files, the spooled file data will be copied to the stream file using the Control character (CTLCHAR) parameter to format the data. Lines will be ended with carriage return and line feed controls to indicate record
boundaries. If the stream file does not exist, a CCSID obtained from the spooled file attributes will be associated with the stream file.

If the spooled file has a CHRID attribute other than *DEVD, the CHRID attribute will be used to select the CCSID to be associated with the stream file. If the spooled file has a CHRID attribute of *DEVD, the CCSID of the job which created
the spooled file will be used.

*PDF
The output is transformed to Portable Document Format (PDF) before it is written into a stream file. If the stream file does not exist, the CCSID associated with the stream file will be set to 65535.

Qualifier 1: Workstation customizing object name
Specify the name of the customizing object. When a named customizing object is used and the stream file does not exist, the CCSID associated with the stream file will be set to 65535.

Qualifier 2: Library
*LIBL
All libraries in the library list for the current thread are searched until the first match is found.

*CURLIB
The current library for the job is used to locate the customizing object. If no current library entry exists in the library list, QGPL is used.

name
Specify the name of the library where the customizing object is located.

Stream file option (STMFOPT)
Specifies whether the copy operation replaces or fails to copy the records to the stream file if a stream file with the specified name already exists. If the stream file does not exist, it is created.

*NONE
No records are copied and the operation will fail.

*REPLACE
The records replace the existing stream file records.

So Easy!

With the new CPYSPLF command, you can easily adjust a CL program in order to take your spooled file to the IFS as an image or PDF. The practical applications for this are numerous. Imagine if you wanted to automatically email your customers an invoice as a PDF or TIFF file without doing a whole lot of work. Or dump your old payroll spooled files onto a file server as PDFs? IBM has made conversion tasks a heck of a lot easier.

as/400, os/400, iseries, system i, i5/os, ibm i, power systems, 6.1, 7.1, V7, V6R1

 

Steve Pitcher
Steve Pitcher works with iTech Solutions, an IBM Premier Business Partner. He is a specialist in IBM i and IBM Power Systems solutions since 2001. Feel free to contact him directly This email address is being protected from spambots. You need JavaScript enabled to view it..
BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$0.00 Raised:
$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: