• PASE for i already running in this job

    We have an RPGLE PGM that executes the following to establish a connection to another servers database and it works fine. DBcomm = JDBC_Connect(%TRIM(DriverName):%TRIM(ConnectionString):%TRIM(userid):%TRIM(Password) ); This statement starts running PASE. When the same user in the same job that just...

    Gman7325 pointsBadges:
  • CCSID 935 to CCSID 13488

    I have a file that is ccsid 935 containing some records with Chinese characters. I need to convert that file to its upgraded version that is ccsid 13488. (These are vendor files, therefore I have no control over their definitions.)  It is possible to simply copy the older file into the upgraded...

    Ckelly0120 pointsBadges:
  • Invoking web service using XML in RPGLE PGM

    I'm receiving error 415 - unexpected content type error - I have double checked the SOAP and all appears correct - is there a statement I need to add for content type to the XML? How can I tell what is causing this error? SOAP XML from PGM. SOAP = '' + 'http://www.w3.org/2003/05/soap-envelope" '+...

    angelafrye30 pointsBadges:
  • CPF4326

    Hi all, I am reading data from a file PF1 using LF1 sequentially, and writing to other file PF2 using using LF2 using RPG Program R1. When I run it using CALL R1, it's working absolutely fine. But when use SBMJOB to submit it as batch job, it is going to MSGW. the error is: " CPF4326 occurred for...

    Sai4AS4001,420 pointsBadges:
  • Data validity vs. CL program with OVRDBF command submitted 10 times simultaneously

    Would I be able to process the file correctly if I would have a CL program submitted 10 x simultaneously that contains OVRDBF. Behavior is similar to multi threading and this would really help process a very large file with less time. OVRDBF is necessary to point to the correct file member prior to...

    Andy01atSM5 pointsBadges:
  • Copying data from a file created in QTEMP

    How to write a code to copy the data from a file which is created in QTEMP to the file which is created in a permanent library.

    ShanuPriya199425 pointsBadges:
  • Date field in RPGLE

    If have a statement in RPGLE which runs fine online but errors out in batch. D DateField       S               d   datfmt(*mdy) D S1Dte           S              6  0 Datefield = %date( s1Dte   : *MDY ); Error: "Date, Time or Timestamp variable which...

    Msatbh175 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:
  • 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:
  • 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:
  • Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • Update causing reade to read the same record in RPGLE

    Hi Team, I have a critical issue. In RPGLE program, I have read a file then based on some condition I am updating the file if condition is not satisfied I am not updating that file. I am doing it in a do while loop. The issue I am facing is the record that has been updated is being read again....

    soundariya20 pointsBadges:
  • How does equal to operator work in RPGLE free format when v compare file field with constant value.

    I have a file field which has values 'X' or 'Y' and it is of 10 length. Chain f1:f2:f3 filename if %found filename if f4 = 'X' In free format RPGLE when I tried to compare it fails even though value of f4 is ' X' . Note: f4 is of 10length. Work around is trimming F4 before equating but I would...

    NicyChn135 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:
  • RPGLE validation

    How can I do a validation like first 3 words character and next 5 must be number in RPGLE?

    Vishalsuryavanshi15 pointsBadges:
  • Removing a Window without Re-Displaying the Underlying Record Format

    Program TST040 displays format Fm01Fmt. When the user presses F8 program TST041 is called, which displays a window and immediately returns to TST040 to continue processing (denoted by the Sleep function). After the “processing” completes, Fm01Fmt is redisplayed, removing the window from TST041....

    wbellis335 pointsBadges:
  • Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant10 pointsBadges:
  • Update and write sample RPGLE program

    Hi all, I have two physical files pf1 and pf2 with three field student_id,name,marks. I want to Move the records from PF1 to PF2. If the Student_ID already exists in PF2 just update the record else write a new record in PF2.where student_id is key field in both physical file. Could anyone provide a...

    nabamita90 pointsBadges:
  • KeyBoard Mapping in AS/400

    Can some one help me in Keyboard Mapping from English keyboard to Arabic Keyboard on AS/400 to be used in RPGLE Program?

    AnwarHabib25 pointsBadges:
  • Create RPGLE program from text

    I have been looking for a way to delete audit journal receivers by date. I found a program online by Carsten Flensburg. I've downloaded the files for this but they are in text form. I am not a developer, maybe a novice CL programmer :) . There are 4 files he has created: Member Name     Source...

    BigT211240 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