Automic Workload Automation

Expand all | Collapse all

DB statement - Static calendar dates

  • 1.  DB statement - Static calendar dates

    Posted 11-21-2018 04:47 AM

    Hello,

     

    i'm trying to write a DB statement to see the defined dates within all static calendar keywords as it seems some of the .xml exports cannot be reviewed via excel. 

     

    so far this is the statement the statement that i came up with:

     

    SELECT OH_name, OKB_Name,OKB_CType,OKD_Year, OKD_Content FROM OH LEFT JOIN OKB
    ON OH_Idnr = OKB_OH_Idnr
    LEFT JOIN OKD
    ON OKB_OH_Idnr = OKD_OH_Idnr
    WHERE OH_OType like 'CALE'
    AND OKB_CType like 'S'
    AND OH_Client = 0
    AND OH_DeleteFlag = 0

     

    result:

    CALE.BASE ZSC_NN_PC_SAL_IDD4254F S 2021 111111111111111111111111111111111111111111111111111111111110001111111111111111111111111111111111111111111111111111111111111011111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111111111111111111111111111111101111111111111111111111111111111

     

    It seems that the dates are defined in bytes. Is there any way to get the dates in human readable format?



  • 2.  Re: DB statement - Static calendar dates

    Posted 11-21-2018 11:42 AM

    As is posted is in the CA Automic Community and there is no tags/categories selected but from the post content it appear to be regarding the Automic Workload Automation / Automation Engine product line. I have move this to the CA Automic Workload Automation section to better reach the product user audience.