DB2

         

DB2




DB2
, DB2
DB

SQL



















SELECT*


BETWEEN()
IN()
LIKE( )
, NULL ( )
,


̻











,
, IN
, EXISTS
, NOT EXISTS
,


SELECT
SELECT DISTINCT
SELECT


GROUP BY
WHERE GROUP BY
HAVING


, UNION


UPDATE




DELETE




INSERT



INSERT..SELECT








DB2







GRANT REVOKE


,

SELECT
,




COMMIT ROLLBACK
,
DB




, SELECT
SELECT








SPUFI
DCLGEN
BIND/REBIND/FREE


RUN


DB


QUERY-BY-EXAMPLE
, OR



( )



.
DATA EXTRACT (DXT)





A


.

DB2




.
:
:
: - 2

,
,



C

.



D DB2
D QMF
D DXT