How to set-off many indicators at the same time?
How to set-off many indicators at the same time in RPG-III? There is a situation wherein I need to set-off 7 to 8 indicators at a time (simultaneously). planning to use MOVEA ’00000000′ *INXX; XX being the starting indicator. but it’s asking for the ARRAY. I know to declare a normal array. but how do [...]
Answer Question
| June 5, 2013 7:16 AM
AS/400, RPG
How to set-off many indicators at the same time in RPG-III? There is a situation wherein I need to set-off 7 to 8 indicators at a time (simultaneously). planning to use MOVEA ’00000000′ *INXX; XX being the starting indicator. but it’s asking for the ARRAY. I know to declare a normal array. but how do [...]
Answer Question
| June 5, 2013 7:16 AM
AS/400, RPG
SQL vs RPG
We are using a huge number of SQL on our production machine. We have our back up machine equal to the production machine where is located our data warehouse based on RPG. Can you help me with arguments to defense that all SQL should be moved into RPG programs at our DW?
Answer Question
| May 31, 2013 10:46 AM
RPG, RPG Program, SQL
We are using a huge number of SQL on our production machine. We have our back up machine equal to the production machine where is located our data warehouse based on RPG. Can you help me with arguments to defense that all SQL should be moved into RPG programs at our DW?
Answer Question
| May 31, 2013 10:46 AM
RPG, RPG Program, SQL
Read records for a particular period in RPG
Hi all! I have a date period in RPG as month and year like 072012 and 022013 both are character fields. I’m passing this fields from OPNQRYF in CL program to RPG. How can I read records from a master for this particular period in RPG? Surey
Answer Question
| May 29, 2013 11:25 AM
AS/400, CL Program, RPG
Hi all! I have a date period in RPG as month and year like 072012 and 022013 both are character fields. I’m passing this fields from OPNQRYF in CL program to RPG. How can I read records from a master for this particular period in RPG? Surey
Answer Question
| May 29, 2013 11:25 AM
AS/400, CL Program, RPG
More than 50 files in RPG?
How can i declare more than 50 files in RPG/400 program?
Answer Question
| May 20, 2013 11:54 AM
AS 400, RPG, RPG Code
How can i declare more than 50 files in RPG/400 program?
Answer Question
| May 20, 2013 11:54 AM
AS 400, RPG, RPG Code
Convert time stamp to dd/mm/yy
How can I convert a timestamp field(declared with type ‘Z’ in database) to dd/mm/yy format in RPG?
Answer Question
| May 16, 2013 11:39 AM
AS/400, AS/400 date format, RPG
How can I convert a timestamp field(declared with type ‘Z’ in database) to dd/mm/yy format in RPG?
Answer Question
| May 16, 2013 11:39 AM
AS/400, AS/400 date format, RPG
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
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
Reading files in RPG
I’m new to AS/400 and I’m still learning more about it. One question I have is…How can I read records without using SETLL, READ, CHAIN in RPG?
Answer Question
| April 16, 2013 9:24 AM
AS/400, RPG
I’m new to AS/400 and I’m still learning more about it. One question I have is…How can I read records without using SETLL, READ, CHAIN in RPG?
Answer Question
| April 16, 2013 9:24 AM
AS/400, RPG
Control Indicators
What are control break logic indicators?..How they work?
Answer Question
| April 8, 2013 6:59 PM
AS/400, RPG
What are control break logic indicators?..How they work?
Answer Question
| April 8, 2013 6:59 PM
AS/400, RPG
RPGILE To RPG IV conversion
How RPG/400 code can be converted to RPG IV code with a single command?
Answer Question
| April 4, 2013 3:50 PM
AS/400, RPG
How RPG/400 code can be converted to RPG IV code with a single command?
Answer Question
| April 4, 2013 3:50 PM
AS/400, RPG
DBCS
What is DBCS(Double byte Character Set)?..what purpose we use it?
Answer Question
| April 4, 2013 2:46 PM
AS/400, RPG
What is DBCS(Double byte Character Set)?..what purpose we use it?
Answer Question
| April 4, 2013 2:46 PM
AS/400, RPG
Indicators in RPG
HI, I am a cobol400 developer and new to RPG and curious to know much about RPG… My question here is In what scenarios we use the below indicators 1.Overflow indicator 2.Record Identifying indicator 3.Control level indicator 4.Field level indicator 5.Resulting indicator Thanks in adv Anup
Answer Question
| March 27, 2013 12:11 PM
AS400 RPGLE, RPG, RPG indicators
HI, I am a cobol400 developer and new to RPG and curious to know much about RPG… My question here is In what scenarios we use the below indicators 1.Overflow indicator 2.Record Identifying indicator 3.Control level indicator 4.Field level indicator 5.Resulting indicator Thanks in adv Anup
Answer Question
| March 27, 2013 12:11 PM
AS400 RPGLE, RPG, RPG indicators
SFL
I have a SFL. In which I have a option selection field. I have used reverse image indicator for it. But when I insert a wrong value in that field, then the entire column is highlighted instead of the option selection field for that particular record. What should I do?
Answer Question
| March 27, 2013 7:11 AM
RPG, RPGLE, SFL
I have a SFL. In which I have a option selection field. I have used reverse image indicator for it. But when I insert a wrong value in that field, then the entire column is highlighted instead of the option selection field for that particular record. What should I do?
Answer Question
| March 27, 2013 7:11 AM
RPG, RPGLE, SFL
24 digit number: Arithmetic operations?
Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus “131400″ to a 24 digit number. Compute Modulo 97 of this number. (or [...]
Answer Question
| March 21, 2013 8:03 AM
COBOL/400, IBMi, RPG
Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus “131400″ to a 24 digit number. Compute Modulo 97 of this number. (or [...]
Answer Question
| March 21, 2013 8:03 AM
COBOL/400, IBMi, RPG
RPG – Roll your own level breaks
Has anyone every heard of ‘Roll your own Level Breaks’ in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, [...]
Answer Question
| March 19, 2013 9:04 PM
AS/400, RPG, SQLRPGLE
Has anyone every heard of ‘Roll your own Level Breaks’ in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, [...]
Answer Question
| March 19, 2013 9:04 PM
AS/400, RPG, SQLRPGLE
Add a new field in PF
Is it possible to add a new field in an existing PF without deleting the records that are present in it?
Answer Question
| March 14, 2013 12:59 PM
Physical Files, RPG
Is it possible to add a new field in an existing PF without deleting the records that are present in it?
Answer Question
| March 14, 2013 12:59 PM
Physical Files, RPG
Adding values to second member of PF
Suppose I have a PF named ‘Member’ and I have added a new member ‘Mbr1′ to this pf. How can I add values to the second member(Mbr1)?
Answer Question
| March 12, 2013 1:05 PM
RPG, RPG Program
Suppose I have a PF named ‘Member’ and I have added a new member ‘Mbr1′ to this pf. How can I add values to the second member(Mbr1)?
Answer Question
| March 12, 2013 1:05 PM
RPG, RPG Program
RPG / free command to movel 6 digit field to 8 character field
I am using RPG /free — I need to move a 6 digit numeric field to 8 character field and it needs to be left justified. How can I do this?
Answer Question
| March 1, 2013 3:58 PM
RPG, RPG field
I am using RPG /free — I need to move a 6 digit numeric field to 8 character field and it needs to be left justified. How can I do this?
Answer Question
| March 1, 2013 3:58 PM
RPG, RPG field
Using 2 different display sizes in a display file
I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 - 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on [...]
Answer Question
| March 1, 2013 2:24 AM
AS/400, RPG, RPGLE
I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 - 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on [...]
Answer Question
| March 1, 2013 2:24 AM
AS/400, RPG, RPGLE
How to easily perform date conversions in RPGLE (Including Substringing!)
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
Over the years I have had to modify my fair share of outdated code, especially when it comes to Date Conversions. Not every system uses an 8 position numeric date field. The place I’m currently at still has a number of files with a 6 position numeric date field. I was wondering if anyone else [...]
Answer Question
| February 26, 2013 5:30 PM
RPG, RPGIV, RPGLE
How to display total of all the records that contain the same primary key in RPG4?
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
