IBM WCS DB2 SORTING DESC WITH NULL VALUES IN LAST

-
SELECT * FROM USERS ORDER BY   CASE when REGISTRATION is null then 1 else 0 end, REGISTRATION DESC 

Comments

  1. TechTanker19 June 2020 at 00:07

    Article ideas very clear . Your writing style is very unique. I very much appreciate the articles you write.
    TechTanker
    TechTanker

    ReplyDelete

Post a Comment

Popular posts from this blog

Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML

-
Websphere Commerce Data Load using CSV \Websphere Commerce Data Load using XML Data can be loaded into WCS tables using data load utility. Data load utility works in the steps as mentioned below. 1.Data Reader The data reader reads the input file, and transforms the input into a data object. Data objects are typically map objects. Eg: CSV data reader \XML Data Reader 2.Business Object Builder The business object builder instantiates the business object and populates it from the data in the data object. Eg:The table object builder 3. Business Object Mediator The business object mediator converts the business object into physical object. The table object mediator is always used with the table object builder. Eg: table-based mediator 4. Data Writer The data writer writes the physical object into the database. This tutorial uses the default data writer to write the generated physical o...
Read more

Websphere Commerce Catalog Subsystem

-
  Websphere Commerce Catalog Subsystem The Catalog Subsystem contains all logic and data relevant to an online catalog, including catalog groups (or categories), catalog entries, and any associations or relationships among them.    Master Catalog It is the single catalog that contains all products, items, relationships, and standard prices for everything that is for sale in your store. Every store in the Web Sphere Commerce system must have a master catalog. It is possible to share the master catalog across stores. Master Catalog Restrictions 1)The master catalog must be a proper tree, which means that there are no cycles. e.g.The parent category "Women" has a subcategory "WomenDress". It is important that WomenDress and any of WomenDress's subcategories like tops,jeans etc are not the parent category of "Women" category. 2)A catalog entry or category cannot belong to multiple parent categories in the master...
Read more

WCS Misc Query

-
-- Query records that have been stage propogated from staging to runtime database select * from staglong where stgprocessed = 1 -- Query various adaptor properties SELECT K3.DESCRIPTION,INTERSPECATTNAME,INTERSPECATTVALUE FROM iseditatt K1, PROFILE K2, MSGTYPES K3 WHERE K1.PROFILE_ID = K2.PROFILE_ID AND K2.MSGTYPE_ID = K3.MSGTYPE_ID AND K1.PROFILE_ID IN (SELECT PROFILE_ID FROM PROFILE WHERE MSGTYPE_ID IN (SELECT MSGTYPE_ID FROM msgtypes WHERE name LIKE '%%')); -- Create ACP Policy entry for a new View, this is a quick and dirty approach -- alternate option is to make use of acpload utility -- replace MyNewView with the actual view name insert into acaction values ((Select max(acaction_id) from acaction)+1, 'MyNewView', null); insert into acactgrp values (10196, Select acaction_id from acaction where action='MyNewView', null, null); -- Generate update sql select concat(concat(concat('update keys set counter=',concat(concat( concat(concat('(select...
Read more