Hello all,
I have a strange one here. I will try to be as clear as I can.
One of our applications uses a lot of SQL trigger in its logic.
Some trigger are of the type "FOR EACH STATEMENT" meaning that the trigger is fired after the completion of a statement, not after each row change.
Those type of trigger uses 2 temporary files it creates in QTEMP. They are named QTRG*. One is reference as "OLD TABLE" and one as "NEW TABLE". The OS handle the creation of those file.
In the SQL trigger, we can use those 2 files to do whatever needs to be done. In our case, we select some field from "NEW TABLE" and add them to another table for further processing.
Here is the strange thing. Sometimes, not always, we get a CPD4301 message when we try to select records from "NEW TABLE". It states that a field is not found in the QTRG file and goes on stating some more information about the file (library, record format ...).
I then noticed than the record format specified is the record format of another file!
That other file also has a "FOR EACH STATEMENT" trigger attached to it.
So it looks like there is a mix up as to what QTRG* file to associate to it's appropriate trigger.
IBM support has been of no help so far (several weeks) whit this situation.
Has anyone faced a similar situation?
As usual, any help will be appreciated.
[cid:image001.jpg@01D1F7D9.2487F9B0]<
http://www.cascades.com/_home>
Denis Robitaille
Chef de service TI - Solution d'entreprise
Infrastructure et opérations
CASCADES CENTRE DES TECHNOLOGIES
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
Tél : 819 363 6100 Poste :52130
Cell : 819 352 9362
midrange.com
