• How do I populate an SQL table created on the fly in RPGLE?

    I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and I...

    SteveFletcher80 pointsBadges:
  • Unable to over ride a PF member

    Hi, I made a cl program and in it I over ride a pf member, clrpfm then call my rpgle program. I can't write on my member but instead it writes on the primary member and reads it. seems the member that is used is the the primary member and not the member that I over rides.

    Ayterrobias5 pointsBadges:
  • AS400 – RRN of PF

    FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program

    rajeshece1,215 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • MSGW

    Thank You for your reply But I need the process how I can write a program in order to get all the process to be done that is, giving opt7 & reply 'G' for a MSGW job. Or can I have any other process to do the same that means sending a reply to a MSGW job in RPGLE or CLLE or by any other process in...

    Kothamasusitaratnam5 pointsBadges:
  • Debugging service program

    Hi anybody tell me how to dubug a service program in ILERPG...thanks

    ten20081,150 pointsBadges:
  • AS400 – RPGLE Module

    Hi, I have created module mod1. and i have merged the mod1 with services programs sp1, sp2, sp3. how do i find what are all the service programs attached with that particular module?

    rajeshece1,215 pointsBadges:
  • AS/400 development

    Service Program contains 10 procedures. 5 Procdures in that service programs are defined with export keyword.5 Procdures in that service programs are defined with import keyword. i am calling the procedures from other ile program. How many procedures are available for me? How to hide the procedures...

    rajeshece1,215 pointsBadges:
  • rpg subdur

    I'm doing a subdur to calc the number of days between mfg date and trans date. When mfg is 2008 and trans is 2009 (12/31/2008 01/02/2009) I get a result of -364 like it subdur is ignoring the year. Any idea how to fix?

    Jjjlake40 pointsBadges:
  • CL AND RPGLE

    can i call an rpgle prog from a cl by passing parameters from cl. Also how do i debug these two sources which are of different types.I am not able to use strisdb to link the modules.

    0 pointsBadges:
  • AS400 Print Screen button on upper lefthand corner not working with new VISTA PC

    Hi, A user reported a problem where she used to be able to print whatever's on her screen from within any AS400 application by pressing the print screen icon on the upper lefthand corner of her screen (under the File button). Since she got a new pc with VISTA on it, it only prints a screen with...

    Kineno1615 pointsBadges:
  • Sorting data in RPGLE

    How to sort data in rpgle program countrywise in program coding only?

    6r1,590 pointsBadges:
  • AS/400 file specification

    Why sometimes we need to put "K" for file specification?eg: FSSDATA IF E K DISK

    Cev105 pointsBadges:
  • where does the file get created in AS/400 system when we fire embedded INSERT query in an RPGLE program

    we are inserting deptid in departments table using the following INSERT statement: INSERT INTO departments (department_id, department_name ) VALUES (30, ':Purchasing'); so where does the departments file get created in As/400 system? when we are doing a runqry on departments file, it is giving the...

    Mohan K695 pointsBadges:
  • How many files can be read in an RPGLE program?

    How many files can be read in an RPGLE program?

    Angajala5 pointsBadges:
  • Print from RPGLE without closing program or PRTF

    I just setup an Epson TM-H6000III POS printer on the AS400. This is used to print a receipt and then change to the check validation to print on the back side of checks. I got everything working except the receipt prints a " - -1" everytime I close the PRTF to release the print. Does anyone know a...

    OnLine4005 pointsBadges:
  • Embedded SQL in RPG ILE

    I want to write a program that will retrieve any field(s)from any file on the iSeries. The only part I haven't figured out is how to code the fetch statement to populate variables that aren't known until execution time

    Jeffm125 pointsBadges:
  • Modules in RPGLE

    Hi, Can anyone tell me what is module in RPGLE and how is it created? alos tell me how this can be called from rpgle?

    Mathi5 pointsBadges:
  • operation code-occur

    In what condition we have to use occur?what is the use of occur(Set/Get Occurrence of a Data Structure )?

    Cev105 pointsBadges:
  • diff. between two date

    Hello guys, I wanna do a one pgm which is find out date diff. between two date in rpg /400. Actually i did this in rpgiv...but now i want to do it in rpg/400. can somebody provide me a exact logic behind this.. Thanx in advance.....

    Swapniln35 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