I have migrated a 9.x db (32bit) to a 10.x db (64bit).
Recompiled my source-code on the 64 bit machine and ran a batch job which would fire a write trigger and i get:
CRC for database trigger procedure does not match schema. (3242)
I used following code to check write trigger CRC of the table on windows
FIND _file WHERE _file-name = "mytable".
FIND _file-trig WHERE _file-recid = RECID(_file) AND _event = "WRITE" NO-ERROR.
IF AVAILABLE _file-trig THEN DO:
DISP _File-trig._Trig-CRC .
END.
and compared this with R-Code CRC info on both systems , and they are different.
It matched the 32bit version.
So my question.
Is it not possible to have "CRC check on" if you need triggers in mixed ( 32bit / 64bit ) environments?
Could not find info on this in the "migration" white paper
We need DB triggers for windows client who are 32 bit and linux batch jobs which are 64 bit.
So i guess i need to compile 2 times and make sure that the right environment get the right r-code.
check the "-trig" client startup parameter.