Changing databases that are not DB2 for Linux, UNIX, and Windows databases

You can create, alter, or drop an object and manage database object privileges for several types of databases that are not DB2® for Linux, UNIX, and Windows databases. You can change only one object at a time.

You can create objects by using the Administration Explorer, Object List, or Data Source Explorer. You can alter and drop objects by using the Object List or Data Source Explorer.

When you create or alter a database object, you use the Properties view to set or alter the attributes of the object. From the Properties view, you can then open the Review and Deploy dialog, where you can review and run the generated DDL that creates or alters the object. Similarly, when you drop an object, the Review and Deploy dialog opens, where you can review and run the generated DDL.

Depending on the type of database server, you must initiate the database change by navigating to the object folder or object through the Administration Explorer and Object List, or through the Data Source Explorer. The following table shows the database servers that are supported and the views that you must use to initiate a change. An X indicates the views that can be used.
Table 1. Supported database servers and the views that must be used to initiate database object changes
Database Server Administration Explorer and the Object List Data Source Explorer
IBM® DB2 for i - X
IBM DB2 for z/OS® X X
IBM Informix® Dynamic Server - X
Oracle Database - X
Sybase Adaptive Server Enterprise - X

For information about the versions and releases that are supported for these database servers, see techdoc for System requirements for IBM Data Studio


Feedback