A KanjiEBCDIC user creates a table using four character data types (kanji_user.table_1 is on the Block File System):
CREATE TABLE kanji_user.table_1,
NO FALLBACK,
NO BEFORE JOURNAL,
NO AFTER JOURNAL (
clatin CHARACTER(5) CHARACTER SET LATIN,
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 |
? |
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 |
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 |
? |
Column Name |
csjis |
Type |
CF |
Format |
X(5) |
Max Length |
5 |
Title |
? |
Column Constraint |
? |
Char Type |
3 |
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 |
Security Constraint |
? |
Column Name |
cunicode |
Type |
CF |
Format |
X(5) |
Max Length |
10 |
Title |
? |
Column Constraint |
? |
Char Type |
2 |
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 |
Security Constraint |
N |