[gpfsug-discuss] gpfsug-discuss Digest, Vol 108, Issue 18

[Jonathan Buzzard]

On 01/02/2021 21:09, Owen Morgan wrote:
> CAUTION: This email originated outside the University. Check before 
> clicking links or attachments.
> Jonathan,
> 
> If I have a single policy file with all the related department rules and 
> each time they want to add additional rules with different working day 
> thresholds maybe using this -M method is easier. Its clear that the 
> 'maths' and date/timestamp manipulation is easier in shell (my preferred 
> is bash) than in the SQL of the policy (your example is succinct but 
> needs to be repeated everytime a new rule is added with a different 
> working day threshold, which is what I'm trying (if possiblr) to avoid.
> 

I actually think there is a much better way to achieve it than the case 
statement, but that would have required me to do some more thinking and 
testing to make sure it worked ;-)

Anyway how many different "working" days old do you need?


JAB.

-- 
Jonathan A. Buzzard                         Tel: +44141-5483420
HPC System Administrator, ARCHIE-WeSt.
University of Strathclyde, John Anderson Building, Glasgow. G4 0NG