insert into sample_docs (name_doc, text_doc)
values ('publishers',
forxmlj('select * from pubs2..publishers
'tablename=publishers'))
insert into sample_docs (name_doc, text_doc)
values ('authors',
forxmlj('select title_id, title
type, pub_id, price,
advance, total_sales
from pubs2..authors',
'tablename=authors'))
This script
uses the forxmlj function, which is a Java-based
function that you must install before you can use. See Appendix A, “Setting up XML Services,” for instructions
on installing this function.
