RPGLE

Help to get good course to learn RPGLE!

Hi all. I am a beginer in RPG and i really want to have a full course step by step to learn and understand RPG programming . Can any one lead me to any good free accessed Books or materials that can help me , are their any book's servers for IBM other than that IBM info center ?? Thanks in...

AS400 Physical file conversion to xml file

Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.

Falshing output screen!!

Hi, When i try to call a compiled RPGLE program : *************** Beginning 001.00 /free 002.00 dsply 'hello'; 003.00 *inlr= *on; 004.00 /end-free No errors their but fast output screen appear to disply "hello" then goes . want it...

converting ILE legacy code to a GUI based system

We are trying to move out of the old "GREEN SCREEN" code. Our software company is heading towards a GUI interface, but we currently have approx 250 custom programs that would need to be converted. Just about all of our legacy code is written in RPLGE / CLLE. We have a few simple apps that were...

L Spec in RPG/RPGLE

Hi, In our project we are using L-Spec in some of the program. Can any one explain the basics of L-Spec. Sabarish

Using SQL Connect Statement in SQLRPGLE

I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...

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.

Add, change and delete Subfile records

We currently have an order entry program that lists items on an order and you can position to an item via a field in the CTL area. My question is I need to be able to add items to an order by keying in items, qty, etc from the bottom of the screen. The order header info needs to be on top of the...

understanding and detecting sql performance situation with abnormal 400 shutdown

Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...

Exfmt opcode

Hi in a display file i can have many record formats.But while using them for I/O operations in the RPG programs can i use multiple EXFMT operation at different places? And how to control it in loops.Give me an example. Also tell me sample code for F12-cancel to go to the previous screen of display...

What is command we can use for calculate difference between 2 times (like subdur)?

we can use subdur for calculate the difference between 2 dates. and what's the function code that can use for difference between two times?

RPG/400 CHAIN opcode

Hi,anybody tell me how to find the end of file situation while reading through the CHAIN opcode on a file in RPG/400 and in RPGLE. I think RPGLE we have %found built in function.thanks

How to use XML in RPG

Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the complete process or code. Thanks.

Day of Week in RPGLE

Hi, I need to get the DAY for the given date in RPGLE program Is there any efficient method available to calculate this or any reliable APIs? Heard that CEEDYWK is very useful API to calculate the DAY OF WEEK. if any of you have the sample code, please share with me. Thanks in advance. -Deva

RPGLE pgm to determine the last day for a month

does anyone have an rpgle pgm that will return the last day of the calendar month if given the month and year.

I want to read a pf and build a corresponding SQL statement and save the statemnet in text file.

how can i read pf ?as pf is colomn speciffic have to read pf like it will have feilds and some constraint, key, record. how can i build a corresponding SQL statement ? i m new in AS/400 but i have to submit this utility to my manager this thursday.. can anybody help me in providing some code for...

RPGLE %CHAR strips off leading zeros

Chan we stop %CHAR from removing the leading zeros?

How to automate getting the .CSV file from IFS folder to local desktop

I am working on tool which extract the data from physical files based on some condition and creates a .CSV file in IFS folder. I want to automate the process to get the CSV file to local Desktop and should save the file in specified location in local system. Is there any way to open the .CSV...

IFS Get list of files in a directory in RPGLE

Need to retrieve into a RPG program a list of all files in a folder on the IFS. Can this be done?