RPG

File maintenance

Hi, I have a file with million records and a batch program scheduled in the night maintains it. But it's found that the program is taking too much time for it's completion.How can we control and complete the program execution within one hour programmatically? thanks

delete from flat file

HI My flat file contains data copied from a spool file.The records in this file is used as reference to delete links from dir.Can i delete those records in the flat file for which there is no link in the dir(that is the link or text file object has been deleted from the dir) ?I tried using...

AS400 - RPG

What is the difference between *NAMVAR and *DTAARA in RPG Programming

Unable to use delete statement in SQLRPG

Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

RPG/400 - How to send spoolfiles to different users

Please advice how to send spoolfiles to different users.

RPG/400 - CL command to search a record like CHAIN opcode in RPG

Please advice we have any command there in CL to search or find a record like CHAIN opcode in RPG.

RPG/400 - How to check if record is reaching end of the file in CL

Please advice me how to chck record is reaching end of the file in CL.

Links for Subfile programming and RLU

can I get some links for basic subfile programing and RLU.

Doubt in *noMAX parm

Does *nomax actually have some value.That is if i give the initial no of record parm as *nomax what will be the maximum number of records the file wiil accomodate.I believe there is some limit?

RPG/400: Maximum and minimum values

Please advice how to find out maximum and minimum values in particular filed using rpg/400.

How to get the duplicate records using RPG/400

Please advice how to get the duplicate records using rpg/400.

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

how do you code a table in rpg

I need to code a table in rpg iv. I'm new to rpg and need assistance on coding techniques as it pertains to creating a table in a rpg iv program

How can I find out , where I am in Intereactive mode or Batch mode in RPG ?

How can I find out , where I am in Intereactive mode or Batch mode in RPG ?

delete records in a RPG flat file

Hi I have created a flat file which holds the DSPLNK details of a text file that is dsplnk creates a splf which is copied to this flat file.This file is read for purging the text file once in 2 months.This happens on a daily basis and i have merged this piece of code with the one that retreives...

ftp rpg

Hi I have called a program which would read the contents of the FTPLOG file member for successful transmission and sets an error flag ERR accordingly.Now i need to pass this value from the RPG to CL and use it to send a notification CALL PGM(FTPLOG) IF ...

Data Area Lock issue in RPG ILE

Hi, I am using a data area in a RPG ILE program which will lock the data area and updates value. If the data area is locked, the program has to unlock the data area which is locked by the same user in any of his other session. Is it possible? If yes, please let me know steps have to be followed for...

rpg/400

please advice me how to convert numeric field to character field in rpgile.

Embedded SQL over multiple physical file members

Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have...

Please explain RPG "Bind by Copy" and "Bind by Reference"?

Can you explain the terms with example BIND BY COPY BIND BY REFERENCE