I have a problem while colling the dxxGenXML() method. I got the
following
error:
SQL0301N The value of input host variable or parameter number "1"
cannot be
used because of its data type. SQLSTATE=07006
DXXM001W A DB2 error occurred.
DXXG001E An internal error occured in build "Jun 16 2004/20:55:58",
file
"dxxcomp.sqx", and line "5385".
I am using DB2 V8.1 with fixpack 6.
More details:
My dad file:
<?xml version="1.0"?>
<!DOCTYPE DAD SYSTEM
"/develop/WSADworkspace/XMLExtenderSample/dtd/dad.dtd"
<DAD>
<validation>NO</validation>
<Xcollection>
<SQL_stmt>SELECT p.projno,p.projname,e.empno,e.firstnme,e.lastname
FROM
db2admin.project p, db2admin.employee e, db2admin.emp_act ea WHERE
p.projno
= ea.projno AND e.empno = ea.empno ORDER BY projname,
lastname</SQL_stmt>
<prolog>?xml version="1.0"?</prolog>
<doctype>!DOCTYPE projectstaff SYSTEM "projectstaff.dtd"</doctype>
<root_node>
<element_node name="projectstaff">
<element_node name="project" multi_occurrence="NO">
<attribute_node name="projno">
<column name="projno" />
</attribute_node>
<element_node name="projectname">
<text_node>
<column name="projname" />
</text_node>
</element_node>
</element_node>
<element_node name="employee">
<attribute_node name="empno">
<column name="empno" />
</attribute_node>
<element_node name="firstname">
<text_node>
<column name="firstnme" />
</text_node>
</element_node>
<element_node name="lastname">
<text_node>
<column name="lastname" />
</text_node>
</element_node>
</element_node>
</element_node>
</root_node>
</Xcollection>
</DAD>
The problem seams to be in the line with
"<validation>NO</validation>".
I do not understand what the problem is, because every thing is like
in the tutorials.
I'm happy of every hint from your side.
Thanks
Silke