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 file interface.
You can create objects using iSeries™ Navigator, SQL, or the traditional file interface. The following table shows the available options for each task. Click the appropriate X for more information about performing the task.
The iSeries Navigator tasks are documented in the online help. For more information about accessing iSeries Navigator objects and using online help, see iSeries Navigator database tasks.
| Task | iSeries Navigator | SQL | Traditional file 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 |