The following figure shows the Columns panel.Figure 1. Columns panel (ADB21C)
ADB21C in --------------------- DDB2X Columns ---------------------- Row 1 of 1
Command ===> Scroll ===> PAGE
Line commands:
T - Tables ST - Specific table X - Indexes SX - Specific indexes A - Auth
GR - Grant H - Homonyms I - Interpret UR - Update runstats COM - Comment
LAB - Label DI - Dist. stats PST - Part. stats CM - Mask CCM - Create mask
? - Show all line commands
Sel Schema Name Column Name Col No Col Type Length N D F
* * * * * * * * *
--- -------- ------------------ ------------------ ------ -------- ------ - - -
DSN8 DSN8ES1_RS_TBL RS_SEQUENCE 1 INTEGER 4 N N N
DSN8 DSN8ES1_RS_TBL RS_EMPNO 2 CHAR 6 N N N
DSN8 DSN8ES1_RS_TBL RS_FIRSTNME 3 CHAR 12 N N N
DSN8 DSN8ES1_RS_TBL RS_LASTNAME 4 CHAR 15 N N N
DSN8 DSN8ES1_RS_TBL RS_SALARY 5 DECIMAL 9 N N N
DSN8 DSN8ES1_RS_TBL RS_BONUS 6 DECIMAL 9 N N N
DSN881SA STAFF EMPNUM 1 CHAR 3 N N N
DSN881SA STAFF EMPNAME 2 CHAR 20 Y Y N
DSN881SA STAFF GRADE 3 DECIMAL 4 Y Y N
DSN881SA STAFF CITY 4 CHAR 15 Y Y N
DSN881SA STAFFV1 EMPNUM 1 CHAR 3 N N N
DSN881SA STAFFV1 EMPNAME 2 CHAR 20 Y Y N
DSN881SA STAFFV1 GRADE 3 DECIMAL 4 Y Y N
DSN881SA STAFFV1 CITY 4 CHAR 15 Y Y N
DSN881SA TESTSTUFF TESTNO 1 CHAR 4 Y Y N
DSN881SA TESTSTUFF RESULT 2 CHAR 4 Y Y N
DSN881SA TESTSTUFF TESTTYPE 3 CHAR 3 Y Y N
DSN8810 ACT ACTNO 1 SMALLINT 2 N N N
DSN8810 ACT ACTKWD 2 CHAR 6 N N N
DSN8810 ACT ACTDESC 3 VARCHAR 20 N N N
DSN8810 DEMO_UNICODE LOWER_A_TO_Z 1 CHAR 26 Y Y N
DSN8810 DEMO_UNICODE UPPER_A_TO_Z 2 CHAR 26 Y Y N
DSN8810 DEMO_UNICODE ZERO_TO_NINE 3 CHAR 10 Y Y N
DSN8810 DEMO_UNICODE X00_TO_XFF 4 VARCHAR 256 Y Y N
DSN8810 DEPT DEPTNO 1 CHAR 3 N N N
DSN8810 DEPT DEPTNAME 2 VARCHAR 36 N N N
DSN8810 DEPT MGRNO 3 CHAR 6 Y Y N
DSN8810 DEPT ADMRDEPT 4 CHAR 3 N N N
DSN8810 DEPT LOCATION 5 CHAR 16 Y Y N
DSN8810 EACT ACTNO 1 SMALLINT 2 N N N
The fields on this panel are:
Sel
Input field where you enter one of the line commands listed on the panel.
Schema
Schema of the table or view that contains the column.
Name
Name of the table or view that contains the column.
Column Name
Name of the column.
Col No
Numerical position of the column in the table or view.
Col Type
Type of column, which is one of the following data types:
INTEGER
Large integer.
SMALLINT
Small integer.
FLOAT
Floating-point.
CHAR
Fixed-length character string.
VARCHAR
Varying-length character string.
LONGVAR
Varying-length character string.
DECIMAL
Decimal.
GRAPHIC
Fixed-length graphic string.
VARG
Varying-length graphic string.
LONGVARG
Varying-length graphic string.
DATE
Date.
TIME
Time.
TIMESTMP
Time stamp.
BLOB
Binary large object.
CLOB
Character large object.
DBCLOB
Double-byte character large object.
ROWID
Row ID data type.
DISTINCT
Distinct type.
Length
Length attribute of the column or, in the case of a decimal column, its precision. The number
does not include internal prefixes to record actual length and null state (where these are
applicable).
N
This field indicates whether the column can contain null values. This field contains one of the
following values:
Y
Yes.
N
No.
D
Default value for the column. This field contains one of the following values:
N
None.
Y
Yes.
B
Yes.
1–6
User-defined defaults.
S
SQLID.
U
USER.
A
Generated always.
D
Generated by default.
I
As identity and generated always.
J
As identity and generated as default.
F
This field indicates whether the column has a field procedure. This field contains one of the
following values: