Creating a physical file

 

You can create a physical file using data description specifications (DDS). You need to create a library and a source file before you create a physical file.

To create a physical file, follow these steps:

1. If you are using DDS, enter DDS for the physical file into a source file. You can do this using the source entry utility (SEU). SEU is part of IBM^® WebSphere^® Development Studio for iSeries™.

2. Create the physical file. You can use the Create Physical File (CRTPF) command or the Create Source Physical File (CRTSRCPF) command.

The following command creates a one-member file using DDS and places it in a library called DSTPRODLB.

CRTPF FILE(DSTPRODLB/ORDHDRP)
      TEXT('Order header physical file')

As shown, this command uses defaults. For the SRCFILE and SRCMBR parameters, the system uses DDS in the source file called QDDSSRC and the member named ORDHDRP (the same as the file name). The file ORDHDRP with one member of the same name is placed in the library DSTPRODLB.

Tables are similar to physical files. You can create tables using iSeries Navigator or using the CREATE TABLE SQL statement.

 

Parent topic:

Setting up physical files

 

Related concepts

Creating a library
Creating a source file
Working with source files
Describing database files
Getting started with iSeries Navigator

 

Related reference

Create Physical File (CRTPF) command
Create Source Physical File (CRTSRCPF) command
CREATE TABLE