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
|
?
|