If I understand what you are trying to do you might want to consider
storing the journal sequence number instead of the date.
On Thu, Sep 6, 2012 at 6:58 AM, Stone, Joel <Joel.Stone@xxxxxxxxxx> wrote:
Collections are used to replicate all our app files onto Wintel for a myAccount web app.
I started using triggers, but those have all sorts of gotchas that are really nasty (must get exclusive use of file to start trigger, same for stopping, must make control pgm to get around, difficult to mod pgms cause users are in file, etc).
I always figure there are those smarter than me that have beaten the blazing trails, and all the commercial replication s/w seem to use journals as opposed to triggers. So I am copycatting them :).
I figure the ultimate goal is to get the data onto Wintel so the company can move off the iseries one day without having to hire an army of COBOL/CL/DDS gurus to interpret what is in place now.