IBM Version 5 Column name Data type

Chapter 6. RDB and XML integration 139
Table 6-6 EMP_ACT TABLE in SAMPLE database
Example 6-15 Example DAD file specification with SQL_mapping scheme
<?xml version="1.0"?>
<!DOCTYPE DAD SYSTEM "X:\dxx\dtd\dad.dtd">
<DAD>
<validation>NO</validation>
<SQL_stmt>
SELECT a.empno, firstname, lastname, workdept, b.projno, b.emstdate
from EMPLOYEE a, EMP_ACT b
where a.empno = b.empno order by b.projno
</SQL_stmt>
<prolog>?xml version="1.0"?</prolog>
<doctype>!DOCTYPE employee SYSTEM
"<drive-letter>:\redbooks\SG246586\code\employee.dtd">
</doctype>
<root_node>
<element_node name ="employee">
<attribute_node name="id">
<column name="empno"/>
</attribute_node>
<element_node name ="firstname">
<text_node>
<column name="firstname"/>
</text_node>
</element_node>
<element_node name ="lastname">
<text_node>
<column name="lastname"/>
</text_node>
</element_node>
<element_node name ="workdept">
<text_node>
<column name="workdept"/>
</text_node>
</element_node>
<element_node name ="project" multi_occurrence="YES">
<element_node name="projno">
<text_node>
<column name="projno>/>
</text_node>
Column name Data type
EMPNO CHAR(6) NOT NULL
PROJNO CHAR(6) NOT NULL
EMSTDATE DATE