SQL Query to Determine a Master Catalog ID
Database / WebSphere

SQL Query to Determine a Master Catalog ID

Working on a project recently I found the need to determine the master catalog for a list of stores within a WebSphere Commerce database. Seeing as a WebSphere Commerce instance can contain a variety of stores, ranging from your traditional Consumer Direct model to a more extensible Extended Site model, I generated the following query which can be run against the WebSphere Commerce database to properly determine the master catalog identifier for each store.

[ Read More ]

WebSphere Commerce v7.0 Store Functions
WebSphere

WebSphere Commerce v7.0 Store Functions

WebSphere Commerce v7.0 Feature Pack 2 introduced a new way to handle change flows, now referred to as store functions. For those not familiar with store functions, a store function is basically a way to handle and control pieces of your pages and/or logic from display or execution based upon the availability of the feature within your store.

[ Read More ]

DB2 Merge Query Example (Adding WC SHPARRANGE Records)
Database

DB2 Merge Query Example (Adding WC SHPARRANGE Records)

So, I was recently working on a client engagement and was needing to update the WebSphere Commerce SHPARRANGE table, to enable certain functionality in an external application. Not knowing what data already existed in the production system, I wanted the ability to write a query that would update existing or insert new data, to verify the records that I needed to exist.

[ Read More ]