The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions. Alongside DB2 is another RDBMS: Informix, which was acquired by IBM in 2001.
SELECT cog FROM table WHERE conditional statement .
WHERE is depleted in on a relational statement to isolate the object factor or row
Joins, unions and nested selects are expended to retrieve data
DDL is info definition slang and DML is info manipulation gobbledygook DDL statements are CREATE, ALTER, TRUNCATE DML statements are SELECT, INSERT, DELETE and UPDATE .