Example 1
Assume the table 'supportqueries' with columns 'LOGINID' CHAR(10); 'REQUEST' SQL_LONGVARCHAR; 'REQUESTTIME' SQL_TIMESTAMP; 'ATTACHMENT' 'SQL_FILE; 'BINARY_C' SQL_BINARY(10); DECIMAL_C SQL_DECIMAL(10, 3). The table has two records. The entire table is exported to an XML file with columns as elements. File link names are exported, temp files are built to store BLOB data, and the DTD is included. The resulting XML file follows:
<?xml version="1.0"
encoding="BIG5"?>
<!DOCTYPE WEBDB SYSTEM "Support.dtd">
<WEBDB>
<SUPPORTQUERIES>
<LOGINID>A_HOWARD </LOGINID>
<REQUEST>&BLBTMP_TXT0;</REQUEST>
<REQUESTTIME>21-09-09 12:47:05.0</REQUESTTIME>
<ATTACHMENT>&DBMAKER_FO_0;</ATTACHMENT>
<BINARY_C>10</BINARY_C>
<DECIMAL_C>10.250</DECIMAL_C>
</SUPPORTQUERIES>
<SUPPORTQUERIES>
<LOGINID>A_HOWARD </LOGINID>
<REQUEST>&BLBTMP_TXT1;</REQUEST>
<REQUESTTIME>21-09-22 10:14:21.0</REQUESTTIME>
<ATTACHMENT>&DBMAKER_FO_1;</ATTACHMENT>
<BINARY_C>20</BINARY_C>
<DECIMAL_C>13.550</DECIMAL_C>
</SUPPORTQUERIES>
</WEBDB>
The associated DTD follows:
<!ELEMENT
SUPPORTQUERIES (LOGINID, REQUEST, REQUESTTIME, ATTACHMENT, BINARY_C, DECIMAL_C)>
<!ELEMENT LOGINID (#PCDATA)>
<!ATTLIST LOGINID
TYPE CDATA #FIXED "SQL_CHAR"
NAME CDATA #FIXED "LOGINID"
LENGTH CDATA #FIXED "20"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ELEMENT REQUEST (#PCDATA)>
<!ATTLIST REQUEST
TYPE CDATA #FIXED "SQL_LONGVARCHAR"
NAME CDATA #FIXED "REQUEST"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ELEMENT REQUESTTIME (#PCDATA)>
<!ATTLIST REQUESTTIME
TYPE CDATA #FIXED "SQL_TIMESTAMP"
NAME CDATA #FIXED "REQUESTTIME"
STORAGE CDATA #FIXED "29"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ELEMENT ATTACHMENT (#PCDATA)>
<!ATTLIST ATTACHMENT
TYPE CDATA #FIXED "SQL_FILE"
NAME CDATA #FIXED "ATTACHMENT"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ELEMENT BINARY_C (#PCDATA)>
<!ATTLIST BINARY_C
TYPE CDATA #FIXED "SQL_BINARY"
NAME CDATA #FIXED "BINARY_C"
LENGTH CDATA #FIXED "10"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ELEMENT DECIMAL_C (#PCDATA)>
<!ATTLIST DECIMAL_C
TYPE CDATA #FIXED "SQL_DECIMAL"
NAME CDATA #FIXED "DECIMAL_C"
LENGTH CDATA #FIXED "(10, 3)"
ISNULL (true|false) 'true'
xml:space (default|preserve) 'preserve'
>
<!ENTITY BLBTMP_TXT0 SYSTEM "blobtmpdir0\blbtmpf0.txt">
<!ENTITY DBMAKER_FO_0 SYSTEM "C:\DBMAKER\4.0\BIN\WEBDB\FO\ZZ.GIF">
<!ENTITY BLBTMP_TXT1 SYSTEM "blobtmpdir0\blbtmpf1.txt">
<!ENTITY DBMAKER_FO_1 SYSTEM "C:\DBMAKER\4.0\BIN\WEBDB\FO\ZZ01.GIF">
<!ENTITY BLBTMP_TXT2 SYSTEM "blobtmpdir0\blbtmpf2.txt">
<!ELEMENT WEBDB (SUPPORTQUERIES*)>
Related topic: