Detail of Concepts Managed by DB2 V10.5
All SQL commands are available at the following address:
Tables
CREATE GLOBAL TEMPORARY TABLE
This new table type of DB2V10.5 is not supported by MEGA.
Indexes
Tablespaces
Views
Example:
CREATE VIEW MA_PROJ
AS SELECTPROJNO, PROJNAME, RESPEMP
FROM PROJECT WHERE SUBSTR(PROJNO, 1, 2) = ’MA’
Triggers
Example:
CREATE TRIGGER REORDER
AFTER UPDATE OF ON_HAND, MAX_STOCKED ON PARTS
REFERENCING NEW TABLE AS NTABLE
FOR EACH STATEMENT
BEGIN ATOMIC
SELECT ISSUE_SHIP_REQUEST(MAX_STOCKED - ON_HAND, PARTNO)
FROM NTABLE
WHERE (ON_HAND < 0.10 * MAX_STOCKED);END
Sequences
Example:
CREATE SEQUENCE ORG_SEQ
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO CYCLE
CACHE 24
Procedures
Example:
CREATE PROCEDURE PARTS_ON_HAND (IN PARTNUM INTEGER,
OUT COST DECIMAL(7,2),
OUT QUANTITY INTEGER)
EXTERNAL NAME ’parts.onhand’
LANGUAGE JAVA PARAMETER STYLE JAVA
