If you want to run ATG Merchandising and Consumer Commerce with custom catalogs or if you want to run the custom catalogs module on its own, you need to create additional tables that support versioned custom catalogs.
Note: You do not need to run this script if you have Business Commerce. See Creating Versioned Business Commerce Tables.
To create the versioned custom catalogs tables, run the versioned_custom_catalog_ddl.sql
script located in the following directory:
<ATG9dir>/
DCS/CustomCatalogs/Versioned/sql/db_components
/database-vendor
To install the tables on an SOLID evaluation database, open a command prompt and enter the following command, which includes the default arguments for a SOLID database:
<ATG9dir>
DAS\solid\i486-unknown-win32\solsql.exe "tcp 1313"
publishing publishing <ATG9dir>\
DCS\CustomCatalogs\Versioned\sql\
db_components\solid\versioned_custom_catalog_ddl.sql
where <ATG9dir>
is the path to your ATG 9.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 Standard or Custom Catalogs.