IBM Security Z Security

Security for Z

Join this online user group to communicate across Z Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  date / time CARLA not working as expected

    Posted 12/02/20 03:06 PM

    Hello -- having a problem with date / time CARLA code:

    S,

    (TYPE=80) ,

    ( TIME=1021:1514 DATE=28NOV2020:01DEC2020)

    I'm looking for the start / end to span the date range 11/28 10:21 ---- 12/01 15:14 but I am only getting records within that time window (10:21-15:14) for each day.

    Thanks, Joe


    #ZSecurity
    #SupportMigration
    #Support


  • 2.  RE: date / time CARLA not working as expected

    Posted 12/18/20 12:06 AM

    Hi Joe,

    To do the range selection you are attempting, the use of the DATETIME keyword is necessary. Try this:

    SELECT DATETIME>'28nov2020 1021' DATETIME<'01dec2020 15:14'

    This should give you the expected results.


    #Support
    #ZSecurity
    #SupportMigration


  • 3.  RE: date / time CARLA not working as expected

    Posted 12/18/20 12:10 AM

    Hi Joe,

    To be more precise, the following is a better solution:

    SELECT DATETIME>='28nov2020 1021' DATETIME<='01dec2020 15:14'

    John young


    #SupportMigration
    #Support
    #ZSecurity


Related Content