• AS/400: Merge same physical file from two different libraries

    I have two libraries with same physical files. Now I want to merge both the physical files data in a single physical file in third library with unique records. My problem is the physical file doesn't have key fields. Solution can be in SQLRPGLE or RPGLE. Thanks in advance.

    97834441841,465 pointsBadges:
  • QHSMMOVL API in a CLLE program

    I am trying to use QHSMMOVL API in a CLLE program to move libraries between ASP's (1-32) and iASPS(33-256). I keep getting the error CPFB79E -  Auxiliary storage pool does not exist or CPF3C3C Value for parameter not valid. I think it has something to do with the Target auxiliary storage pool...

    Jpjawili75 pointsBadges:
  • Changing variable value in calling RPGLE program

    How do I go about changing a variable value in calling a RPGLE program?

    KeithN25 pointsBadges:
  • EXTMBR keyword in RPGLE

    Can I use multiple members in EXRMBR keyword in RPGLE? I know we can use one member name in EXTMBR but my question is can we place multiple members name in that apart from *ALL. Can someone please help me here? My requirement is to read 4,6,8 member from my 10 member PF. I know we can create...

    hndajad195 pointsBadges:
  • Calling RPGLE program from command line with parameters

    How do I pass numeric data to CL program from AS/400 command line?

    harish1990125 pointsBadges:
  • RPG /Free Local Data Area definitions

    I am trying to define the LDA with an external definition in RPG /free. Any help?

    Rstinsonindy15 pointsBadges:
  • What is the purpose of /DEFINE before H-spec?

    /DEFINE is a part of compiler directives, which if used will reduce source listings of the program. But I would like to know what happens in runtime if I use this directive. for eg: If I use /DEFINE in pgm : /DEFINE MOD_1..then in I write /If Defined(Mod_2) read FileA; /Else read FileB; /endIf

    Supriyoas400250 pointsBadges:
  • How to use OVRDBF via ‘QCMDEXC’ for Creating Override Database File in RPGLE?

    Hi All, I am trying to do Prompt option for my disply file. So that I created *OUTFILE (PPROMPT) using DSPFFD. Then I declared Program-Described File (TPPROMPT) with USROPN. Then while trying to Create Override Database File (OVRDBF) using CALL 'QCMDEXC' PLIST1, It couldn't create that. When try to...

    smmloganathan50 pointsBadges:
  • How to pass parameter From RPGLE to CLLE?

    Hi All. I'm very new to AS/400. How do I pass parameter From RPGLE to CLLE, And also how do I retrieve parameter from CLLE to RPGLE in the same program? For that what are the declaration we need in both programs. I tried simple program but is shows the error like "Pointer or parameter error"(error...

    smmloganathan50 pointsBadges:
  • Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • We need the logic to get the total salary based on department in RPGLE?

    I am having PF with ID, name sal and dept. I'm having the LF keyed with dept. Can anyone please tell me the logic in RPGLE to get the total salary based on department. In RPGLE, no hardcodings should be done in the coding. Thanks in advance.

    harish1990125 pointsBadges:
  • Multi occurrence data structure parms into and out of RPGLE via XML toolkit

    I have a parm #@WQRYT it is described as - D #@WQRYT DS LIKEDS(#WQRY_T) DIM(99) Here is my PLIST - C *ENTRY PLIST C PARM #@WQRYT C PARM #@ROWCNT 2 0 C PARM #@STATUS 1 Trying to bring into this data structure to process in pgm then send back - D #WQRY_T DS D W#DHCRIS 6 INZ(*BLANKS) D W#DHWKDT 10D D...

    ADAMSJU5 pointsBadges:
  • RCVJRNE Exit program

    We are processing jounal enteries for a number of tables to build XML and then writing the XML to MQ. For XML we are using Files field layout. The RCVJRNE exit program is single entry. Is there a way to hold the files field layout in the memory for every time the exit program is called?

    irfandar5 pointsBadges:
  • Field validation in AS/400

    Hi, I want to throw error messages based on following validation on the display screen. 1) If field type is character and it's length is 50 and if someone put numeric value in it's first position then error message should be populated as following:- "The value of 1 is not valid for this field" It...

    6r1,850 pointsBadges:
  • AS/400 RPGLE MNTDSPR command

    May I know how the below command work? D MNTDSPR       E DS                  EXTNAME(TESTPF) I was compile the file TESTPF with added in new fields, but I did not compile the program. Won't it hit level check? I try to debug and the MNTDSPR is still showing old fields of TESTPF unless I...

    yeepiyaya220 pointsBadges:
  • Non Subfile Field Not Changing When Doing an EXFMT

    This should be a simple thing to do but it is not working. I have an RPG program in which the user enters a warehouse code and presses enter. If the code is valid, it then populates a field in the record with the warehouse description. If the user changes the code to an invalid warehouse, I turn on...

    GHENDER215 pointsBadges:
  • Counting using RPGLE

    I tried to do flames program in RPGLE. I counted and removed the common words. For example: STRING1 - RAJESH STRING2 - KUMAR - I GET 7 AS OUTPUT Flames count is 6 but I have 7. How do I count the word F as 7 and set the next pointer L as starting pointer.

    rajeshkmr571175 pointsBadges:
  • Display file screen delay in RPG ILE

    Hi all! I have a RPGLE program and have used a main screen and a window in it. The main screen SCR01 will have all the filed to update a record. When I press F2 the record will update as usual after that the small window will be shown which is having "Record Updated Successfully!"  words. No...

    Sureyz2,735 pointsBadges:
  • Summary in English: Converting the AS/400 code to summary in English like langauage

    Hi ALL, For every new requirement or changes in RPGLE/CLLE/RPG/SQLRPGLE/RPT code I need to write program flow after making the changes. I will include these program synopsis in Requirement Analysis Document(RAD). So it takes much time to write synopsis. Is there any chance to convert AS/400 code to...

    RPOOJA125 pointsBadges:
  • White papers on AS/400 – RPGLE

    Hi, Can anyone share the sample of white papers on AS/400 - RPGLE technology. and also please give me some topic on which i can write white papers as value addition to my work. currently working on IBM I V7R1. Thanks in advance :)

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