RPGLE Program

Convert RPGLE to SQLRPGLE

How do I convert RPGLE program to SQLRPGLE? Software/Hardware used: AS400

Retrieve the RPGLE program from object

Hi all, I accidently deleted my program. Is there any way to retrive the program from its object. Software/Hardware used: AS400

RPGLE Program woes

I had an AS/400, consolidated to a newer one w/other facilities. When my library was restored and I tried to process an old program, it does not pull any data. I have not programmed in several years and have never used RPGLE. Do not know how to use debugger, etc. so I'm wondering if the problem...

RPGLE. cpytopcd

I have tried to create a file where every record is 80 characters long. Every record should be filled with spaces if the record is shorter than 80 char. In my program I use cpytopcd and this command seems to cut every record if there aren't any more characters. If you look at it in hexadec...

How do I call an API which is in a service program

I hope somebody can shed some light on the following. I need to call an API "QjoRtvJrnReceiverInformation" which is in service program QJOURNAL. I am not new to ILE but experience of using service programs and using API's within service programs is limited Do I need to code all the 'D' specs...

To Check the junk Values in RPGLE character field

How to check the junk values in character filed except the If loop? All values that can be entered from keybord are accepetable in this field. Need to check any other characters (jucnk values) stored in this field.   Software/Hardware used: AS400

Create a Stored Procedure using CL and RPGLE programs

I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.

How can we send error message at message line from RPGLE program.

Hi All, I want to send one error message at AS/400 message line from my RPGLE program. for example i want to send one error message to the user saying that "ABC File is empty" if he excutes my program.

RPGLE - Provide One-to-Many mapping

hi, I want to provide one-to-many mapping . consider 1 example, i have one-to-one mapping in Agent and Depot. bt i want, one Agent & Many Depot mapping. Means we can have one Agent with many Depot. using RPGLE or SQLRPGLE. I have one subfile where we can retrieve Agent, Agent name, and Depot...

Rpgle paramters from a Cl

I have a rpgle program with parameters. I can watch the parameters change in the program. When I call the program from a Cl language the parameters come back blank.

Batch Program

How can I Execute a RPGLE program in Batch after the IPL is fully loaded

converting numeric field to a character field and show leading zeros

I am using %char to convert a numeric 9 pos field to character for use in a larger out put field. My code looks basically like eval labelout - "4J'+lpart+%char(lexpire)+%char(lserl) Where lexpire and lserl are used in the labelout field, I need the leading zeros to show. Right now, they are...

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

Job Type

How to find the job type (Interactive/ Batch) using RPGLE Programs

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.

Sorting data in RPGLE

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

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