This topic describes how to create tables for schedulers on Cloudscape
databases, using data definition language (DDL) or structured query language
(SQL) files.
About this task
To create tables for schedulers on Cloudscape databases, using data
definition language (DDL) or structured query language (SQL) files, use these
steps.
Procedure
- Open a command-line window.
- Create the schema.
- Using a text editor, edit the script, %app_server_root%\Scheduler\createSchemaCloudscape.ddl, according to the instructions at the top of the file.
Note: When
setting the table prefix, capitalize all characters.
- Enter one of the following commands.
Note: Cloudscape
provides both an embedded and network server version. This example is for
the embedded version of Cloudscape. See the Cloudscape product documentation
for more details on running DDL scripts.
On Windows systems (using the
example name, scheddb):%app_server_root%\cloudscape\bin\embedded\ij.bat %app_server_root%\Scheduler\createSchemaCloudscape.ddl
On UNIX systems (using the example name, scheddb): %app_server_root%/cloudscape/bin/embedded/ij.sh %app_server_root%/Scheduler/createSchemaCloudscape.ddl
Results
The Cloudscape tables and schema for the scheduler exist.