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