• L Spec in RPG/RPGLE

    Hi, In our project we are using L-Spec in some of the program. Can anyone explain the basics of L-Spec? Sabarish

    Sabarish60 pointsBadges:
  • On the AS/400 iSeries can one use SQL queries to update file

    Cobol uses some kind of IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • Tab delimited file in a RPG program

    I have been asked to produce a file in a RPG program. The file is being used in some kind of interface and needs to be 'tab delimited' What is tab delimited? How do I create a tab-delimited file? Thanks!

    Raddy590 pointsBadges:
  • Entering a character value in RPGLE

    If I enter a character value of '12345' then I need to get a output of 123.45 . I did like %dec(var:5:2) but its getting a run time error.

    Satyamohanty65 pointsBadges:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • Using two same files from different libraries in a RPGLE program.

    Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime. So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve...

    navinnegi45 pointsBadges:
  • 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)

    aceofdelts2,130 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:
  • 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?

    Satyamohanty65 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:

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