IBM Security Z Security

 View Only

  • 1.  zSecure CARLa: Displaying Literal Field when blank

    Posted Fri July 31, 2020 03:54 PM

    Does CARLa have a function that will display a specific literal when a field is blank, but the contents of the field if it is not blank?

    Best I've come up with is defining  a field for the "missing" condition, then doing a concatenation on the output with that field + the checking field, something like:

      

       DEF $noprofile('' str$blank('No_Profile'),10) true where missing(profile)

   Sortlist $noprofile | profile


    Of course that's just a column with no header. Basically in above I'd like to display "No_Profile" in the "profile column if it's missing, else the profile itself.



    ------------------------------
    Adam Klinger
    ------------------------------


  • 2.  RE: zSecure CARLa: Displaying Literal Field when blank

    Posted Sat August 01, 2020 07:51 AM
    Hi Adam,

    zSecure 2.4 (base level) added the CHR$STR output format:

    "CHR$STR('string')

    Characters or string. Formats a field as its character value if it exists and as the specified string if it is missing. The string can be enclosed in single, double, or left quotation marks. See also HEX$STR and UTF8$STR."

    Regards,

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

    Original Message


  • 3.  RE: zSecure CARLa: Displaying Literal Field when blank

    Posted Mon August 03, 2020 08:00 AM
    Thanks -- exactly what I'm looking for!

    ------------------------------
    Adam Klinger
    ------------------------------

    Original Message