recreate_er_define_stmts.sh
---------------------------

Written by Jarrod Teale (jarrod.teale@fonterra.com) 7th January 2010
You are free to change it however you want! Please just send me a copy of the new version.

This is a bash shell script that interrogates the syscdr database and generates "pretty" cdr define commands (Based on 11.50.xC5 on Redhat 4) .
It doesn't take account of conflict resolution (I don't have any) and assumes all replicates are "Primary - Recipient", not update anywhere.
 
If anyone wanted to extend this to account for the above (easy to do, the syscdr database is a breeze to navigate):
    Conflict resolution - look in the syscdr:repdef table (four rows starting with 'cr_')
    Update anywhere replicates - Remove the "P" section in the query and review the MULTISET clause
 
Things I haven't done:
    Found all the other flags from the repdef:flags column (Madison? can you help there?)
 
The bash scriptlet is to format the output 'nicely'.
 
I hope this helps someone else.
 
Jarrod Teale
Team Lead - Manufacturing Execution Systems
Fonterra