Table 6-6 EMP_ACT TABLE in SAMPLE database

Column name

Data type

EMPNO

CHAR(6) NOT NULL

PROJNO

CHAR(6) NOT NULL

EMSTDATE

DATE

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>

Chapter 6. RDB and XML integration 139

Page 155
Image 155
IBM Version 5 manual Empact Table in Sample database