Previous Topic: Example Output MemberNext Topic: Creating an Area

Creating SQL Objects › Creating a Database

Creating a Database

Use a CREATE DATABASE statement to define a database to CA Datacom/DB and CA Datacom Datadictionary. For the steps to obtain the panel and an explanation of the fields on the panel, see How to Submit SQL Statements. Alternatively, you can use DBSQLPR or an external program to issue this statement. For the syntax of the statement, see CREATE DATABASE.

Use CREATE DATABASE to do the following:

  1. Specify the database name. This is the SQL Name and must not identify an existing database, area, table, view, or synonym.
  2. Specify the CA Datacom database identifier. This is a 5-digit ID for the database (also known as the DBID). The ID must be unique within the Multi-User Facility (MUF). This ID is stored in the CA Datacom/DB Directory (CXX) and is used by CA Datacom/DB to identify a database. Database IDs 00001-00020, 1000-1020, 2000-2020, 3000-3020, 4000-4020, and 5000 are reserved for CA. For a list of reserved database IDs, see the CA Datacom/DB Database and System Administration Guide.

For more information about the optional attributes that can be specified, see CREATE DATABASE.