Creating and modifying Db2 objects from application
programs
Your application program can create and manipulate Db2 objects, such as tables, views,
triggers, distinct types, user-defined functions, and stored procedures.
You must have the appropriate authorizations to create such objects.
Creating tables from application programs Db2 subsystem.Providing a unique key for a table Fixing tables with incomplete definitions RENAME TABLE in a table maintenance scenario Dropping tables Defining a view view is a named specification of a result table. Use views to control which users have access to certain data or to simplify writing SQL statements.Dropping a view Creating a common table expression Db2 does not need to access the catalog for the view, which saves you additional overhead.Creating a trigger trigger is a set of SQL statements that execute when a certain event occurs in a table or view. Use triggers to control changes in Db2 databases. Triggers are more powerful than constraints because they can monitor a broader range of changes and perform a broader range of actions. Sequence objects sequence is a user-defined object that generates a sequence of numeric values according to the specification with which the sequence was created. Sequences, unlike identity columns, are not associated with tables. Applications refer to a sequence object to get its current or next value. Db2 object relational extensions Db2 , you can incorporate object-oriented concepts and methodologies into your relational database by extending Db2 with richer sets of data types and functions.Creating a distinct type Db2 to handle certain data differently than other data of the same data type. For example, even though all currencies can be declared as type DECIMAL, you do not want euros to be compared to Japanese yen.Creating a user-defined function Db2 by adding your own or third party vendor function definitions.Creating stored procedures A stored procedure is executable code that can be called by other programs. The process for creating one depends on the type of procedure.