This section demonstrates inserting XML data into the table.
isql -Sase1501sunbox -Usa -P -w2048 -Dxml_db
insert address_tbl values
('<?xml version="1.0"
encoding="UTF-8"?>
<fulldoc>
<address>
<street>mailstop
101</street>
<city>CONCORD</city>
<state>MA</state>
<country>USA</country>
</address>
<filepath>
/sy/ase1501sunbox/EFTS-15_0/collections
/made_using_mkvdk
/xml_data
/row1_well_formed.xml</filepath>
</fulldoc>
')
go
(1 row affected)
insert address_tbl values
('<?xml version="1.0"
encoding="UTF-8"?>
<fulldoc>
<address>
<street>building 6</street>
<city>BALTIMORE</city>
<state>MD</state>
<country>USA</country>
</address>
<filepath>
/sy/ase1501sunbox/EFTS-
15_0/collections
/made_using_mkvdk/xml_data/row2_well_formed.xml
</filepath>
</fulldoc>
')
go
(1 row affected)
quit
