• RPGLE multi-file processing with no match fields

    I believe I have found a bug in the way that RPGLE handles primary and secondary files with no match fields. My program will not process the primary file if there are no records in the secondary file; but it will process the secondary file, if there are no records in the primary file. RPG bug?

    Modiyooch545 pointsBadges:
  • RPG vendors compatibility

    Is it possible to manipulate a RPG program of one vendor to make it compatible with another RPG vendor?

    VijayMehta5 pointsBadges:
  • CPF4169 error appeared during OPEN for screen file

    In reference to Ibmi ILE programming environment. I am in a screen program which is set to 132 length. There are multiple calls to other programs that are set to 80 length where there is not a problem getting the CPF4169 error. So now I have a new program to call and I am getting this error and I...

    sewell90 pointsBadges:
  • Automate AS/400 backup verify program

    Hi All, I perform AS/400 full system backups using go save, option 21 every week. Once backup is done, I'll give command DSPLOG LOG(QHST) MSGID(CPF096...etc) and verify how many libraries have been saved. I want this to be automated, can we write a program (CL/RPG) to pull all this information into...

    sivaknagula45 pointsBadges:
  • Where to find AS/400 RPG concepts

    I need practice questions to brush up my AS/400 RPG concepts. Can anyone help?

    karandeep5 pointsBadges:
  • What has changed in AS/400?

    Hi, I returned to AS/400 after about 10 years. I have developed a lot of software in RPG/400 and intensive use of CL, without SQL or query. Now I return to the AS/400 for work, what has changed? Can I start with RPG/400 and CL or I have to learn others. Thanks.

    Damiano15 pointsBadges:
  • DLCOBJ command not working

    I have a program that allocates an object (*file), calls a program, then deallocates. The dlcobj does not work. RPG PROGA calls CL PROGB which calls CL PROGC. PROGC does the alcobj and dlcobj. However when the program returns to PROGA (interactive RPG), the object is still locked. Any ideas?

    ttufankj25 pointsBadges:
  • DCLF in CL

    Hi! Can I open two database files in a CL program using DCLF? I've been trying to do it, but I receive an error related to OPNID. If you could send me an example, it would be greatly appreciated. Thanxs. Melissa

    MelissaG20 pointsBadges:
  • RPG III Validation

    Hello, I'm a beginner on AS/400. I'm developing a Supply Maintenance program that have three fields for three supplys but each supply has to match for an existing Vendor Number from another physical file, my question is how can I do that validation. Thanks.

    k3v1N2435 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • Field missing in Synon created RPG when renames database fields

    I have an RPG program, created by Synon that, when it renames Input file fields, just a couple of the fields being renamed to are not defined. Nothing has changed in the program or the files since the last time it was gen'd and compiled. What could be causing this?

    jlgarrett5 pointsBadges:
  • AS/400 Group Jobs being held after the first empty job is run

    I am using STRGRPJS JOB to submit a group job but after the first job is run which is a empty job the remaining jobs are being held. Can anyone tell what should i do so that they don't go in held state? Thanks.

    aceamar25 pointsBadges:
  • Retain RPG menu selection on the screen

    Is there a way to retain a menu selection on the screen? If a user selects menu option ' 1 ' I want the number '1' to remain on the screen until another selection is made or another menu is selected.

    lumberman7035 pointsBadges:
  • How to add user info in RPG – AS/400 for any printing to a multifunction printer?

    I have a customer currently using RPG - AS/400. The customer needs to track AS/400 users who print to a multifunction printer but there is no users info in the print stream currently. How can I add the users info in AS/400 print spool and what are the steps required? Thank you!

    chanwt15 pointsBadges:
  • CPF5032 member already locked to this job

    I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be...

    GHENDER215 pointsBadges:
  • Write duplicate record to a PF

    A screen has one input field called number. whenever the number is inputted, the value gets stored in a file. The file has 2 fields, Value and Sequence. So, if any user has inputted '10', the files will store 10 as value and 1 as sequence. If any user inputs a value, which is already present in the...

    manju05310 pointsBadges:
  • Reading members of a physical file

    Hi, Can somebody please help by providing the program code for reading all the members of a file using RPG or RPGLE program? Suppose a file has 3 members then how to read the records of all the 3 members in a file? Thanks!

    6r1,850 pointsBadges:
  • Dynamic SQL in RPGLE

    I am building a dynamic SQL in RPGLE with a wildcards. It does not work like a native SQL statement. A search for "FRANK" will search on 6 characters (retrieve all the FRANK and the FRANKL, but not the FRANKLIN). A search on "FRANKL" will retrieve the FRANKL and the FRANKLIN. Any help would be...

    davidgrant10 pointsBadges:
  • Converting Float to packed

    I am trying to convert a Float8 to a 17 6 Packed and I am loosing 1/100000th of the value of the decimal portion. The packed result is 1/100000th less than the Float value. How do I stop this from happening? I am calculating taxes.

    Kcgto4550 pointsBadges:
  • Like in SQLRPGLE

    Hi, I am using the below query in SQLRPGLE Select count(data) into :cntrec from sample where data like '%' "+:tpnumber+" '%'. I am getting an error "Token "+:tpnmber+" was not valid" . The tpnumber is a character field(10a). Sample file is a flat file I even tried '%' +:tpnumber+" '%' and '%'...

    Prashanth123270 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.

Following