In order to use ATG Merchandising, you need to create database tables. Run the dcs_versioned_ddl.sql script in the following directory:
<Atg2007.3dir>/DCS/Versioned/sql/install/database-vendor
When installing tables on an evaluation copy of ATG Merchandising, the command takes this format. This command includes the default arguments used for a SOLID database:
<Atg2007.3dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
publishing publishing<Atg2007.3dir>\DCS\Versioned\sql\install\solid\
dcs_versioned_ddl.sql
where <Atg2007.3dir> is the path to your ATG 2007.3 directory, 1313 is the port for your SOLID database, and publishing is the username and password used for the ATG Merchandising table space on SOLID.
The tables created by dcs_versioned_ddl.sql have the same names as those created by the script used to install core Commerce tables called dcs_ddl.sql, the only difference being that some tables provided by dcs_versioned_ddl.sql have additional columns for storing data on versioned assets. Those tables are implemented by the individual scripts described in the table below. If necessary, you can run these subscripts individually from the following directory:
<Atg2007.3dir>/DCS/Versioned/sql/db_components/database-vendor
Script name | Purpose |
|---|---|
| Creates tables that support the versioning of coupons |
| Creates tables that support the versioning of price lists |
| Creates tables that support the versioning of products and catalogs |
| Creates tables that support the versioning of promotions |
Creating Versioned Custom Catalogs Tables
If you want to run ATG Merchandising and Consumer Commerce with custom as opposed to standard catalogs or if you want to run the custom catalogs modules on its own, you need to create tables that support versioned custom catalogs in addition to the tables that you create for core commerce. Run the versioned_custom_catalog_ddl.sql in the following directory:
<Atg2007.3dir>/DCS/CustomCatalogs/Versioned/sql/db_components
/database-vendor
When installing tables on an evaluation copy of ATG Merchandising, the command takes this format. This command includes the default arguments used for a SOLID database:
<Atg2007.3dir>DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
publishing publishing <Atg2007.3dir>\DCS\CustomCatalogs\Versioned\sql\
db_components\solid\versioned_custom_catalog_ddl.sql
where <Atg2007.3dir> is the path to your ATG 2007.3 directory, 1313 is the port for your SOLID database, and publishing is the username and password used for the ATG Merchandising table space on SOLID.
For information on the differences between standard and custom catalogs, see Using Standard or Custom Catalogs.
