Column Attributes panel (TIMESTAMP)
The Column Attributes (TIMESTAMP) panel describes the formatting and data create attributes for a TIMESTAMP column.
Panel and field definitions
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────
ZDT/Db2 (DFG2) Column Attributes
Fixed Attributes:
Column name TSTAMP
Type TIMESTAMP (3) WITH TIME ZONE
Format CCYY-MM-DD-HH.MM.SS.NNNsHH:MM
Use Attributes:
Heading
Output width
Create Attributes:
Timestamp value
(Use = for timestamp now, * for runtime timestamp)
Command ===>
F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward
F9=Swap F10=Actions F12=Cancel
The example shows a column defined
as TIMESTAMP(3) WITH TIME ZONE
. The Type value and
the Format are different for columns with different TIMESTAMP data
types.
- Column name
- The name of the column.
- Type
- The Db2® data type of the column.
- Format
- The format in which the timestamp is displayed or printed.
- Heading
- The alternative column heading.
- Output width
- The number of character positions used by view, edit, and print functions to show the column in TABL display or print format.
- Timestamp value
- The initial value a column is to contain. Valid values are:
- start timestamp
- A timestamp in the Db2® timestamp format.
- * (asterisk)
- The date and time the data is created.
- =
- The current date and time.
Parent panels
Child panels
None.