#
# Testing zipped XML tables
#
CREATE TABLE t1 (
ISBN CHAR(13) NOT NULL FIELD_FORMAT='@',
LANG CHAR(2) NOT NULL FIELD_FORMAT='@',
SUBJECT CHAR(12) NOT NULL FIELD_FORMAT='@',
AUTHOR_FIRSTNAME CHAR(15) NOT NULL FIELD_FORMAT='AUTHOR/FIRSTNAME',
AUTHOR_LASTNAME CHAR(8) NOT NULL FIELD_FORMAT='AUTHOR/LASTNAME',
TRANSLATOR_PREFIX CHAR(24) DEFAULT NULL FIELD_FORMAT='TRANSLATOR/@PREFIX',
TRANSLATOR_FIRSTNAME CHAR(6) DEFAULT NULL FIELD_FORMAT='TRANSLATOR/FIRSTNAME',
TRANSLATOR_LASTNAME CHAR(6) DEFAULT NULL FIELD_FORMAT='TRANSLATOR/LASTNAME',
TITLE CHAR(30) NOT NULL,
PUBLISHER_NAME CHAR(15) NOT NULL FIELD_FORMAT='PUBLISHER/NAME',
PUBLISHER_PLACE CHAR(5) NOT NULL FIELD_FORMAT='PUBLISHER/PLACE',
DATEPUB CHAR(4) NOT NULL
) ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xsample2.zip' ZIPPED=YES
OPTION_LIST='entry=xsample2.xml,load=xsample2.xml,rownode=BOOK,xmlsup=domdoc,expand=1,mulnode=AUTHOR';
SELECT * FROM t1;
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	Jean-Christophe
AUTHOR_LASTNAME	Bernadac
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	Construire une application XML
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	François
AUTHOR_LASTNAME	Knab
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	Construire une application XML
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782840825685
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	William J.
AUTHOR_LASTNAME	Pardi
TRANSLATOR_PREFIX	adapté de l'anglais par
TRANSLATOR_FIRSTNAME	James
TRANSLATOR_LASTNAME	Guerin
TITLE	XML en Action
PUBLISHER_NAME	Microsoft Press
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782212090529
LANG	fr
SUBJECT	général
AUTHOR_FIRSTNAME	Alain
AUTHOR_LASTNAME	Michard
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	XML, Langage et Applications
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	2003
CREATE TABLE t2
ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xsample2.zip' ZIPPED=YES
OPTION_LIST='xmlsup=domdoc';
SELECT * FROM t2;
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR	Jean-Christophe Bernadac
TRANSLATOR	NULL
TITLE	Construire une application XML
PUBLISHER	Eyrolles Paris
DATEPUB	1999
ISBN	9782840825685
LANG	fr
SUBJECT	applications
AUTHOR	William J. Pardi
TRANSLATOR	James Guerin
TITLE	XML en Action
PUBLISHER	Microsoft Press Paris
DATEPUB	1999
ISBN	9782212090529
LANG	fr
SUBJECT	général
AUTHOR	Alain Michard
TRANSLATOR	NULL
TITLE	XML, Langage et Applications
PUBLISHER	Eyrolles Paris
DATEPUB	2003
DROP TABLE t1,t2;