You can run CodeXpert from the Editor window, or from its own window as follows:
Editor, right-click in the panel tabs, select Desktop Panels|CodeXpert.
Stand-alone, on the menu select Database|Diagnose|CodeXpert.
Use CodeXpert to analyze your code based on standards and metrics. Check out the Properties|Module Analysis section.
Does your code query or update? Use the CRUD Matrix report to find out.
Double-click on any rule that has been flagged to read about the rule, see examples, and possibly learn how to fix your problem.
If you are not interested in embedded SQL complexity, turn off SQL SCAN to run reports more quickly.
Set CodeXpert to run all DB inserts from a central repository. Click the Options button on the CodeXpert toolbar.