Q: How can I create an empty IBM DB2 ECO database?
Answer: Generally speaking, you need an empty database as a container to store EcoSpace. Delphi 2005 provides a CD, including IBM DB2 UDB Developer Edition. You can use the Control Center (found in the IBM DB2 General Administrator Tool ). In Control Center, you can use a tree view to view the system, DB2 instances, and databases. Create a new database using the wizard, which will give you a 7-step wizard where you just specify the name of the new empty database (some 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 you need to specify the correct valid username and password to connect to the database.
Answer: Generally speaking, you need an empty database as a container to store EcoSpace. Delphi 2005 provides a CD, including IBM DB2 UDB Developer Edition. You can use the Control Center (found in the IBM DB2 General Administrator Tool ). In Control Center, you can use a tree view to view the system, DB2 instances, and databases. Create a new database using the wizard, which will give you a 7-step wizard where you just specify the name of the new empty database (some 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 you need to specify the correct valid username and password to connect to the database.