Laden von Prozeduren
--------------------

db2 -td@ -f ts_fmt.sql

@ ist Delimiter der am Ende stehen mu


Hilfsfunktion zur formatierten Datumsausgabe
----------------------------------------------------
create function ts_fmt(TS timestamp, fmt varchar(20))
returns varchar(50)
return
with tmp (dd,mm,yyyy,hh,mi,ss,nnnnnn) as
(
    select
    substr( digits (day(TS)),9),
    substr( digits (month(TS)),9) ,
    rtrim(char(year(TS))) ,
    substr( digits (hour(TS)),9),
    substr( digits (minute(TS)),9),
    substr( digits (second(TS)),9),
    rtrim(char(microsecond(TS)))
    from sysibm.sysdummy1
    )
select
case fmt
    when 'yyyymmdd'
        then yyyy || mm || dd
    when 'mm/dd/yyyy'
        then mm || '/' || dd || '/' || yyyy
    when 'yyyy/dd/mm hh:mi:ss'
        then yyyy || '/' || mm || '/' || dd || ' ' ||
               hh || ':' || mi || ':' || ss
    when 'nnnnnn'
        then nnnnnn
    else
        'date format ' || coalesce(fmt,' <null> ') ||
        ' not recognized.'
    end
from tmp
@
-------------------------------------------------------------

Dump ziehen der DB
------------------
db2 connect to zv4xap01 user catxadm using admXcat01
db2look -d ZV4XAP01 -i catxadm -w admXcat01 -e > sysmt-2.4.0.sql

