Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

13.6.4 Example 3: Adding an abstract data type column

A column (C4) of the SGMLTEXT type is added to a table (TABLE01). The data for column C4 is stored in user LOB RDAREAs (ULOB01 and ULOB02).

[Figure]

Organization of this subsection
(1) Use ALTER TABLE to add column C4

(1) Use ALTER TABLE to add column C4

ALTER TABLE TABLE01 ADD C4 SGMLTEXT
    ALLOCATE(SGMLTEXT IN ((ULOB1),(ULOB2))
    PLUGIN plug-in-option;
 
ALTER TABLE TABLE01 ADD C4 SGMLTEXT
    ALLOCATE(SGMLTEXT IN ((ULOB1),(ULOB2)))
    PLUGIN plug-in-option;

In this case, the null value is stored in column C4.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2015, Hitachi, Ltd.