195 pts.
50 pts.
How to display message in display file from a MSGF
How to display a message (essentially error message) at the bottom in display file (DSPF) from a Message File (MSGF)? Also in order to display more than one message, how do I go about that? I have a MSGF, wherein all the messages are pre-defined, which we have to use. Would greatly appreciate your prompt [...]
Answer Question
| April 24, 2013 6:27 AM
AS/400 - DDS,
DSPF,
MSGF
430 pts.
SFLLIN
Using SFLLIN to create a two column display. Would like to tab down first column and then next column. col1-row1, col1-row2, col1-row3 etc. then col2-row1, col2-row2 ..instead of default col1-row1, col2,row1,col1-row2, col2-row2 Any idea how to control the tab key?
Answer Question
| April 22, 2013 8:54 PM
AS/400,
DSPF,
SFLLIN
44,630 pts.
2,030 pts.
25 pts.
Long field in display file
I have a display file which has a long field which is meant to hold a SQL query. The field is assumed to appear in the screen as 16 lines, with 68A per line. So When I declared a field of length 1088A(16*68) but how can I declare it to have only 68 per line [...]
Answer Question
| January 28, 2013 7:16 AM
AS/400,
DSPF,
SQL Query
2,030 pts.
DTF to Excel in Batch file
I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data. PROBLEM: How can I format the spreadsheet with headers and column fonts and colors, [...]
Answer Question
| January 25, 2013 7:20 PM
Batch file,
DTF,
Microsoft Excel
10 pts.
2,030 pts.
How to change a field description
I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is … how to do this without re-creating the PF? I did this once (4 years ago) but I don’t remember what command I used to make it “take” (just changing the source [...]
Answer Question
| January 22, 2013 7:34 PM
AS/400,
DDS
1,565 pts.
How to implement MOUBTN using RPG III/RPG400
We are converting some code in a legacy application and, in its simplest form, want to know that a mouse has been used/clicked rather than ENTER pressed. We are not that familiar with the MOUBTN keyword, which we assume will tell us what we want, and are having trouble getting this to work. Though we’ve [...]
Answer Question
| January 17, 2013 2:58 PM
AS/400,
DSPF,
MOUBTN,
Mouse,
RPG III,
RPG/400
250 pts.
1,145 pts.
History Logs
Have a question conerning History Logs, since the logs continue to grow, we back the logs up and save them to Tape. However we need to look at some of the logs on the system, here is the issue. We can restore the logs however there is another log with the same name on the [...]
Answer Question
| December 28, 2012 10:31 PM
DSPLOG,
OS/400
20 pts.
80 pts.
DFU to SQL translator
Is there a package that will allow the user to enter DFU commands and then translate to SQL and send that to the processor? The situation is that the logging program doesn’t see DFU commands but does see SQL statements.
Answer Question
| November 30, 2012 9:21 PM
DFU,
SQL,
SQL statement
10 pts.
User defined command
Hi, I want to create a command such that the user only needs to specify (say) a data area name and the command should be automatically fired and perform DSPDTAARA on the parameter specified. I’m not sure how and where to start this because I don’t want the syntax to be - mycmd (data area [...]
Answer Question
| November 28, 2012 10:35 AM
AS/400,
DSPDTAARA
25 pts.
5 pts.
250 pts.
List of objects
Hi.. I got to create a pf which will have list of objects present in all the user libraries availabe. When i use DSPOBJD, the server gets struck. DSPOBJD works fine when a specified library is specified. But in order to get all the objects, is there anyother options?
Answer Question
| October 19, 2012 5:46 AM
DSPOBJD,
object,
Outfile,
RPG,
RPGLE
270 pts.
10 pts.