You can create and describe a library and a database
file using the traditional system interface.
The system supports several methods for creating and describing
a database file:
- Interactive data definition utility (IDDU)
You can
create a database file by using IDDU, part of the IBM Rational Development Studio
for i licensed
program. If you are using IDDU to describe your database files, you might
also consider using it to create your files.
- Control language (CL), using the source entry utility (SEU)
or the data file utility (DFU) to specify data description specifications
(DDS)
You can 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). After a database
file is created, you can use SEU or DFU to describe data in the file. SEU
and DFU are part of the IBM Rational Development Studio
for i licensed
program. These topics focus on how to create files using these methods.
- Structured Query Language (SQL)
You can create and describe
a database file (table) by using SQL statements. SQL is the IBM® relational
database language. It can be used to interactively describe and create database
files.