If you want an Enterprise Database Server database to be updated by SQL queries, the database must meet the following requirements:
-
The database must be audited and include the REAPPLYCOMPLETED and INDEPENDENTTRANS options. Refer to the Data and Structure Definition Language (DASDL) Programming Reference Manual for details on these options.
-
The database must be imported through the Relational Design Center utility with the Read-only access control option reset. See Importing a Relational Schema for more information.
Or, the clause ACCESSCONTROL = UPDATEOK must be included as part of the Schema Administrator RUN statement. Refer to Manually Enabling SQL Access to an Enterprise Database Server Database for more information.
-
The database resource must specify MODE UPDATE. Refer to the DMQUERY utility OPEN command in Using the DMQUERY Utility for more information.
-
Although updates to an Enterprise Application Environment (EAE) database can be performed using the Query Processor, such direct updates are not recommended as they might violate EAE application business rules and corrupt the application integrity of an EAE system.

