DDS

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.  Software/Hardware used: as400

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...

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...

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....

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 add on for excel 2007? 2. My...

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.....

sql

How do I compile a SQLTBLSRC on the as400? Software/Hardware used: AS400 I series

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. 

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 way to solve the...

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...

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 files...

DSS Printer file condition/indicator fields

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...

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 header info needs to be on top of the...

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?

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.

comments in dds source

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.

printing a multiple page document along with a form(PO)

Could you shed some light on how could I print a text document using DDS. Overlay does not work, and I do not want to type 2 pages on DDS, besides it should be on aseparate page looks like a standard text document and should come as one print along with my form(PO) Thanks

DDS with temporary name for Physical file

Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !