DB2 partitioning

ALTER TABLE SCHEMA.TABLENAME
ADD PARTITION PART_15 STARTING FROM ('2015-01-02 12:00:00.0') EXCLUSIVE ENDING AT ('2016-01-01 12:00:00.0') EXCLUSIVE

DB2 comma separated ids

CREATE OR REPLACE FUNCTION FN_TOKENIZE" (source clob(2M), pattern varchar(128))
    returns table (seq int, tok varchar(4000))
    contains sql  deterministic  no external action
return select seq, tok
from xmltable(
       'for $id in tokenize($s, $p) return {string($id)}'
            passing  source as "s", pattern as "p"  columns   seq for ordinality
      ,tok varchar(4000) path '.'
     ) t


SELECT * FROM TABLE WHERE ID IN (select INT(TOK) from table(fn_tokenize(YOUR_IDS, ',')))

DB2 ALTER

ALTER TABLE
 ALTER COLUMN DROP DEFAULT

ALTER TABLE
 ALTER COLUMN SET NOT NULL

ALTER TABLE
 ALTER COLUMN SET DATA TYPE INTEGER

CALL sysproc.admin_cmd('REORG TABLE BMW.DISCOUNT_RATES_CONFIG')

DB 2 - rownum

select * from (
    select a.ACCOUNT_ID, ROW_NUMBER() OVER() as rownum FROM USER a
)
where rownum between 300 and 400

Substract queries

If you need to check differences between tables use this query:

select * from t1
minus
select * from t2


Statistical SQL query

For example you need to count how many companies in which source system:

select count(*), source_system_id from company group by rollup(source_system_id)