CPYSPLF and AFPDS

February 23, 2005 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.

At least one astute reader of this publication pointed out

SQL Can Return One or a Few Records

February 23, 2005 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 that the record loaded into the host variables really is the first record in the returned dataset? Or do you have a better suggestion?

–Brad

I suspect that the data in the host variables comes from the record you’re looking for, but being

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

February 23, 2005 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.

I recently ran into this problem on an IBM 6400 printer that we had networked through a NetGear print server, setting it up as a remote