Column Attributes panel (DATE)

The Column Attributes (DATE) panel describes the formatting and data create attributes for a DATE column.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                 Column Attributes

 Fixed Attributes:
          Column name  BIRTHDATE
                 Type  DATE
               Format  dd.mm.yyyy

 Use Attributes:
              Heading                      
         Output width       

 Create Attributes:
           Date value                                                
                             (Use = for date now, * for runtime date)
            Increment  0         




 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F7=Backward  F8=Forward
  F9=Swap     F10=Actions  F12=Cancel
Column name
The name of the column.
Type
The Db2® data type of the column.
Format
The format in which the date 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.
Date value
The initial value a column is to contain. Valid values are:
start date
A date in a valid Db2® or local format.
* (asterisk)
The date the data is created. Not valid if the Db2® installation date format is LOCAL.
=
The current date. Not valid if the Db2® installation date format is LOCAL.
Increment
A integer that represents the number of days to add to the date each cycle.

The default increment value is 0.

Parent panels

Child panels

None.

Related tasks