The EXCLUSIVE keyword opens the database in exclusive mode and prevents access by anyone but the current user. To allow others to access the database, you must first execute the CLOSE DATABASE statement and then reopen the database without the EXCLUSIVE keyword. The following statement opens the stores_demo database on the training database server in exclusive mode:
DATABASE stores_demo@training EXCLUSIVE
If another user has already opened the specified database, exclusive access is denied, an error is returned, and no database is opened.
Related statements: CLOSE DATABASE, CONNECT, CREATE DATABASE, DISCONNECT, and SET CONNECTION
For discussions of how to use different data models to design and implement a database, see the IBM Informix Database Design and Implementation Guide.
For descriptions of the sqlca structure, see the IBM Informix Guide to SQL: Tutorial or the IBM Informix ESQL/C Programmer's Manual.