I am trying to read XML data in an embedded SQL, any suggestions, on how to use DTD

Hi

In the webfocus reporting server help -> adapters -> Adaptor for XML :
You have the following section which explains it:
"Accessing XML Documents From a Relational DBMS XML Data Type"

I think you'll need also a license for the XML adaptor , you should ask your local IBI office