Resolving The Problem

Creating a DDS and Physical File

Client Access or iSeries Access data transfer is designed to access data stored in the operating system relational database (DB2/400). It can access physical files (tables) or logical files (views). The most common methods of creating these files are using SQL (Create Table or Create View), by compiling a source file containing Data Description Specifications (DDS), or by using the iSeries Access data transfer wizard which will create a database table on the iSeries based on the structure of a PC file (refer to Rochester Support Center knowledgebase document New, Data Transfer File Creation Wizard Walk-Through: for additional information on this feature).

In the following example, the IBM Programming Development Manager (PDM) and the Source Entry Utility (SEU) are used to enter DDS statements and then compile this source into a physical file.

Sources of documentation

The following references provide further information on the topics discussed in this document:

Creating the DDS

First, define the Data Description Specifications (DDS) for the database to be created.

From an operating system command line, start Programming Development Manager (PDM) by running the STRPDM command.



From this screen, select Option 3 to work with members.

From the Specify Members to Work With screen, select the DDS file to work with. By default this is QDDSSRC in QGPL (or *LIBL).



The Work with Members Using PDM screen is shown.



Press F6 to create a new member.



Type the name for the DDS member in the Source Member field. Source Type is PF when creating a DDS. A description can also be added.

The Edit screen is shown below. You are now using Source Editor Utility (SEU) to edit your member.

The first line of the DDS must include R and a file name as shown below.

Note: SEU is positional. Therefore, R must be in the T column, and the filename (in this case NEWFILE) must be in the Name column.



Press the Enter key and the screen changes slightly. Put the cursor on the first 0 of the line number 0001.00, type I, and hit Enter. You are given a new line to enter data on. Place the cursor on the new line, and press F4.



Type the required parameters to define the fields. In this case, we are interested in the Name, Length, Data Type, and Decimal Positions fields.

Here we show the DDS after definitions for several fields have been entered.



In this case, we have entered four fields and are inputting a fifth: Note: There are many more data types than this. Press the Help key (F1) with the cursor on the Data Type field shows the available data types.

Once you are finished entering your DDS data, press F3 to Exit, and select Y to Change/create member.



A DDS file has been successfully created. You must now create an actual database physical file to hold the data.

Compiling the DDS with CRTPF

From an operating system command line, type CRTPF, and press F4 to prompt.



In this example, we will create a file named TESTFILE in library MYLIB.

We have specified that the DDS source file is QDDSSRC and the member to reference in that file is NEWFILE, which we have just finished creating in PDM.

Tips: Once this has been completed, you now have a file ready to accept data from an application, a CL program, or data entry from the Data File Utility (IDDU). To run the DFU application, type STRDFU on the operating system command line. In addition, the Initialize Physical File Member (INZPFM) command can be used to append one or more dummy records to the file. INZPFM initializes all character fields to blanks and all numeric fields to zeros.