Create Informix® databases for schedulers
using data definition language (DDL) or structured query language
(SQL) files.
About this task
To create Informix databases for schedulers,
using data definition language (DDL) or structured query language
(SQL) files, use these steps.
Procedure
- Open a command-line window.
- Verify that you have administrator rights for the database
system.
- Verify that the database supports Unicode (UTF-8).
Otherwise, the database does not store all characters that can
be handled in the Java™ code, which results in code
page conversion problems, when a client uses an incompatible code
page.
- If you want to create a new database named scheddb,
for example, enter the command:
dbaccess CREATE DATABASE scheddb with log
Results
The Informix database for scheduler exists.