WebSphere "commands" used in the Danly interface: Logon log a user on Logoff log a user out ResetPassword reset a user's password RegisterNew register a new user RegisterUpdate change a user's password ExecMac execute a macro file ExecCmds execute a set of other websphere commands OrderItemUpdate add an item to an order (shopping cart) OrderItemDelete remote an item from an order (shopping cart) OrderCopy modify fields in an order (shopping cart) OrderProcess "Process" an order (to make it status complete), run MQ AddressAdd add a new SHADDR table row AddressDelete delete a SHADDR table row CategoryDisplay display category info ProductDisplay display product info Note: the most important uses of the websphere commands are: 1. User authentication: login/logout, password setting, registering new users. 2. Inserting new rows in tables, since the websphere commands embed the logic for generating new primary keys (reference numbers) for those tables. Many of the other uses could be replaced with SQL queries, which would actually make many of the page transitions easier. When we started this project, it was unclear what some of these commands did *besides* doing update queries, so we were originally tentative about replacing them with our own dtw_sql function queries. In more recent months, our standard practice has been to use own our queries wherever possible. As a result of this, the CategoryDisplay, ProductDisplay, OrderCopy, OrderItemDelete, and AddressDelete commands could easily be replaced with dtw_sql queries.