Creating a distinct type for completed job application forms

Suppose you would like to keep incoming job application forms in a Db2® table and be able to use functions to extract the information from these forms. You can define a distinct type to represent the forms in tables and as parameters to functions.

Before you begin

For the list of privileges required to define distinct types, see the CREATE DISTINCT TYPE statement.

Procedure

To define a distinct type representing the completed job application forms, issue the following statement:

     CREATE DISTINCT TYPE PERSONNEL.APPLICATION_FORM AS CLOB(32K)

Because Db2 does not support comparisons on CLOBs, you cannot specify the WITH COMPARISONS clause. The PERSONNEL schema is specified in the preceding statement because the schema intended to contain all the distinct types and UDFs dealing with application forms.