IBM Security Z Security

 View Only

  • 1.  LAST_DATETIME field in TYPE=ACCESS

    Posted Thu October 13, 2022 09:22 AM
    I know I can do a date selection using LAST_DATETIME similar to this "
    But can I also select on the time as well?    It seems looking at IN.D the field has the time value in it, but not sure on how to  to construct the select.
    For example 10/13/2022 at 06:00 to 10/13/2022 06:15


    ------------------------------
    Linnea Sullivan
    ------------------------------


  • 2.  RE: LAST_DATETIME field in TYPE=ACCESS

    Posted Thu October 13, 2022 10:53 AM
    Hi Linnea,

    I believe you can use the output from fields in the DATETIME format right back on the SELECT, but that you need to quote them because of the embedded blank.

    Like:
    n type=smf outlim=10                                       
s datetime='6Mar2000 07:32:12.34':'6Mar2000 07:32:13.53'   
sortlist recno datetime record                             ​

    Regards,

    ------------------------------
    Jeroen Tiggelman
    Software Development and Level 3 Support Manager IBM Security zSecure Suite
    IBM
    Delft
    ------------------------------

    Original Message


  • 3.  RE: LAST_DATETIME field in TYPE=ACCESS

    Posted Thu October 13, 2022 01:28 PM
    Thanks, this worked:


    ------------------------------
    Linnea Sullivan
    ------------------------------

    Original Message