Defining Database Files in IBM i Using DDS (Magic xpa 3.x)

To define database files in IBM i using DDS:

1. In the OS/400 Library, which is the IBM i database, use the CRTLIB MYDATABASE command.

2. Create the physical source file using the
   CRTSRCPF MYDATABASE/QDDSSRC command.

3. To define database files, use the IBM i STRPDM command, and select Option 3, Work with Members.

4. Specify the DDS Source file name and the Library, and press ENTER.

5. To define a new physical file, press F6, specify Member Name and Type = PF. Enter the DDS source as shown below, and compile using Option 14.
   
   

Related Topics

DDS and SQL Terminology Summary