Retrieving Source (DDS) from object file
I lost my physical source file (DDS),but its object is there.I can view the contents of it.Can I retrieve the source file(DDS) from its object?? Please help…………..
Answer Question
| December 17, 2009 8:29 AM
AS/400 development, DDS
I lost my physical source file (DDS),but its object is there.I can view the contents of it.Can I retrieve the source file(DDS) from its object?? Please help…………..
ovrdbf in rpg
hi guys.. i am getting a file name as a variable from CL program. based on some condition i want to write in differnt members of the file.since the file name is stored in a variable i cant able to declare it in f spec. so i created a duplicate object for that file and [...]
Answer Question
| November 30, 2009 6:04 AM
DDS, OVRDBF, RPG
hi guys.. i am getting a file name as a variable from CL program. based on some condition i want to write in differnt members of the file.since the file name is stored in a variable i cant able to declare it in f spec. so i created a duplicate object for that file and [...]
Need to find everyplace a file is being used.
I have a file that we are adding a field. Need to find every program the file is being used to know which ones need to be recompiler. Would be nice to do one big search of the entire library.
Answer Question
| January 12, 2010 3:37 PM
DDS, RPG, RPGLE
I have a file that we are adding a field. Need to find every program the file is being used to know which ones need to be recompiler. Would be nice to do one big search of the entire library.
Callin CLP with parameter
Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm(’14′ ‘aaaaa’) But it takes value as F1F44040404040. Hel me out soon. Thanks in advance [...]
Answer Question
| October 20, 2009 9:40 AM
CL programming, CL programs, DDS
Hi, I have a CL program which needs two Parametersa as a input, when i call a pgm with values, the value are not properly passed. It gives me decimal data error. For instance i gave values as Call pgm(clpgm) Parm(’14′ ‘aaaaa’) But it takes value as F1F44040404040. Hel me out soon. Thanks in advance [...]
Can one use strdbg to trace code through a interactive program that allows update to display screens
Can one use strdbg to trace code through a interactive program that allows update to display screens. I can get the add item and delete item part to work but not the update/change function which craps out with a error message. There seems no reason for this message, but there has to be a reason [...]
Answer Question
| October 16, 2009 8:59 PM
DDS, RPG Date Formatting, RPG debugging, RPG ILE, RPGLE, STRDBG
Can one use strdbg to trace code through a interactive program that allows update to display screens. I can get the add item and delete item part to work but not the update/change function which craps out with a error message. There seems no reason for this message, but there has to be a reason [...]
How do I process Horizontal Subfiles in a particular order?
I have a data entry screen for serial numbers. Each serial number is 10 characters in length. Therefore I created a horizontal subfile using SFLLIN. This puts spaces between the records equally. The result is that I have X number of columns. When I enter the data, the entry is from left to right. But [...]
Answer Question
| October 12, 2009 9:41 PM
DDS, iSeries DDS, RPGLE
I have a data entry screen for serial numbers. Each serial number is 10 characters in length. Therefore I created a horizontal subfile using SFLLIN. This puts spaces between the records equally. The result is that I have X number of columns. When I enter the data, the entry is from left to right. But [...]
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 [...]
Diff. between PF and a sql table
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index…..
Answer Question
| October 9, 2009 8:35 PM
DB2/400, DDS, Physical Files, SQL tables
can anybody say what is the most basic diff. between making pf by writing DDS and sql table by create table command because both can having index…..
sql
How do I compile a SQLTBLSRC on the as400?
Answer Question
| September 25, 2009 5:19 PM
AS/400, DDS, SQL
How do I compile a SQLTBLSRC on the as400?
DDS function keys with point and click functionality
I feel kind of stupid about this, but when did the DDS function keys become point and click action? I have always used “CMD” and not “F#=” and totally missed this functionality. I’m almost afraid of the answer.
Answer Question
| August 27, 2009 3:56 PM
AS/400 command keys, AS/400 development, DDS
I feel kind of stupid about this, but when did the DDS function keys become point and click action? I have always used “CMD” and not “F#=” and totally missed this functionality. I’m almost afraid of the answer.
CPF4207 in DDM TCP/IP connection
I am getting an error CPF4207 while the pgm trying to access a remote DDM file whose type is *IP. If I change the attribute to *SNA the program works. But I need to keep the attribute as type *IP , otherwise some other programs that use the file will fail . Is there any other [...]
Answer Question
| August 12, 2009 6:24 AM
AS/400, DDS
I am getting an error CPF4207 while the pgm trying to access a remote DDM file whose type is *IP. If I change the attribute to *SNA the program works. But I need to keep the attribute as type *IP , otherwise some other programs that use the file will fail . Is there any other [...]
AS400 – DDS
Hello All, I am having one doubt related to display file handling. Let’s say I have one Display file which handles different functionalities like add/update/delete/display of records. For Adding record (Function 10 from main screen) I have a separate window screen. I am doing data validation for this window screen. The problem I am facing [...]
Answer Question
| August 11, 2009 6:51 AM
AS/400 - DDS, DDS
Hello All, I am having one doubt related to display file handling. Let’s say I have one Display file which handles different functionalities like add/update/delete/display of records. For Adding record (Function 10 from main screen) I have a separate window screen. I am doing data validation for this window screen. The problem I am facing [...]
Join Logical files and SQL views
I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical [...]
Answer Question
| July 30, 2009 5:11 PM
DDS, Join Logical file, Logical Files, SQL DDL, SQL View
I hear Join Logical files are not supported in SQL DDL. But you have the SQL view instead. The shop I work for wants to use SQL DDL. But they have numerous interactive programs that use join logical files. If views cannot have keys, how on earth are they going to replace the join logical [...]
DSS Printer file condition/indicator fields
How do set and use the condition/indicator fields in a DSS Printer file (prtf) ?
Answer Question
| June 29, 2009 7:21 PM
AS/400 PRTF, DDS, Printer File, PRTF
How do set and use the condition/indicator fields in a DSS Printer file (prtf) ?
iSeries Navigator V5R3M0
Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ ‘I’) A ICTIPC COMP(EQ ’1′) How can I make this index using “a comparison value for fields” on Iseries Navigator ? Thanks Silvarb
Answer Question
| June 23, 2009 3:39 AM
DDS, iSeries, iSeries Navigator, Logical File, V5R3
Hi all, I have a DDS from a logical file on my system: A R I55120 PFILE(F55120) A K ICBOX A S ICSTAT COMP(EQ ‘I’) A ICTIPC COMP(EQ ’1′) How can I make this index using “a comparison value for fields” on Iseries Navigator ? Thanks Silvarb
Add, change and delete Subfile records
We currently have an order entry program that lists items on an order and you can position to an item via a field in the CTL area. My question is I need to be able to add items to an order by keying in items, qty, etc from the bottom of the screen. The order [...]
Answer Question
| June 10, 2009 9:27 PM
DDS, RPG, RPGLE, Subfile
We currently have an order entry program that lists items on an order and you can position to an item via a field in the CTL area. My question is I need to be able to add items to an order by keying in items, qty, etc from the bottom of the screen. The order [...]
How do I use SDA without having too much knowledge using DDS?
I wrote a menu a while ago after going to a class and getting a cheat sheet for SDA. I have very little DDS experience but was able successfully write the menu. Is there any helpful information on SDA that helps design screens without knowing DDS?
Answer Question
| May 30, 2009 3:43 PM
DDS, QuickRef, SDA
I wrote a menu a while ago after going to a class and getting a cheat sheet for SDA. I have very little DDS experience but was able successfully write the menu. Is there any helpful information on SDA that helps design screens without knowing DDS?
How to display page 1 of n
I’m using AS/400 DDS printer file to print PO. It is using OVERLAYS. How can I print Page 1 of 2, and page 2 of 2.
Answer Question
| October 25, 2011 7:59 PM
AS/400 printing, DDS
I’m using AS/400 DDS printer file to print PO. It is using OVERLAYS. How can I print Page 1 of 2, and page 2 of 2.
comments in dds source
hi please tell me how to comment a group of lines of code at a time in the SEU.thanks
Answer Question
| May 6, 2009 12:06 PM
AS/400, DDS, DDS Source, SEU
hi please tell me how to comment a group of lines of code at a time in the SEU.thanks
spacing between lines in DDS
How can I reduce the spacing between lines in a report. I’m printing Terms and condition and using QFNTCPL/C0D0GT20 font but the spacing in too large.
Answer Question
| May 5, 2009 6:35 PM
AS/400 Printer File, AS/400 printing, DDS
How can I reduce the spacing between lines in a report. I’m printing Terms and condition and using QFNTCPL/C0D0GT20 font but the spacing in too large.





