DB2 z/OS DB2 LUW
z/OS CICS VTAM

DB2 z/OS Info

Sonstige Beispiele

Explain Statement Cache

-START TRACE(MON) IFCID(316,318)

EXPLAIN STMTCACHE ALL;

EXPLAIN STMTCACHE STMTID 4711;

-STOP TRACE(MON)

FTP Script im Batch ausfuehren :

aufruf : ftp -s:ftptext.script

script : ftptext.script
open 192.168.0.100
userid
passwd

get 'input.dataset' otput.dataset

ls
by

Trigger um bei Insert einen Wert zu setzen

SET CURRENT SCHEMA 'XXXXXXX' ;

CREATE TABLE TSTEMP2
( ID      INTEGER NOT NULL
, TEXT      CHAR(200)
)
IN DATABASE.TABLESPACE
CCSID UNICODE
NOT VOLATILE
DATA CAPTURE NONE
APPEND NO     ;

CREATE TRIGGER TSTEMP2_INSERT1
AFTER
INSERT
ON TSTEMP2
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
UPDATE TSTEMP2 TB SET TEXT = 'HUGO ' !! CHAR(N.ID)
WHERE TB.ID = N.ID
;

Umrechnen LRSN nach TIMESTAMP

SELECT 'LRSN > TS ', 
       TIMESTAMP(X'CDC2C2A95066' CONCAT X'0000') + CURRENT TIMEZONE 
     , TIMESTAMP(X'CDC2C2A95066' CONCAT X'0000') 
FROM SYSIBM.SYSDUMMY1;