Database Administrator
This topic provides an overview of the process of creating database files, libraries, source files, and physical files.
Create and Describe Database Files
The system supports several methods for describing and creating a database file:
You can create a database file by using IDDU, part of the WebSphere Development Studio for iSeries® licensed program. If you are using IDDU to describe your database files, you might also consider using it to create your files.
More Interactive data
Control language (CL), using source entry utility (SEU) or data file utility (DFU) to specify data description specifications (DDS).
Structured Query Language
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 IBM WebSphere Development Studio for iSeries licensed program. These topics focus on how to create files using these methods.
definition utility (IDDU)
You can create and describe a database file (table) by using SQL statements. SQL is the IBM relational database language, and can be used on iSeries to interactively describe and create database files.
iSeries Navigator
You can also create a database file (table) using iSeries Navigator.
View Parent topic:
View Related Topics:
Ideas by Creativity Pool
A free database with unused ideas and possible inventions. Add your own, or bring an existing idea to life.
KnowMap-The Knowledge Management, Auditing and Mapping Magazine
deBonoConsulting.com
A division of Resources Unlimited, is dedicated to Dr. Edward de Bono's critical and creative thinking skills, Six Thinking Hats, Lateral Thinking, Focus on Facilitation, and DATT (Direct Attention Thinking Tools).
