CONNX Data Integration Suite 14.8.0 | Reference Guide | SQL Grammar | Primary SQL Commands | CREATE DATABASE
 
CREATE DATABASE
Function
This statement creates a new database entry in a data dictionary using DDL.
Syntax
CREATE DATABASE container_name [
ADABAS DBID dabatase_id HOST server_name [PORT port_number] [REMOTE PORT port_number] [REMOTESERVER remote_server_name] |
POWERFLEX/VSAM/RMS/CISAM/DISAM/DATAFLEX/MICROFOCUS/RMCOBOL HOST server_name [PORT port_number] [REMOTEPORT port_number] [REMOTESERVER remote_server_name]
where
container_name
The logical name for the database in the data dictionary.
database_id
The ADABAS DBID.
server_name
The machine the database server is running on.
port_number
The TCP/IP port that the CONNX server is listening on.
remote_server_name
The name of the server running the enterprise server service.
CREATE DATABASE only applies to ADABAS, VSAM, RMS, CISAM, DISAM, DATAFLEX or POWERFLEX, MICROFOCUS, and RMCOBOL databases.
CREATE DATABASE does not actually create a database; instead it links CONNX to an existing database for further processing.
With CREATE DATABASE, you can create a link to an Adabas database using a script instead of using the CONNX Data Dictionary (CDD) Manager.
Execute a DISCONNECT prior to using the DATABASE container.
Execute a CREATE DATABASE before a CONNECT; otherwise the CONNECT will fail.
After executing a CREATE DATABASE, you can execute CREATE TABLE DESCRIPTION to complete the CDD.