KanjiEBCDICユーザーが、4つの文字データ型を使用するテーブルを作成します。
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);
このHELP COLUMNリクエストは、すべての列の情報を表示します。
HELP COLUMN table_1.*;
SIDETITLESオプションとFOLDLINEオプションを使用してフォーマットされた、省略形のBTEQ出力を次に示します。
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 |
? |