A KanjiEBCDIC user creates a table using four character data types:
CREATE TABLE kanji_user.table_1, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL ( clatin CHARACTER(5) CHARACTER SET LATIN, cgraphic CHARACTER(5) CHARACTER SET GRAPHIC, csjis CHARACTER(5) CHARACTER SET KANJISJIS, cunicode CHARACTER(5) CHARACTER SET UNICODE) PRIMARY INDEX (clatin);
This HELP COLUMN request displays information for all columns:
HELP COLUMN table_1.*;
Following is the abbreviated BTEQ output formatted using the SIDETITLES and FOLDLINE options.
| Column Name | clatin |
| Type | CF |
| Format | X(5) |
| Max Length | 5 |
| Title | ? |
| Column Constraint | ? |
| Char Type | 1 |
| IdCol Type | ? |
| UDT Name | ? |
| Temporal Column | ? |
| Current ValidTime Unique | ? |
| Sequenced ValidTime Unique | ? |
| Nonsequenced ValidTime Unique | ? |
| Current TransactionTime Unique | ? |
| Partitioning Column | N |
| Column Partition Number | 0 |
| Column Partition Format | NA |
| Column Partition AC | NA |
| Security Constraint | N |
| Derived_UDT | ? |
| Derived_UDTFieldID | ? |
| Column Name | cgraphic |
| Type | CF |
| Format | X(5) |
| Max Length | 10 |
| Title | ? |
| Column Constraint | ? |
| Char Type | 4 |
| IdCol Type | ? |
| Temporal Column | N |
| Current ValidTime Unique | ? |
| Sequenced ValidTime Unique | ? |
| NonSequenced ValidTime Unique | ? |
| Current TransactionTime Unique | ? |
| Partitioning Column | N |
| Column Partition Number | 0 |
| Column Partition Format | NA |
| Column Partition AC | NA |
| ConstraintID | ? |
| Derived_UDT | ? |
| Derived_UDTFieldID | ? |
| Column Name | csjis |
| Type | CF |
| Format | X(5) |
| Max Length | 5 |
| Title | ? |
| Column Constraint | ? |
| Char Type | 3 |
| IdCol Type | ? |
| UDT Name | ? |
| Temporal Column | N |
| Current ValidTime Unique | ? |
| Sequenced ValidTime Unique | ? |
| NonSequenced ValidTime Unique | ? |
| Current TransactionTime Unique | ? |
| Partitioning Column | N |
| Column Partition Number | 0 |
| Column Partition Format | NA |
| Column Partition AC | NA |
| Security Constraint | ? |
| Derived_UDT | ? |
| Derived_UDTFieldID | ? |
| Column Name | cunicode |
| Type | CF |
| Format | X(5) |
| Max Length | 10 |
| Title | ? |
| Column Constraint | ? |
| Char Type | 2 |
| IdCol Type | ? |
| UDT Name | ? |
| Temporal Column | N |
| Current ValidTime Unique | ? |
| Sequenced ValidTime Unique | ? |
| NonSequenced ValidTime Unique | ? |
| Current TransactionTime Unique | ? |
| Partitioning Column | N |
| Column Partition Number | 0 |
| Column Partition Format | NA |
| Column Partition AC | NA |
| Security Constraint | N |
| Derived_UDT | ? |
| Derived_UDTFieldID | ? |