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
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 [...]
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
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) [...]
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
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 [...]
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
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
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
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 [...]
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
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, [...]
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
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 [...]
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
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?
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
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
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
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 [...]
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
I need to have “hyperlink” functionality on an AS 400 Green Screen. Is there anyway to do this. Is there any DDS keywords.
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
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 [...]
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
How can i create one Logical File based to more than one Lib
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
Diff between SETON LR, RETURN. Please tell with an example
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
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?
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
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 [...]
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
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.
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
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 [...]
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
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 [...]
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
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 [...]





