Kbase P5816: R-code CRCs and Procedure Integrity
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/12/2002 |
|
Status: Unverified
GOAL:
R-code CRCs and Procedure Integrity
FIX:
PROGRESS Version 7 introduced r-code CRC, which is different from database CRC. When PROGRESS compiles a procedure, it calculates a special CRC based on the procedure name and code content, and stores it in the r-code. This r-code CRC
is useful to ensure the integrity and security of PROGRESS procedures, especially for schema triggers.
To find out what the CRC value is in the r-code, you can run the following program.
DEFINE VARIABLE rcode-file AS CHARACTER FORMAT "x(60)" LABEL "File".
REPEAT:
SET rcode-file WITH FRAME rc-info.
RCODE-INFO:FILE-NAME = rcode-file.
DISPLAY RCODE-INFO:CRC-VALUE LABEL "CRC"
RCODE-INFO:LANGUAGES FORMAT "x(60)" LABEL "Languages"
WITH FRAME rc-info SIDE-LABELS TITLE "R-code Check".
END.
This is the output from the above program:
R-codeCheck
File: ref_call.p
CRC: 30,009
Languages: <unnamed>
The file ref_call in the Sports database has a CREATE schema trigger. The file the CREATE trigger executes is called ref_call.p. The CRC value in the r-code is
30009.
Next, run the following program against the metaschema:
FOR EACH _File-Trig.
DISPLAY _Event _Proc-Name _Override _Trig-CRC.
Event Proc-Name Override Trig-Crc
------ -------------------------------- -------- --------
CREATE sports/crinv.p no ?
DELETE sports/delinv.p no ?
CREATE sports/crcust.p no ?
DELETE sports/delcust.p no ?
WRITE sports/wrcust.p no ?
CREATE sports/critem.p no ?
WRITE sports/writem.p no ?
CREATE sports/crord.p no ?
CREATE sports/crordl.p no ?
DELETE sports/delordl.p no ?
WRITE sports/wrordl.p no ?
CREATE ref_call.p no 30009
As you can see, the crc value stored in the r-code is 30009 and this matches the r-code value stored in the _Trig-Crc in the _File-Trig file.