IBM Security Z Security

Expand all | Collapse all

zSecure CARLa: Displaying Literal Field when blank

  • 1.  zSecure CARLa: Displaying Literal Field when blank

    Posted 9 days ago

    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 8 days ago
    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
    ------------------------------



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

    Posted 6 days ago
    Thanks -- exactly what I'm looking for!

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