3 Replies Latest reply on Aug 9, 2012 12:50 PM by NeilCSE

    Simple Query help

      I have table which has unix file permission col e.g.
      Tab ( col1 v2(10))

      I want to convert it to values to 777 second 755 which is ( 111 101 101) ...and then want to subtract from 777 and display the result

      based on the first char if it is 'l' I want to display it as 'symbolic' if not then I want to subtract it with 777 and display the results ( under column header umask)

      using of substring with Case etc should be fine

      any question on the above..