Example: Application forms

 

Suppose that define a table to keep the forms that are filled out by applicants.

Create the table as follows:

     CREATE TABLE APPLICATIONS 
       (ID                INTEGER, 
        NAME              VARCHAR (30), 
        APPLICATION_DATE  DATE, 
        FORM              PERSONAL.APPLICATION_FORM)

You have fully qualified the UDT name because its qualifier is not the same as your authorization ID and you have not changed the default function path. Remember that whenever type and function names are not fully qualified, DB2^® searches through the schemas listed in the current function path and looks for a type or function name matching the given unqualified name.

 

Parent topic:

Defining tables with UDTs