CPYSPLF and AFPDS
by Ted Holt

Printing is one of the primary concerns of people who use computers for what I still refer to as data processing, so it's no wonder I have received a good bit of mail in response to printing-centric articles such as Page 1 of X, Reading Spool Files in RPG, and Extract Reports from Disk Files. Since packaged software is so widely used in installations staffed by readers of this publication, several people have asked about a CPYSPLF equivalent that works with AFPDS. Today, I address that issue. READ MORE >

SQL Can Return One or a Few Records
Hey, Ted:

SQL's SELECT INTO statement works fine as long as only one record matches the criteria in the WHERE clause. If the query returns more than one record, the host variables are loaded with data, but the SQL State variable, SQLSTT, has a value of 21000, which, according to the manual, indicates a "Cardinality Violation." Can I assume the record loaded into the host variables really is the first record in the returned dataset? Or do you have a better suggestion? READ MORE >

   Admin Alert: Configuring Output Queues to Print Multi-Copy Spooled
  Files on Remote Printers
   by Joe Hertvik

Like most business computers, OS/400 can send spooled file output to printers located on either a local or a remote system. Spooling to a remote printer is not without its hazards, however. One of the more common problems lies in configuring OS/400 to print multiple copies of a single spooled file on a remote printer. Here's the rundown on how this problem works, the quick fix to make it go away, and a gotcha. READ MORE >

Reader Feedback and Insights

We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >

T.L. Ashford
WorksRight Software
COMMON