Filter
Top Products
138 The XML Files: Development of XML/XSL Applications Using WebSphere Studio
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)