Previous Topic: CA SDM Object List Table for Multi-TenancyNext Topic: TABLE Statement


Schema Files Syntax

The CA SDM database schema is defined in multiple .sch files in the $NX_ROOT/site (UNIX) or installation-directory/site (Windows) directory. During configuration, these .sch files along with any customized .sch files you may create are merged together into a single file called $NX_ROOT/site /ddict.sch (UNIX) or installation-directory/site/ddict.sch (Windows).

Please review the chapter Customizing the Schema Using the Web Screen Painter in this guide prior to making any changes to these files.

Note: Do not modify any .sch files in the $NX_ROOT/site (UNIX) or installationdirectory/site (Windows) directory. Any changes you make to these files will be lost when upgrading to a new release or when certain patches are applied. If you want to make schema changes, you must create a file in the $NX_ROOT/site/mods (UNIX) or installation-directory/site/mods (Windows) directory with the file suffix .sch. Then add your changes to your .sch file, and your changes will then be merged with delivered schema during configuration. This is the only way to preserve your modifications when you upgrade to a new release.

This section contains the following topics:

TABLE Statement

TABLE_INFO Statement

Mapping Statement