Hello,

We will be implementing a new file structure. Due to time constraints
the decision was made to set up parallel files and then make code
changes as we can make human procedural changes. The files need to be
kept in sync and the first idea was to use post write triggers. I am
concerned about recursion and was hoping someone here could shed some
light on the issue.

So let me offer an example.
OLD.PRODUCT.FILE
NEW.PRODUCT.FILE

Attributes will not be in the same location. Therefore, attribute 2
through 10 on the old file will be scattered from 11 to 80 in the new
one.

Every time one of the shared attributes in OLD.PRODUCT.FILE is changed
the matching attribute in NEW.PRODUCT.FILE needs to be updated. The
same thing needs to happen from NEW.PRODUCT.FILE to OLD.PRODUCT.FILE.

Can we write the trigger to ignore file changes made by the other
trigger? If so, how?

Is there a better way to do this that will keep nearly real time
synchronization at a lower system over head cost?

The only system information that I thought was important to this
question was:
RELEASE Information         : Major 3.4 , Minor 10 , Patch 0373

Thank you

-- 
Please read the posting guidelines at: 
http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to 
Globus/T24

To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

Reply via email to