RPG

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?

OPNQRYF

Is it possible to access a file created by opnqryf in an RPG/400 program using keys? I have defined the KEYFLD parameter but the RPG doesn't find the records when using READE or CHAIN

How can As400 RPG check if user is logged in

Looking for As400 RPg code to check if user is logged in AS400. All assistance is greatly appreciated. Thanks, Alex Bernardo

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.

SQL or RPG

Would it be better to use SQL or RPG, to update one field in the file with a value from another field in the same file? I am not that familiar with SQL, only a beginner. My RPG skills are rusty as I've not written anything in the last 4 years.

Logical Relationship in Input Specs in RPG

Hi, We can use operators AND/OR (in position 16:18) to specify logical relationship for Record Identification codes of an input record. I understood in what cases we use AND operator, but I couldn't understand in what cases one can use OR operator. I would be highly thankful if someone can help me...

Make RPG ILE programs look better

How can i use my as400 programming screen look better using different colours for my comments.

Program calls on AS/400

How i can check that my previous call to a program from other program was successful. Only after successful call and run only i can call another program. How to do check this in RPG and CL?

SQL in RPG (Error when TESTING (i.e. running under ISDB) RPG program which builds SQL statement and then uses PREPARE,DECLARE,OPEN,FETCH,CLOSE)

Under ISDB, JOBLOG showed' Internal Error 1001 has occurred SQLCOD -901' SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’ SQLERP was ‘QSQROUTE’ - According to Manual ‘DB2 Universal Database...

RPG vs Java vs Others

Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a...

RPGLE %CHAR strips off leading zeros

Chan we stop %CHAR from removing the leading zeros?

CPW source code

I would like to simulate a CPW benchmark. Is there source code (preferrably on RPG) available and how can I obtain it? Or is it just IBM private property?

Passing parameters thru LDA

Hi i want to know how the parameters can be passed from one RPG program to another RPG program using LDA.Please give me an example code. thanks Ram

RPG Program works fine in debug (ISDB)

I am coding a program in RPG/400 on OS v5r4. The program uses input files to calculate several program described fields for a report. The program does not calc correctly when I call it from the command line. The program works as expected when I run it through debug (ISDB). I am using the same sign...

How to open file in different modes in RPG?

Hi, There have been a lot of changes in RPG over the last few years and I've lost track of many of these changes, so I have a question about file opens in RPG :- Is it possible to open a file for either input only or update without using overrides (and preferably without multiple F-specs)? The...

RPG sub-procedures

What have you found to be an over-riding reason to use a sub-procedure in an RPG program instead of a sub-routine?

OVRDBF Not working as supposed to

Here's the program flow CL1 calls RPG1 RPG1 calls CL2 CL2 has OVRDBF on fileA that is being used in RPG1 When the control gies back to RPG1, the file is not overriden. So I thought it might have ended at call level and I tried to do OVRDBF in RPG1 after the control come back from CL2 but still no...

Check for file lock on the IFS in RPG

I need a way to check to see if a text file is locked on the IFS in an RPG program. I am running the following command in the rpg program: ReturnInt = Open(%Trim(EntryPath):O_RDONLY+O_SHARE_NONE);. When I do this for an excel file the returnint comes back with a -1 if the file is locked. However...

AS/400 to Java migration

Hello, could someone suggest me an appropriate tool for AS/400 to Java migration? also, I am more interested if that is a product and not a service.