By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,779 Members | 1,101 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,779 IT Pros & Developers. It's quick & easy.

DDL for Creating the Auxilliary table associated with a CLOB column

P: n/a
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)

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.