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))

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..


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