Creating a WebSphere Commerce e-Marketing Spot w/SQL (Text Content)
The following SQL can be used to create a new e-marketing spot that is used to display text or other text-based creative, like HTML. If you’re looking for the SQL used to create an e-marketing spot that can be used to display image assets, you can reference the following article: Creating a WebSphere Commerce E-Marketing Spot w/SQL (Image Assets) The following tables are used or referenced when creating an e-marketing spot with the SQL shown below: COLLATERAL : This table contains data describing the advertisements used by marketing campaigns. STOREENT : Each row of this table represents a StoreEntity. A StoreEntity is an abstract superclass that can represent either a Store or a StoreGroup. COLLTYPE : This table defines all possible types of Collateral. Examples of Collateral types are image, flash and text. ESMAPOBJ : This table contains objects scheduled to E-Marketing Spot. ESMAPTYP : This table contains object types that can be scheduled to E-Marketing Spot. EMSPOT : This