AS/400 – DDS Questions


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:
340 pts.

How to display more than 1 error message in a message subfile
I currently have a screen that display an error 1 at a time in a message subfile. User can roll up or down to display the next error. I want to be able to display all errors in message subfile in 1 full screen when user hits a function key. Since the message subfile (sflpag=1) [...]

Answer Question   |  October 24, 2012  4:33 PM
AS/400 - DDS, AS/400 applications
asked by:
40 pts.

CL script required for tape automation process
Hi All, allocated with LT04 tape unit in the physical 3584 tape library. The following scenarios to test:  • Tape properly loaded  • Improperly loaded  • No tape  • Incorrect Category  • Aborted, try to restart. CL script required for tape automation process to check the above 5 scenarios. Any help will be appreciated. Thanks [...]

Answer Question   |  February 28, 2012  3:36 PM
AS/400 - DDS, AS/400 backup, AS/400 BRMS, AS/400 hardware, AS/400 programming
asked by:
275 pts.

AS400 – DDS Keyword
I want to use MOUBTN Keyword with specific Field. Eg: If i click Test “Enter to Process” in my Screen, Process operation needs to be executed. (Like On – Click in VB). How to do in AS400 Display Screen

Answer Question   |  March 17, 2012  9:28 AM
AS/400 - DDS
asked by:
1,025 pts.

Printing Electronic Signature that is Printer Resident
HELP!!!   I am trying to print an electronic signature that is printer resident on an HP printer attached trough the LAN.  I have the PCL Escape sequence from the manufacturer.  So far, I have retrieved the WSCST source, modified it to include an INDFNTE tage with a unique font id (used to passs the PCL [...]

Answer Question   |  June 24, 2011  2:47 PM
AFPDS, AS/400 - DDS, AS/400 printing, DDS, iSeries V6R1
asked by:
45 pts.

How to speed up AS/400 SQL?
We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow – 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, [...]

Answer Question   |  June 8, 2011  8:46 AM
AS/400 - DDS, AS/400 SQL, Data warehouse, DDS, Showcase
asked by:
2,195 pts.

AS/400 Display Files Not Retaining Last Window
So I have used this “dummy record many times before. Now with a new program/dds it will not.. Could it be b/c my new program is defined DSPSIZ(27 132 *DS4) and the program calling the new programs display size is DSPSIZ(24 80 *DS3)…  i need the calling program 80 column screen to stay while I [...]

Answer Question   |  March 14, 2011  8:02 PM
AS/400 - DDS, AS/400 Display File, Display File
asked by:
1,780 pts.

AS400 Logical files
I have added a data member to the physical file. But the in logical file it is not accessing the newly added data member. Could any one help me, what should i need to do to access the new data member data through logical file without compiling the logical file?

Answer Question   |  January 27, 2011  12:05 PM
AS/400, AS/400 - DDS, AS/400 Data File, Logical Files
asked by:
5 pts.

Panel Group (PNLGRP) source
Company occasionally lost a couple years ago the sources most of panel groups. Have you any idea how restore these sources even with errors? May be some API or other methods can help solve this problem. Thank you in advance, Yuriy Umanskiy

Answer Question   |  September 16, 2010  8:52 PM
API, AS/400 - DDS, AS/400 API, PNLGRP
asked by:
25 pts.

adding field on screen DSPF
Hi, i added a new field on the screen, declared the variable just like a similar one present in the screen. now I am changing the COBOL program of the same screen. I used the same variable to move value into it. As test I and to check whether issue is with how i have [...]

Answer Question   |  June 22, 2010  1:59 PM
AS/400, AS/400 - DDS, COBOL, DSPF, Screen Design Aid
asked by:
125 pts.

Hyperlink functionality on AS 400 Green Screen
I need to have “hyperlink” functionality on an AS 400 Green Screen. Is there anyway to do this. Is there any DDS keywords.

Answer Question   |  April 22, 2010  12:16 PM
AS/400, AS/400 - DDS, AS/400 green screen, Hyperlink, RPGLE
asked by:
35 pts.

AS400 EMULATOR TO DOWNLOAD IN WINDOWS 7 ?
Earlier I was downloading from Mochasoft.dk site. Now a days when I am trying to download there is nothing available for free ? Can any one give me links to download at free of cost ? I was creating an User from as400profis.de site . Now a days it is also not available. How can [...]

Answer Question   |  February 5, 2010  6:42 AM
AS/400 - DDS, AS/400 Emulator, Windows 7
asked by:
125 pts.

DDS Logical File
How can i create one Logical File based to more than one Lib

Answer Question   |  January 18, 2010  5:24 PM
AS/400 - DDS, DDS, DDS Logical Files, Logical Files
asked by:
5 pts.

SETON LR and RETURN.
Diff between SETON LR, RETURN. Please tell with an example

Answer Question   |  December 7, 2009  9:42 AM
AS/400 - DDS, SETON
asked by:
Kar
425 pts.

LoadAll Subfile
For LoadAll subfile, the SFLSIZ is limited to some 9999* records, how can I display beyond that one? Is it possible to display more number of records over the limited size?

Answer Question   |  December 17, 2009  9:40 AM
AS/400 - DDS, AS/400 Subfiles
asked by:
Kar
425 pts.

Expand All Subfile
For Expand All Subfile processing, we define SFLSIZ(11) and SFLPAG(10). Case: First page of 10 records loaded, then user pressed pagedown. however actually we are restricting the subfile size to only for 11 records. Anyway the subfile is expanded and next set of records gets loaded. My question is: How the system handles the expanding [...]

Answer Question   |  December 8, 2009  9:35 AM
AS/400 - DDS, AS/400 Subfiles
asked by:
Kar
425 pts.

CA and CF keywords
Whats the exact diff between CA and CF keywords, and how the system handles the difference between them? If possible please explain it with an example.

Answer Question   |  December 2, 2009  9:31 AM
AS/400 - DDS, AS/400 Keywords, CA, CF
asked by:
Kar
425 pts.

How to determine the relevant MONMSG
How to determine the relevant MONMSG to be used with out knowing the exact MONMSG id to be used. Ex: If CHKOBJ command line is there in a CLP, below that we dont know what the monmsg id CPFXXXX to be used, in that case how you find out the exact ID to be used [...]

Answer Question   |  December 4, 2009  9:29 AM
AS/400 - DDS, MONMSG
asked by:
Kar
425 pts.

Setting breakpoints in debug
I know you can set breakpoints without using F6 by typing break and the line number at the debug screen. I need to know how to set up a conditional break point. I essentially need to know exactly when a field is being populated. How would something like this be correctly written: “break when badd3 [...]

Answer Question   |  October 19, 2009  4:55 PM
AS/400 - DDS, breakpoints, debug, Debugging
asked by:
100 pts.

Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows
I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date [...]

Answer Question   |  October 9, 2009  9:09 PM
AS/400 - DDS, AS/400 data transfer, DDS, DDS Server, Excel 2007, Excel to iSeries, Exporting AS/400 to Excel, Microsoft Excel
asked by:
35 pts.