Here is the table definition of MyTable for this example, where the JSON column c is defined with the AUTO COLUMN option.
CREATE TABLE TEST.MyTable ( a INTEGER, b JSON(16776192) INLINE LENGTH 4096 CHARACTER SET LATIN, c JSON(16776192) INLINE LENGTH 4096 CHARACTER SET LATIN AUTO COLUMN) PRIMARY INDEX ( a );
This statement displays information for column c of the table MyTable.
HELP COLUMN MyTable.c;
Following is the abbreviated HELP COLUMN output for selected attributes.
| Column Name | c |
|---|---|
| Type | JN |
| Nullable | Y |
| Format | X(64000) |
| Max Length | 16,776,192 |
| Table/View? | T |
| Storage Format | TEXT |
| Inline Length | 4,096 |
| Transform Length | 16,776,192 |
| Auto Column | Y |
If the AUTO COLUMN option is not set, the value is NULL, or question mark (?) in BTEQ output.