Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.
Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as ‘%’ and if Numeric default till the length of the field with -9999. As per now I’m getting two options. 1. Create the [...]

Answer Question   |  April 26, 2013  4:53 PM
AS/400, DB2, RPG, RPGILE

RPG lookup, write, then update if necessary
Can anyone help me code in free form RPG for, I want to look up a file to check a record is in there, If it is, I want to transfer that to a table, (it is already set up) Else Update with new record then write to table Thanks

Answer Question   |  November 29, 2012  8:23 AM
RPG LOOKUP, RPGILE

Insured Name not displayed properly
I have a program which accepts inputs from the user on the screen.Accordingly it would display. Problem – User enters CHRIS(only accepts capital). When user hits enter it is displaying insured name starting with CHRIS only. Though database is having both CHRIS and Chris. Is there any built-in-functions to trap both CHRIS and Chris and [...]

Answer Question   |  July 17, 2012  9:32 AM
RPGILE

Can I Declare a variable-length Array?
Is it possible to Declare a variable-length Array viz.. like we have in “VARLEN” in DDS?

Answer Question   |  March 17, 2012  1:31 PM
AS/400, RPG/400, RPGILE

Output file
I have an logical file,3 physical files and i need to create an output file which will extract all the data present in the files how can i do that using RPG.

Answer Question   |  March 19, 2012  4:23 PM
RPGILE

What do numbers in INFDS/SDS declaration signify ?
I am new to RPGLE .What is the meaning of numbers in D spec(eg:378 379B or 244 253).are there any others ways to declare INFDS or SDS ? fDROP2AD cf e          workstn INFDS(INFDS) f                                         SFILE(SUB01:RRN1) // Data Structures d Infds       ds                                    INFDS data structure d Currec                [...]

Answer Question   |  March 6, 2012  6:20 AM
INFDS, RPGILE

Are there any Synon experts out there? (20 plus years)
Experienced, 20 years plus, synon developers have probably forgotten more about synon than the new generation (yes there are young people learning synon) will ever know.   Does any of those experts remember the phantom + sign on subfile displays when there were no more records to display?  If so, what is the solution to [...]

Answer Question   |  March 17, 2012  7:46 PM
RPG, RPG ILE, RPG IV, RPG Language Support, RPG/400, RPGILE, RPGLE, Synon, Synon 2E, Synon/2E, Synon/Cool 2E

Reading only the active records in a flat file
I have a physical flat file which has thousands of deleted records. (I can’t get exclusive use of the system to do a reorg) I am doing a sequential read of the file because the file only has a few active records. However, it is taking the program awhile to finish and I’m guessing it is [...]

Answer Question   |  March 31, 2012  7:05 PM
AS/400 flat file, RPG, RPG ILE, RPG IV, RPG/400, RPGILE, RPGLE

how to explore a new AS/400 application?
Dear esteemed AS/400 Gurus! I am faced with a new problem. I have been put on a new AS/400 application(Banking related) & am expected  to deliver results within very short time(of about 15-days). Hence I request you to let me know How to learn any new AS/400 application fast/quickly & explore it. (NOTE: I don’t [...]

Answer Question   |  March 31, 2012  5:09 AM
AS/400, AS/400 applications, RPG/400, RPGILE

CPF5032 member already locked to this job
I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be [...]

Answer Question   |  February 21, 2012  6:39 PM
*INLR, CPF5032, RPG, RPG ILE, RPG IV, RPG Programs, RPGILE, RPGLE, V5R4

AS/400 English to Arabic data
Hi , Is there is way to convert as Data(Character) which is store in English to Arabic  via Rpgile Pgm  .  Are there any API for it  .   Thanks , Bisht

Answer Question   |  March 21, 2011  8:23 AM
AS/400 administration, AS/400 Languages, RPGILE

Reorganizing AS/400 Files While Active
I work for a company which is a 24/7 company. I cannot get them tp give up the system for any length of time. As a result, any type of maintenance is almost impossible. My biggest problem is reorganizing our files. I have heard that you can do a reorg while active but you must [...]

Answer Question   |  February 10, 2011  2:36 PM
AS/400, AS/400 Record Reorganization, RPG, RPG ILE, RPG IV, RPGILE, RPGLE, V5R4

RPG III to RPG IV conversion
how to convert rpg iii code into rpg iv?

Answer Question   |  December 21, 2010  8:50 AM
AS/400, RPG Programming, RPGILE

How to Test for Numerics in AS/400
I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? any help would be of [...]

Answer Question   |  November 24, 2010  9:18 AM
AS/400, Numeric, RPG/400, RPGILE

Reorganization of V5R4 while active
We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is [...]

Answer Question   |  September 23, 2010  5:22 PM
CL, CLLE, CLP, RPG, RPG ILE, RPG/400, RPGILE, V5R4

Embedded SQL in RPGILE
For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?

Answer Question   |  September 16, 2010  5:40 PM
RPGILE, SQL Query, SQL/400

get an i-Series *LIBL in a .NET program
I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started looking into [...]

Answer Question   |  September 7, 2010  4:37 PM
.NET, AS/400, iSeries, LIBL, RPGILE

Debug batch job
hi all,     how to debug batch job please give me in details… thnx

Answer Question   |  October 19, 2010  8:41 PM
AS/400 batch jobs, Batch jobs, CLP, RPGILE, V5R4

What will happen in AS/400 if I use H dump?
H  DUMP     what will happen to the program

Answer Question   |  September 7, 2010  6:51 PM
AS/400, AS/400 Dumps, RPGILE

Runtime Session resolution change
I want to change seesion resolution from 24X80 to 27X132 in runtime through RPG ILE. Please help me on this regard, by giving sample code.

Answer Question   |  August 27, 2010  11:49 AM
RPG ILE, RPGILE, Source code