• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • OPNQRYF Bug

    August 21, 2002 Timothy Prickett Morgan

    Hey, Ted:

    Well I thought that the code below was working for us:

    OVRDBF FILE(file) SHARE(*YES)
    OPNQRYF FILE(file) RCDSLT(fld1 = 'A') 
    RTVMBRD FILE(file) NBRCURRCD(&RECS)
    IF COND(&RECS *GT 0) THEN(DO)
      CALL PGMA
    ENDDO
    

     

    But, I just did some testing and it looks like we’ve been using buggy code as you do need the CPYFRMQRYF to retrieve the correct number of records selected in the query .

    Thanks for the article and for setting me straight.

     

    — Rob

    Sponsored By
    WORKSRIGHT SOFTWARE

    On June 30, 2002,
    $$$$$$$$    Postal Rates went UP!    $$$$$$$$

    On July 1, 2002,
    $$$$$    you wanted your postage bill to go down.    $$$$$

    We have the solution! CASS certify your mailing names and addresses and presort your outgoing mail and save. Our CASS certification software ensures that your address files have valid ZIP Code and address information. Our presort software ensures that you can properly prepare you mail for delivery to your Post Office.

    WorksRight Software, Inc. is the number-one source for iSeries and AS/400 CASS, presort, ZIP Code, and area code software and data.

    Visit our Web site – www.worksright.com – to learn more about our CASS and presorting software, or contact WorksRight Software, Inc., phone 601-856-8337,
    e-mail software@worksright. com .

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Tags: Tags: mgo_rc, Volume 2, Number 63 -- August 21, 2002

    Sponsored by
    Raz-Lee Security

    The MFA Mobile App provides a secure and user-friendly way to add strong authentication without complicating access. It enables users to approve login requests or generate one-time passwords directly from their mobile device, ensuring that access is granted only after a second, trusted factor is verified.

    Learn More

    Share this:

    • Share on Reddit (Opens in new window) Reddit
    • Share on Facebook (Opens in new window) Facebook
    • Share on LinkedIn (Opens in new window) LinkedIn
    • Share on X (Opens in new window) X
    • Email a link to a friend (Opens in new window) Email

    Creating HTML Subfiles Debugging Java in Eclipse

    Leave a ReplyCancel reply

MGO Volume: 2 Issue: 63

This Issue Sponsored By

    Table of Contents

    • OPNQRYF Bug
    • Debugging Java in Eclipse
    • Validating a User Password

    Content archive

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

    Recent Posts

    • Will Power Chips Get A Converged Arm Instruction Set Like Z Mainframe CPUs?
    • Thinking About Moving IBM i To The Cloud? Don’t Start With The Quote
    • Precisely To Add Ransomware Protection In MIMIX 11
    • It’s D-Day For Cybersecurity, AI Firms Warn
    • IBM i PTF Guide, Volume 28, Number 30
    • Oracle Dips A Toe Into IBM’s EBCDIC World
    • When Your Small IBM i Team Is Really A Team Of One
    • Guru: Putting Failure Handling In Its Place
    • Inside The Security Enhancements In ACS
    • IBM i PTF Guide, Volume 28, Number 28: A Crazy Number of Security Vulnerability Patches

    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