MS-Access provides a single Date/Time type for handling dates and times. DB2 provides DATE, TIME, and TIMESTAMP types. Access fields that contain only dates should be assigned the DB2 DATE type. Access fields that contain both dates and times must be assigned the DB2 TIMESTAMP type, and fields containing only times should be assigned the DB2 TIME type.
Scriptoria provides a facility for assigning DB2 date types based on the data stored in Access date fields. The following form shows the results (after pressing the Get Date Fields button) from the Northwind sample database. It is displayed after clicking the Date Assignments button from the Assign DB2 Data Types form.
Table Name: Access table.
Date Field: Name of the Date/Time field.
Assign: When this box is checked, the corresponding DB2 date type will be assigned to the associated Access field.
DB2 Date Type: The DB2 date type to assign to the associated Access field.
This button is not shown on the form above. The Get Date Fields caption is replaced by the Assign Types caption and the list of Access fields like the one shown above is displayed after the date analysis is performed. This operation may take a while to complete if your tables are voluminous.
Press this button to assign the selected fields with their corresponding DB2 date type.