DDS Questions


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
asked by:
70 pts.

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
asked by:
10 pts.

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
asked by:
385 pts.

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
asked by:
5 pts.

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
asked by:
385 pts.

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
asked by:
110 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.

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
asked by:
10 pts.

sql
How do I compile a SQLTBLSRC on the as400?

Answer Question   |  September 25, 2009  5:19 PM
AS/400, DDS, SQL
asked by:
10 pts.

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
asked by:
540 pts.

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
asked by:
10 pts.

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
asked by:
130 pts.

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
asked by:
560 pts.

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
asked by:
5 pts.

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
asked by:
540 pts.

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
asked by:
445 pts.

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
asked by:
5 pts.

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
asked by:
230 pts.

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
asked by:
1,150 pts.

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
asked by:
230 pts.