Examples: Using UDTs, UDFs, and LOBs

 

These examples show how to use user-defined types (UDTs), user-defined functions (UDFs), and large objects (LOBs) together in complex applications.

• Example: Defining the UDT and UDFs
  Suppose that you want to keep the electronic mail (e-mail) that is sent to your company in a table.

• Example: Using the LOB function to populate the database
  Suppose that you populate your table by transferring your e-mail that is maintained in files into DB2^® UDB for iSeries™.

• Example: Using UDFs to query instances of UDTs
  Suppose that know how much e-mail was sent by a specific customer regarding customer orders and you have the e-mail addresses of your customers in the customers table.

• Example: Using LOB locators to manipulate UDT instances
  Suppose that you want to obtain information about specific e-mail without having to transfer the entire e-mail into a host variable in your application program.

 

Parent topic:

Processing special data types