Database objects creation tasks

Database objects creation tasks

This table shows how you can create various database objects in iSeries™ Navigator.

Table 1. Creating database objects

Tasks Objects whose context menu supports the task Available from object context menus in the Web interface iSeries Navigator utilities

Create a schema The Schemas folder Yes N/A
Create an alias

A schema object

The All Objects folder

The Alias folder

A table object

A table partition

A view object
Yes A database navigator map
Create a constraint on a table N/A No, but the task is available from the Table Definition window in the Web interface.

The Table Definition window

A database navigator map

Create a distinct type

A schema object

The All Objects folder

The Distinct Types folder
Yes N/A
Create a function

A schema object

The All Objects folder

The Functions folder

A function object
Yes N/A
Create an index

A schema object

The All Objects folder

The Indexes folder

A table object

A table partition
Yes

A database navigator map

The Index Advisor

An SQL performance monitor analysis result

Visual Explain

Create a journal

A schema object

The All Objects folder

The Journals folder
Yes A database navigator map
Create a procedure

A schema object

The All Objects folder

The Procedures folder
Yes N/A
Create a sequence

A schema object

The All Objects folder

The Sequences folder
Yes N/A
Create an SQL package A database folder No The Run SQL Scripts window ¹
Create a table

A schema object

The All Objects folder

The Tables folder
Yes A database navigator map
Create a trigger

A schema object

The All Objects folder

The Triggers folder

A table object

A view object
Yes A database navigator map
Create a view

A schema object

The All Objects folder

The views folder
Yes A database navigator map

¹ To create an SQL package from the Run SQL Scripts window, select Connection > JDBC setup from the menu, and then select the Enable extended dynamic (package) support check box on the Package tab.

Parent topic:
iSeries Navigator database tasks

Related tasks

Creating a table and defining a column
Creating and using a view
Creating a library
Adding triggers using iSeries Navigator

Related reference

iSeries Navigator URL parameters and available Web tasks

Tasks	Objects whose context menu supports the task	Available from object context menus in the Web interface	iSeries Navigator utilities
Create a schema	The Schemas folder	Yes	N/A
Create an alias	A schema object The All Objects folder The Alias folder A table object A table partition A view object	Yes	A database navigator map
Create a constraint on a table	N/A	No, but the task is available from the Table Definition window in the Web interface.	The Table Definition window A database navigator map
Create a distinct type	A schema object The All Objects folder The Distinct Types folder	Yes	N/A
Create a function	A schema object The All Objects folder The Functions folder A function object	Yes	N/A
Create an index	A schema object The All Objects folder The Indexes folder A table object A table partition	Yes	A database navigator map The Index Advisor An SQL performance monitor analysis result Visual Explain
Create a journal	A schema object The All Objects folder The Journals folder	Yes	A database navigator map
Create a procedure	A schema object The All Objects folder The Procedures folder	Yes	N/A
Create a sequence	A schema object The All Objects folder The Sequences folder	Yes	N/A
Create an SQL package	A database folder	No	The Run SQL Scripts window ¹
Create a table	A schema object The All Objects folder The Tables folder	Yes	A database navigator map
Create a trigger	A schema object The All Objects folder The Triggers folder A table object A view object	Yes	A database navigator map
Create a view	A schema object The All Objects folder The views folder	Yes	A database navigator map
¹ To create an SQL package from the Run SQL Scripts window, select Connection > JDBC setup from the menu, and then select the Enable extended dynamic (package) support check box on the Package tab.