3 Replies Latest reply: Aug 9, 2012 7:50 AM by NeilCSE RSS

    Simple Query help

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

      Col1
      lrwxrwxrwx
      drwxr-xr-x
      -rw-r--r--
      -rw-------
      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..