Nonstop Database, HiRDB Version 9 System Operation Guide

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

13.6.5 Example 4: Adding a column to a table with the FIX attribute (defining a reserved column)

This example adds a column (C4) to a table with the FIX attribute (TABLE01) by defining a reserved column.

[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 CHAR(3) INTO YOBI;

In this case, the null character (0x00) for the definition length (3 bytes) is stored in column C4.

[Contents][Back][Next]

[Trademarks]

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