This discussion is archived
3 Replies Latest reply: Aug 9, 2012 5:50 AM by 608249 RSS

Simple Query help

608249 Newbie
Currently Being Moderated
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..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points