SQL statement

This field displays an SQL template for a CREATE VIEW statement. To create a view, type in your own SQL statement, or type in the appropriate SQL according to the template.

Examples

(projno, projname, in_charge)
AS
SELECT projno, projname, respemp
FROM project
WHERE substr(projno, 1,2)='MA'

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]