• 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

    …

    Read more
  • Debugging Java in Eclipse

    August 21, 2002 Timothy Prickett Morgan

    Hey, David:

    We have been using VisualAge for Java to develop Java applications for over a year. Recently, we decided to make the 1.3 JDK our standard JDK. Unfortunately, VisualAge does not include support for the 1.3 JDK, so it looks like we will need to move to another IDE. We have been looking at Eclipse, but it does not have a built-in team repository and you cannot change an executing program in the debugger. Are there other IDEs that support a team repository and editing during debug?

    — Larry

    You don’t mention which version of Eclipse you tried, but

    …

    Read more
  • Validating a User Password

    August 21, 2002 Timothy Prickett Morgan

    Hey, Ted:

    I have an application in which I would like to use electronic signatures. We are in a federally regulated industry and it is required to have this process password protected. To make things easy on the users I would like to use their normal AS/400 passwords. Is there a method for validating a user ID and password?

    — David

    Take a look at the Check Password (CHKPWD) command. It requires one parameter: the password of the user profile under which it is running. If the password is not correct, CHKPWD sends one of the following escape messages:

    CPF2362   

    …

    Read more

Content archive

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

Recent Posts

  • POWERUp 2025 –Your Source For IBM i 7.6 Information
  • Maxava Consulting Services Does More Than HA/DR Project Management – A Lot More
  • Guru: Creating An SQL Stored Procedure That Returns A Result Set
  • As I See It: At Any Cost
  • IBM i PTF Guide, Volume 27, Number 19
  • IBM Unveils Manzan, A New Open Source Event Monitor For IBM i
  • Say Goodbye To Downtime: Update Your Database Without Taking Your Business Offline
  • i-Rays Brings Observability To IBM i Performance Problems
  • Another Non-TR “Technology Refresh” Happens With IBM i TR6
  • IBM i PTF Guide, Volume 27, Number 18

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