Q: How can I create an empty IBM DB2 ECO Database?
A: Generally, you need an empty database as a container for storing EcoSpace. Delphi 2005 provides a CD, including the IBM DB2 UDB Developer Edition. You can use Control Center (which can be found in IBM DB2 General Administrator Tool ). In the Control Center, you can use a tree view to view systems, DB2 instances, and databases. Use the Wizard to create a new database, which provides you with a seven-step wizard where you only need to specify the name of the new empty database (some are similar to ECO2ASP ).
The SQL DDL used to create a database is as follows:
Create database ECO2 on c: USING CODESET
IBM-1252 territory us collate using system;
Note: After creating an empty IBM DB2 UDB ECO2 database, you need to switch to Data Explorer and add a new DB2 Connection to the ECO2 database. Make sure that the correct database name (ECO2) is specified, and a valid user name and password must be specified to connect to the database.