DDL for Creating the Auxilliary table associated with a CLOB column

[alex.mcshane]

Hi - I would be grateful for guidance on the following.

The following concerns the DDL for Creating an Auxilliary Table that is
associated with the CLOB column of a 'base' Table.
(I have just recently gained exposure to DB2 UDB for Windows, my
experience lies with DB2 for OS/390.)

Within OS/390, the DDL for defining the AUXilliary Table is listed
below. However, the syntax is not accepted by UDB for Windows.
I have obviously tried several variations but have had no success.

It would be a great help if anyone could provide the Windows DDL.

OS/390 DDL: -

CREATE AUXILIARY TABLE ND00UNIT.AUX_NEW_bUSINESS (Table name example)
IN ND00UNIT.TSNWBSLO (Tablespace name)
STORES ND00UNIT.NEW_BUSINESS (The associated `base` table that contains
CLOB)
COLUMN CLOB_DATA (Name of CLOB column)

[Serge Rielau]

al**********@btinternet.com wrote:

Hi - I would be grateful for guidance on the following.

The following concerns the DDL for Creating an Auxilliary Table that is
associated with the CLOB column of a 'base' Table.
(I have just recently gained exposure to DB2 UDB for Windows, my
experience lies with DB2 for OS/390.)

Within OS/390, the DDL for defining the AUXilliary Table is listed
below. However, the syntax is not accepted by UDB for Windows.
I have obviously tried several variations but have had no success.

It would be a great help if anyone could provide the Windows DDL.

OS/390 DDL: -

CREATE AUXILIARY TABLE ND00UNIT.AUX_NEW_bUSINESS (Table name example)
IN ND00UNIT.TSNWBSLO (Tablespace name)
STORES ND00UNIT.NEW_BUSINESS (The associated `base` table that contains
CLOB)
COLUMN CLOB_DATA (Name of CLOB column)

DB2 for LUW doesn't have anything like an auxillary table to store LOBs
(there alo is no ROWID column required to store the LOB).
If you want to control the placements of LOBs you can define a separate
tablespace and associate it with the table during teh CREATE TABLE command.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[alex.mcshane]

Thanks Serge for a very swift reply.
(I need to complete this task asap).

I was starting to think along those lines: that is, there is no
mandatory technical requirement to physically store LOB columns on a
seperate tablespace.

Much appreciated