Example: HELP COLUMN for a Table - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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