IBM Version 5 manual Employee table in Sample database, Column name Data type

￿The tag <SQL_stmt> identifies the SQL_stmt element in the DAD file.

￿The content of the element <SQL_stmt> is a valid SQL SELECT statement.

￿The SQL_stmt maps the columns in the SELECT statement to XML document elements or attributes.

￿The column names in the SELECT define the value of an attribute_node or the content of a text_node.

An attribute_node maps the value of an attribute in the XML document to a table column.

A text_node maps the content of the element in the XML document to a table column. A text_node is specified for the lowest level element nodes, that is, these element nodes do not have any child elements.

￿The FROM clause of the SELECT identifies the tables containing the data.

￿The WHERE clause specifies join (the columns on which the collection tables will be joined) and search condition.

Table 6-5 EMPLOYEE table in SAMPLE database

Column name	Data type
EMPNO	CHAR(6) NOT NULL
FIRSTNME	VARCHAR(12) NOT NULL
MIDINIT	MIDINIT(1) NOT NULL
LASTNAME	VARCHAR(15) NOT NULL
WORKDEPT	CHAR(3)
PHONENO	CHAR(4)
HIREDATE	DATE
JOB	CHAR(8)
EDLEVEL	SMALLINT NOT NULL
SEX	CHAR(1)
BIRTHDATE	DATE
SALARY	DECIMAL(9,2)
BONUS	DECIMAL(9,2)
COMM	DECIMAL(9,2)

138 The XML Files: Development of XML/XSL Applications Using WebSphere Studio