Data type abbreviations that are used in the Db2 Table Editor ISPF interface
To save space in Db2 Table Editor, abbreviations are used to represent data types.
The following table (Data types and their corresponding abbreviations as used in Db2 Table Editor) contains the abbreviations and the long names for all of the data types used in Db2 Table Editor.
| Data Type | Abbreviation |
|---|---|
| INTEGER | INT |
| SMALLINT | SMA |
| CHAR | CHR |
| DECIMAL | DEC |
| FLOAT | FLT |
| VARCHAR | VCH |
| LONGVAR | LVC |
| GRAPHIC | GRA |
| VARGRAPHIC | VGR |
| LONGVARG | LVG |
| DATE | DTE |
| TIME | TME |
| TIMESTAMP | TST |
| BLOB | BLB |
| CLOB | CLB |
| DBCLOB | DBC |
| ROWID | ROW |
| DISTINCT | DST |
| BIGINT | BIG |
| TIMESTZ | TSZ |
| DECFLOAT | DFL |