• RPGLE DATE CALCULATIONS

    I need to subtract 1 day from the system date and output it into a file in the format mmddyyyy. No separators. I cannot figure out how to use date functions like subdur w/o the field containing separaters on output. And I can't figure out how to use a DS to redefine it so I can exclude the...

    KatanaBeach115 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:
  • Data area *LIBL/INSRLIST is not allocated for output.

    The following is a snippet of the code. I get an error on the OUT op code as in the title.  * Next List Number                                   D                 DS                                  D...

    MurrayInfoSys940 pointsBadges:
  • SQLRPGLE – Result Set

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

    Riccam30 pointsBadges:
  • RPGLE/SQL PROBLEM

    I am trying to join our sales analysis file, all fields, with our accounts receivable file using SQL. I can extract the information okay but when I issue the following fetch command: FETCH NEXT FROM SALESSORT INTO :SALESREC ,:CUSTREC it skips the null records. I have spent the last 6 hours...

    Burtmis100 pointsBadges:
  • How to use RPGLE function/program as a function in STRSQL

    Hi All, I have an RPGLE program which takes as a input value and update it and return the updated value. I want to use this RPGLE program through SQL while executing SQL scripts.  I did not remember the procedure to use it, but I have used in the past.  Any of you have idea that, how to use RPGLE...

    Iamsubbarao60 pointsBadges:
  • Merging of files in AS400

    What is the use of merging files in AS400? How do you do this?

    0 pointsBadges:
  • Trigger program written in RPGLE

    I have a trigger program that have 3 files declared in F-Specs (no UsrOpn keyword).  Everytime it ends, it sets the LR indicator on.  Does the trigger program slow down processing when the trigger file is updated in a batch program?  Should I remove the code that turns on the LR indicator? ...

    bogeybetsy560 pointsBadges:
  • Text Editor (Word Processor) on iSeries.

    On our system we have limitless text for our Items. We developed a rudimentary text editor many years ago which is also used for creating letters (for emails/faxes etc) but ideally we would like to buy a decent 'text editor' that is native to the iSeries. Does anyone know of such a...

    NeilD440 pointsBadges:
  • Subfiles in RPGLE using WDSC.

    I have a subfile set up with a i/o field in the footer.  When I change the value of that feild in the footer from the screen the computer does not recognize the change.  First, can I have an i/o field in a footer.  If so what is the execution process?  I have tried writing the footer again and...

    Bix25 pointsBadges:
  • rtncsrloc in RPGLE

    i am not able to use rtncsrloc keyword. should i define it in f spec or d spec and how we have to give the 3 argumnts to it... could you just give 1 example explaining all the steps.

    Coolrahul10 pointsBadges:
  • converting num to character name in RPGLE

    i have to convert any number inputted by the user into its character name.... like if i type 567.. it should be converted to five hundred and sixty seven... i am having problems relating it...

    Coolrahul10 pointsBadges:
  • EMP

    How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should...

    0 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • How to reset the password??

    Hi, How to reset the password through a CL program. The user has forgotten his password, even ADMIN doesn't know the password. Thanks, Rama krishna

    0 pointsBadges:
  • Unexpected results in data

    I work with a TP software product that allows me to pass data back and forth from within that software using my custom program (RPGLE).  I have my custom RPGLE program that reads files in a main software I work with.  My RPGLE program sort of works like an API but it does not set on LR.  I am...

    Pt0505145 pointsBadges:
  • OVRPRTF not chaning OUTQ

    I have a program where the OVRPRTF command does not seem to be taking affect.  The output is going to the job's default outq and not the overridden outq.  The following are consecutive lines from the job log:

    ElTerrifico620 pointsBadges:
  • Data Q

    I need to check whether there are any data found in a data Q. Is there any way to do that? Appreciate if you can provide sample executable codes for me to test it on. Thanks...

    JennyChin0 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od 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:
  • In RPG program

    Hi, In RPG program i declared files. One for reading and another for Updating. Both the files are in different Library lists. How do i achieve this???? Thanks in Advance Rama krishna

    0 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