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
 ──────────────────────────────────────────────────────────────────────────────
 FM/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.

Related tasks

Related references