After generating an SQL description using the SQLVIEW command, a results file containing confirmation messages, error messages, and structure mappings is produced.

If you use the Schema Administrator command interface, the default name of the results file is

DDLRESULTS/<database name>

You can file-equate the results file so that it is created with a name other than the default shown in the preceding example.

The results file is located under the usercode and on the primary pack with which the Schema Administrator is initiated. The format of the results file is compatible with the file format of the compiler error messages. This compatibility enables you to use the Editor Utility to view the messages in the context of the CARD file.

After examining the errors, you can print them. Then, from the Relational Design Center, reload the semantics you have created, make appropriate changes to the semantics, save the changes, generate the semantics, upload the new semantics, and rerun the Schema Administrator program.