AS/400 Tag Directory

Featured AS/400 Questions

How to get the maximum access path size value in a program?
Hi Friends, My requirement is to get the Maximum access Path size value in the program, I have the value asĀ 1TB and 4GB in 2 different PF in different machine by DSPFD command. But I could not get the details when I OUTFILE using DSPFD, Even I tried RTVOBJD, RTVMBRD, I could not find it [...]

Answer Question   |  June 18, 2013  2:56 PM
AS/400, AS/400 commands, DSPFD
asked by:
195 pts.

Transferring data between iseries without using DDM/FTP
Is there any better way of transferring data between iSeries without using DDM/FTP?

Answer Question   |  May 16, 2013  1:04 PM
DDM, iSeries
asked by:
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
asked by:
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
asked by:
44,630 pts.

Show multiple error messages at the bottom of display file
I want to show multiple messages on a DSPF, when user keys page down, I want it to appear one by one. I know we can do this, but now I don’t remember exactly. Please give a hint.

Answer Question   |  February 7, 2013  7:04 AM
AS/400, DSPF
asked by:
2,030 pts.

Duplicate records in a keyed physical file
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.

Answer Question   |  February 1, 2013  3:06 PM
DDS, Physical File
asked by:
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
asked by:
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
asked by:
10 pts.

Retain the values in the inital screen after coming back from the popup window
I have a screen which displays the account numbers. If i input some values to this account field and when i do an F5(without hitting enter) I can see the popup window, but after coming back from the pop up screen, my account numbers are gone. I have used CA05 for the popup. If I [...]

Answer Question   |  January 24, 2013  2:15 PM
AS/400, DSPF
asked by:
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
asked by:
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
asked by:
250 pts.

AFPDS PRTF special character printing within text string?
Is it possible to include a special character within a text sting output to an AFPDS print file? We have output the special character by using a symbol character set but it has to be output as an individual field and results are not perfect for different printers. Has anyone created a DDS Print file [...]

Answer Question   |  January 8, 2013  9:02 PM
AFPDS, AS/400, DDS, FNTCHRSET, PRTF
asked by:
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
asked by:
20 pts.

Share objects between two AS/400 machines on a same network.
Hello, I would like to know if it is possible to share a disk between two AS/400 machines. I know about DDM but I would like to know if it is possible otherwise. Thanks.

Answer Question   |  December 13, 2012  9:49 AM
AS/400, DDM
asked by:
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
asked by:
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
asked by:
25 pts.

Colors on certain displayed constants are getting reset
On the first display of a format colors are fine, but on subsequent refresh certain constants are getting reset to default color. How do I prevent this? +1′Typ’ DSPATR(&@BLU) TIA

Answer Question   |  November 14, 2012  9:11 PM
AS/400 v6r1, DSPATR, PFIELD
asked by:
5 pts.

Can removal of window records be prevented when writing to nonwindow record
With respect to an AS400 27*132 display file… When writing to a nonwindow record, all window records are removed from the display. Is there a way to prevent this whereby none of the windows are removed? We are trying to write a 1-line record to line 27 (SLNO(27)) without a series of cascading windows being [...]

Answer Question   |  November 5, 2012  6:24 AM
AS/400, DSPF
asked by:
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
asked by:
270 pts.

display asterisks in entry field
How can a entry field display asterisks when letters are keyed?

Answer Question   |  September 6, 2012  2:00 PM
DSPF
asked by:
10 pts.