Creating database objects

The first step in developing your database is to create the objects that hold your data. You can create tables, views, and indexes with SQL. You can also create physical and logical files using the traditional system interface.

You can create database objects using System i® Navigator, SQL, or the traditional system interface. The following table shows the available options for each task. Click the appropriate X for more information about performing the task.

The System i Navigator tasks are documented in the online help.

Task	System i Navigator	SQL	Traditional system interface
Creating a map of database object relationships	X
Creating an alias	X	X	X
Creating an index or access path	X	X	X
Creating an object using Run SQL Scripts	X
Creating a package	X	X	X
Creating a schema (library)	X	X
Creating a sequence	X	X
Creating a stored procedure	X	X
Creating a table (physical file)	X	X	X
Creating a user-defined function	X	X
Creating a user-defined type	X	X
Creating a view (logical file)	X	X	X
Generating SQL for database objects	X