The system supports several methods for creating a database file:
You can create a database file by using Interactive Data Definition Utility (IDDU). If you are using IDDU to describe your database files, you might also consider using it to create your files.
You can create a database file by using Structured Query Language (SQL) statements. SQL is the IBM relational database language, and can be used on AS/400 to interactively describe and create database files.
You can also create a database file by using CL. The CL database file create commands are: Create Physical File (CRTPF), Create Logical File (CRTLF), and Create Source Physical File (CRTSRCPF).
Because additional system functions are available with CL, this guide focuses on creating files by using CL.