In the Oracle DataServer Dictionary, the default behavior is for Oracle DATE data types in the foreign database to be pulled as a DATE field with a surrogate INT field for the time component. You can override this default treatment of the Oracle DATE data type during schema pull by instead mapping to the DATETIME data type in your Oracle schema image. To override, check the box marked Default to OE Datetime in the Pre-selection Criteria dialog box of the schema pull Data Administration tool. For this option, only new tables, not existing tables, in the schema holder are affected by the Default to OE Datetime option.



To change tables that contain the previous default mapping from an Oracle DATE to an OpenEdge DATE with surrogate INT field for the time component:
  1. Manually change the dictionary type from DATE to DATETIME. Delete the table or definition in your schema holder and re-pull the table with the Default to OE Datetime option checked.
  2. Go back to the places in your application where the DATE and INT fields were referenced and replace this code with algorithms that utilize the DATETIME data type in place of the old references.
Note: You must not specify an entry that consists exclusively of wild cards for each of the three entry fields in the dialog box. An entry that consists exclusively of wild cards might degrade the performance of the database when you perform a schema pull. (It will include system catalog files from the data source not typically included in user databases.)