DO NOT use this tag for Role Playing Games!! RPG (Report Program Generator) is a high-level programming language (HLL) for business applications. IBM is the creator and primary vendor of RPG, but the language is available from other mainframe and microcomputer manufacturers, including Unisys. Use this tag for older non-ILE versions of RPG from IBM and for non-IBM variants of the language.
Questions tagged [rpg]
280 questions
0
votes
3 answers
how to select highest value for a field with condition given?
I'm doing time attendance system where my physical file(PF) have these fields:
User ID(key field),Date,Time In,Time Out
......
the problem is,I try to select for particular User ID and Date and highest value of Time Out for that day. and move the…
user1516536
- 23
- 2
- 5
0
votes
1 answer
Show CS (Column Separator) in a RED input-capable field using DSPATR(&ATTR)
I'm displaying a DSPF format from RPG using no indicators, but P-field attributes to vary color and input-capability. Turquoise and Yellow fields have the CS (Column separator) by default. If I use a format with indicators, an input-capable red…
Martin
- 1,430
- 10
- 19
0
votes
1 answer
Tabsequence un a DSPF subfile vertically, with multicolumn subfile
Is there a DSPF keyword, that defines that in a multi column subfile the cursor jumps to the first field in the occurrence on the same colomn, on the next line, when arriving from the last field in the column, in stead of the default behaviour,…
Martin
- 1,430
- 10
- 19
-1
votes
1 answer
Problem with RPG Prototype for java.io.File
I'm attempting to work with jsoup in RPGLE, but I don't know a lot about Java. I can't get past trying to create a java.io.File object to use in jsoup. I'm obviously doing something wrong, but I just can't seem to figure out what.
Here's my code:
…
Rob Schember
- 206
- 1
- 3
-1
votes
1 answer
Using a variable for a database file in embeded SQL in free RPG
I would like to write an sql statment, that works no matter what data file is wanted.
example:
exec sql select * from :variable;
I am getting a SQL0104 Error at the ":"
"Token not vaild. Valid Token :(NEW FINAL TABLE UNNEST LATERAL MLTABLE…
baphomet
- 11
- 2
-1
votes
1 answer
Convert a DS from fixed to free form in RPGLE
I have the following data structure in an old program
D P1PARM DS 256
D P1ADFR 1 15
D P1ADTO 16 30
D P1MSNR 31 37 0
D P1NSNR 38 44 0
D P1YEAR …
Kunal Roy
- 729
- 3
- 11
-1
votes
5 answers
What is usually preferred in a sub-proc, INZ during variable declaration or using CLEAR?
Assuming both choices will yield same results, what choice do you usually make and why?
dcl-proc test_proc ;
...
dcl-s count int(5) inz ;
...
// use count
end-proc ;
or
dcl-proc test_proc ;
...
dcl-s count int(5) ;
...
…
ojay
- 91
- 6
-1
votes
1 answer
extfld for an array of numbers
I have an array declared as a subfield of a DS as below:
MatchingWorkKeysList extfld('MATCHWKEYS') dim(50);
The MATCHWKEYS is defined in the external file structure as :
MATCHWKEYS CHAR (550)
So I get 50 elements of…
Theju112
- 185
- 7
-1
votes
1 answer
Excel Print-Papersize in RPGLE (Apache POI)
i try to setup the papersize to print my Excel with the Scott Klement - Excel-Tool.
Unfortunately I don't know how to do this correctly. I have an HSSF source where the Java methods are defined. In the RPGLE program, I then call them up accordingly…
Maurice
- 1
-1
votes
1 answer
How to fetch multiple records from a fetch statement in SQLRPGLE?
Recently in an interview I was asked how to fetch multiple record using a single fetch statement in SQLRPGLE. I would like to know is it possible to get multiple record using a single fetch statement, if yes then can some one elaborate?
Kunal Roy
- 729
- 3
- 11
-1
votes
2 answers
What is the best way to minimize the response from a cCALL statement in RPG?
We have a program which will be used by many other rpg programs. All process programs need to call this program to get a next counter number. As the program need to be loaded into memory and unloaded after every call, we may need some extra…
-1
votes
1 answer
I am getting a wrong content assist in RPGLE program in visual studio. Can anyone tell me what am I doing wrong?
RPGLE program in Vs code
I have enabled all the required extensions in vs code for RPGLE language support. Extension "RPGLE language tools" is supposed to show content assist for fully free format programs but it is showing me something else.
Dheeraj Dhawan
- 17
- 2
-1
votes
2 answers
Return dsply message from a rpgle pgm to a cl variable
I have a cl program thats call rpgle program. The rpgle program produces a dsply "message"
I want to set the dsply message as a variable in the cl program used to call the rpgle pgm.
What cl command to retrieve the dsply message to a variable?
As4rikru
- 35
- 3
-1
votes
2 answers
Comment in RPG?
I would like to put in comment several lines. In the documentation, we can use this -> (/*...*/)
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajp/rzajpcommentsirpg.htm
I tried several times but it does not work.
/*
dsply 'Enter your…
user13829429
-1
votes
2 answers
Miworkplace : An error has occured. See the log file (RPG)
I am learning RPG, and I have to install Miworkplace, I am trying to understand the tutoriel below:
https://miworkplace.com/docs/
I installed Java11 on my Windows 10
https://miworkplace.com/docs/Requirements
I downloaded Miworkplace on my…
user13829429