InfoSphere Optim

 View Only

Optim Extract - Oracle Date Datatype issue

  • 1.  Optim Extract - Oracle Date Datatype issue

    Posted Wed February 09, 2022 02:55 AM
    Issue : Optim extract add 12:00:00 AM timestamp to all DATE datatype columns of Oracle tables.

    Example : Date in source 12-Nov-92 when its extracted optim xf file has following data 11/12/92 12:00:00 AM for further processing.

    Version : IBM Optim version – 11.3.0.8 Oracle version -11.2.0.4.0


     What is the reason for this change of pattern in extract file. Do i have to do any additional configuration in Optim calender as its currently set to US calender. Please suggest if you have encountered and overcome this?

    ------------------------------
    Raj
    ------------------------------

    #InfoSphereOptim
    #Optim