• What is the syntax for a file override that renames the field name prefix?

    Chasing down an obscure bug and a possibility is a hanging field value (many logicals over one physical file in program)

    aceofdelts1,985 pointsBadges:
  • Writing Information to the JobLog

    I've seen a number of snippets here and there on the internet regarding the ability to write specific information to the job log in order to figure out exact problems, based on the conditions placed within. I've seen reference being made to some API, but have been unable to actually find useful...

    Eric Witham690 pointsBadges:
  • What causes space offset error in RPGLE?

    Can anyone tell me what this means? I'm getting this on a CHAIN to an externally described file in a called RPGLE program. Space offset X'00000000' or X'000000000020A0AA' is outside current limit for object JOBNAME USERID 123456. Internal failure in compiler or subroutine.

    baumgardnd50 pointsBadges:
  • Adding and updating physical file

    I have a physical file with no key. I want to add new record to it and if record is added if I want to update it. How can I do it without a key?

    supreet8515 pointsBadges:
  • In RPGLE, how to fetch the particular record in 1 lakh record without a key

    Hi, I have some 1 lakh record. I need to fetch from 250th record with no key in it. What is the possible optimed way we can achieve it.

    KirManoj15 pointsBadges:
  • RPGLE Source Lines Exceeded

    RPGLE Source Lines Limit exceeded when compiling the Source. Please see below the error message - ""Compilation stopped. Internal failure occurred. Error Code is 1."" Remove unwanted lines or Divide programs into sub programs. Advice any other ideas to avoid this. Thanks.

    as400dev505 pointsBadges:
  • How to convert character date to numeric date

    Hi All, I have a character date field ('DD/MM/YYYY'). Now I want to convert into ISO numeric format in free format. Thanks

    97834441841,400 pointsBadges:
  • Fetch specific record from a BD through CL

    How can I fetch the specific record from a BD through CL? For RPGLE, we use SETLL. Is there any command for CL?

    Satyamohanty50 pointsBadges:
  • Scrolling Message in RPGLE

    Does anyone know how to create a scrolling message on the bottom of a display screen? I am programming on the AS/400 in RPGLE.

    GHENDER200 pointsBadges:
  • User Exit Programs FTP

    Hello I am struggling with first user exit program. I only want to allow specific users (those keyed into a file), to be able to log into FTP. In addition, I only want to allow the function of the SENDING of files, once logged in. I am struggling with how to capture the user id from the STRFTP...

    Piano520 pointsBadges:
  • Subtracting Date/Time AS/400 V5R4

    I am familiar with the subdur command. I have used it to get the # of days between 2 dates and the number of minutes between 2 times. How do I get the difference in minutes when the times fall on separate days. I guess I need to know how to calculate the interval between 2 times when the dates are...

    GHENDER200 pointsBadges:
  • SQLRPGLE – Result Set

    I have an SQLRPGLE program [PGMA] containing the following: D ResultSet       DS                                 D                                     Qualified     ...

    Riccam30 pointsBadges:
  • What is the difference between using RPGLE and SQLRPGLE when updating a file?

    What is the difference in updating a file using RPGLE or SQLRPGLE?

    mcasantoshrai55 pointsBadges:
  • RPGLE Embedded SQL Not null

    RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered.  /free                                                   exec...

    NickHutcheson11,380 pointsBadges:
  • Job Schedule Entries Migration

    Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info and then push it into the...

    RaydenR0 pointsBadges:
  • Using API: unlink()

    Hello All, Is anyone aware of "authorities" issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to "unlink" or "delete" this IFS...

    Mrs9693nj0 pointsBadges:
  • Reading a output queue of spool files in RPGLE program

    I want to read a output queue which contains spool files so how could I read it through a RPGLE program. Actually I want to read a output queue and get the list of distinct spool files and also want the count of spool files with the same name.

    munduuu435 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • How to use XML in RPG

    Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the complete process or code. Thanks.

    RPGPGM40 pointsBadges:
  • Logic help required RPGLE

    I have a screen now in the screen I have few options eg.. Sel1, Sel2...etc. If I go in Sel1 I get another screen as subfile which provide me to select Sel11, Sel12, Sel13...etc. Not after making selections from Sel11, Sel21....Selnn, I come back to the first screen. Now I have to Save this...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following