• How to find last RUN date of a Query on AS/400?

    My system currently has 2000+ queries defined. Not all are active. Is there a way to determine the LAST RUN DATE of a query as opposed to the LAST CHANGE date. Most of our queries are not resaved (ie 'changed') each time they are run. Thanks in advance for your help.

    LITTLELINDA0 pointsBadges:
  • Problems with Stored Procedures

    Hi, I have written a stored procedure in SQLRPGLE. I used option 15 to create a module, then CREATE PROCEDURE to define it. When I go into SQL to call it, it says External program SVLBR in V64BPCSUSR not found. This is where my module & stored procedure is located. Any ideas on what I missed?...

    Terriharteau0 pointsBadges:
  • Reading a file in AS/400

    I wanted to read a Physical file based on library. Eg: One master file is available in most of the libraries. I wanted to change some data in that file. So i wanted 2 read file in all the libraies. how to achieve this using program?  

    rajeshece1,215 pointsBadges:
  • iSeries navagator and Windows 7

    Hi Everyone we have some users that are now on windos 7 and when they try to use iseries navagator to drag splool files from the 400 to their desk top the file is unreadable and can not be saved. Has anyone else haveing this problem and is there a fix.

    Braz45 pointsBadges:
  • changing a group profile to a user profile?

    One of my predecessors thought it was a great idea to add users to the QSYSOPR profile, which changed it from a regular user profile to a group profile. I have since moved these users to other groups, but QSYSOPR still thinks it's a group even though there are no members. Short of deleting this...

    Jgowin0 pointsBadges:
  • hey, I do COBOL on the iSeries, lol

    Where have all the COBOL programmers gone on the iSeries?? I have programmed in RPG (6+ years) but prefer COBOL any day of the week. Rarely see any questions and tips in the COBOL arena. Just curious and willing to teach anyone COBOL. Want to move to Florida?

    McSick50 pointsBadges:
  • how create a printer file in AS400

    HI, The message shows "Mistakes in the DDS not allowed with the specified GENLVL, one has not found the device of printer PRT01. File PRTF1 has not been created in the library HIPTSTMAP1"   Obviously use CRTPRTF. Probably another way exists to create the file of printer. THANKS.

    Sylvana185 pointsBadges:
  • I Series Access Problem

    We are installing I Series Access on a Dell Desktop with Vista Ultimate. When we go to load the software we click on the language question and and it says I Series access being installed and immediately come up with the following message: Could not read value version from key SOFTWAREIBMClient...

    Semd041970 pointsBadges:
  • iSeries – Monitoring QSECOFR when it becomes disabled

    What AUTOMATIC process could I put in place if I want to be notified by the system, when QSECOFR becomes *DISABLED? I have QAUDJRN on, and if QSECOFR becomes disabled, an entry is added. I don't know of a way to automatically be notified if QSECOFR becomes disabled. We are in a 24/7/365 shop, so...

    Mutkey0 pointsBadges:
  • Need help solving iSeries printing problem

    This iSeries user is having problems when trying to print a report from Operations Navigator. He said he has an iSeries E800 and is using iSeries Client Express when he wants to open or print a report from Operations Navigator. But he receives the following error message: "AFP workbench has...

    MichelleDavidson445 pointsBadges:
  • Way to speed up first invocation of stored procedure?

    Can you help? An iSeries user recently wrote the editors of Search400.com with this question: "One of our stored procedure takes approximately 1 minute for the first invocation when I do a call using RUNSQLSTM. If the same procedure is called repeatedly with different parameters, the results come...

    MichelleDavidson445 pointsBadges:
  • CHGPF command

    I am starting a project where I have to expand a field within a file and also add another field to the end of the same file. My question is this: I've never used the CHGPF command to change the file in the following situation. I've heard that you can use this command to create the new object and at...

    NJShoreBob0 pointsBadges:
  • Use of %Lookup BIF in Free form RPG – V5R3?

    Hi, I am having a problem when I try to use the %Lookup BIf in free form RPG. It doesn't seem to be functioning as it is supposed to. Is there something that I am missing (like PTFs) or is there a workaround to this problem if it is a previously known issue? Thanks for your help!!

    Adityavarma0 pointsBadges:
  • Owner ship change

    When would an ownership change appear? I know If you transfer owner ship authorities to other user . Is there any other way to change ownership.

    IVANRAO0 pointsBadges:
  • IPLSRC a and b

    What is the importance of giving IPLSRC A and B while installing  PTFs?

    qmaster1,675 pointsBadges:
  • Ways to PTF

    In How many ways we can get PTFs? as per knowledge throgh IBM website(Fix central) and through courier(like in CD).  Is there any another way to get  PTFs?

    qmaster1,675 pointsBadges:
  • Triggers

    I am looking for a technique that would allow me to clear the physical file upon the completion of the trigger program. I attempted to do this at the end of the CL porgram only to get the error message that the file is still in use. Apparently this is because the trigger program is still executing....

    Eamon6075 pointsBadges:
  • Add or Remove the module in service Program….?

    hello. How to ad or remove the Module in Service Program.....? Please suggest!!!

    Samule400160 pointsBadges:
  • AS400 COBOL ILE Pointer not set for location referenced – Trigger

    Hello, Guys I have been trying to run an ILE Cobol Trigger program, however it stops wiht the message below Pointer not set for location referenced.  If when debbuging the system is able to resolve the address of the variable associated with the PF. Hope someone can provide soime guidance. The...

    Saurater45 pointsBadges:
  • Coding to prevent table overflows withing programs

    In this new world of zero tollerance for abends and the goal of 100% production stability, I have been charged with determining the best method to prevent abends due to internal program table overflows.  Our environment has Cobol, Eztrieve and Assembler programs with internal tables.  We are...

    NanetteHaraden20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.