Nonstop Database, HiRDB Version 9 System Operation Guide

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

13.6.3 Example 2: Adding a LOB column

This example adds a BLOB type column (C4) 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 BLOB(1M) IN ((ULOB1),(ULOB2));

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

[Contents][Back][Next]

[Trademarks]

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