Defining large objects

Defining large objects to DB2 is different than defining other types of data and objects. This section explains the basic steps that you can take to define LOB data to DB2 and to create large objects.

These are the basic steps for defining LOBs and moving the data into DB2:

1.
Define a column of the appropriate LOB type. When you create a table with a LOB column or alter a table to add a LOB column, defining a ROWID column is optional. If you do not define a ROWID column, DB2 defines a hidden ROWID column for you. Define only one ROWID column, even if multiple LOB columns are in the table. The LOB column holds information ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.