Here’s something we hope you’ll really like: SELECT cast(OS_NAME as varchar(10)) as OSNAME,       cast(‘V’ || TRIM(OS_VERSION) CONCAT            ‘R’ CONCAT TRIM(OS_RELEASE) as varchar(10)) AS OSVER,                AS TR  FROM SYSIB…

Here’s something we hope you’ll really like:
SELECT cast(OS_NAME as varchar(10)) as OSNAME,
      cast(‘V’ || TRIM(OS_VERSION) CONCAT
           ‘R’ CONCAT TRIM(OS_RELEASE) as varchar(10)) AS OSVER,        
      TR.TR AS TR
 FROM SYSIB…lnkd.in/dx2yBvmb

– SQL iQuery for #IBMi (@sqliquery)09:27 – Apr 18, 2022