• Call a stored procedure on a SQL Server from my RPGLE source using JDBCR4 service program.

    Something is going wrong while setting up the connection environment (ZBCCNNPF). Can someone explain me which parameters have to be set in which way to make this process work? Kind regards, Ton Konings.

    TonKonings196215 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" '+...

    angelafrye20 pointsBadges:
  • Create XML with RPGLE PGM

    How do I create an XML in RPGLE PGM?

    angelafrye20 pointsBadges:
  • 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,420 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?

    harish1990110 pointsBadges:
  • How to setup a reminder in RPG ILE?

    Hi all! I have a Physical file lets say MYPF01. In that I have a filed for Expiry Date (*ISO format). There are many records on the Physical file. If suppose i want to setup a reminder program (in RPGLE) to check that physical file everyday and if that date is expired (comparing current date) to...

    Sureyz2,655 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

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

    harish1990110 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,640 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...

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