• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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

    …

    Read more
  • 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

    …

    Read more
  • 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

    …

    Read more

Content archive

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

Recent Posts

  • ARCAD’s Deal with IBM for DevOps In Merlin Is Exclusive
  • In The IBM i Trenches With: Maxava
  • Is The Cloud On Your IBM i Horizon?
  • Four Hundred Monitor, September 20
  • IBM i PTF Guide, Volume 25, Number 38
  • The Subscription Pricing For The IBM i Stack So Far
  • Facing The Challenges Of Upgrading Old Systems With The Cloud
  • Guru: Generating XML Using SQL – The Easy Way
  • Rocket Buys Data Integration Provider B.O.S.
  • IBM i PTF Guide, Volume 25, Number 37

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 © 2023 IT Jungle