Creating Informix databases for schedulers

Before you begin

This topic describes how to create Informix databases for schedulers, using data definition language (DDL) or structured query language (SQL) files.

Why and when to perform this task

To create an Informix database for an application scheduler, follow these steps.

Steps for this task

  1. Open a command-line window.
  2. Verify that you have administrator rights for the database system.
  3. 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.
  4. If you want to create a new database named scheddb, for example, enter the command:
    dbaccess CREATE DATABASE scheddb with log

Result

The Informix database for scheduler exists.
Here's an example... Insert tab A into slot B.

What to do next

Now, you too can do this...

Copyright IBM Corp. 2003, 2005 |