DB2® UDB for iSeries™ provides both Structured Query Language (SQL) and system methods for altering and managing database objects.
Several methods are available for working with database objects. You can use the iSeries Navigator interface, SQL methods, 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 |
|---|---|---|---|
| Add a column to a table | X | X | X |
| Add or alter an identity column | X | X | |
| Alter a sequence | X | X | |
| Change a table (file) definition | X | X | X |
| Change the schema (library) list | X | X | |
| Copy a table (file) | X | X | |
| Copy column definitions | X | ||
| Display contents of tables and views (files) | X | X | X |
| Display locked rows (records) | X | X | |
| Display table (file) attributes (catalog) | X | X | X |
| Drop database objects | X | X | X |
| Edit table (file) data | X | X | X |
| Move a table (file) | X | X | |
| Reorganize a table (physical file) | X | X |