Online Documentation


XML

 

To connect to XML databases you need to select a folder where XML files are stored. Each XML file represents one table.

conn-xml

XML format is described using following XML file sample:

<?xml version="1.0" standalone="yes"?>

<TABLE>

       <META>

               <FIELDS>

                       <FIELD name="id" type="i4" identity="true"/>

                       <FIELD name="Name_varchar" type="varchar.255" required="true"/>

                       <FIELD name="Name_char" type="char.255"/>

                       <FIELD name="Name_decimal" type="decimal.14.2"/>

                       <FIELD name="Name_boolean" type="boolean"/>

                       <FIELD name="Name_dateTime" type="datetime"/>

                       <FIELD name="Name_date" type="date"/>

                       <FIELD name="Name_time" type="time"/>

                       <FIELD name="Name_i1" type="i1"/>

                       <FIELD name="Name_i2" type="i2"/>

                       <FIELD name="Name_i4" type="i4"/>

                       <FIELD name="Name_i8" type="i8"/>

                       <FIELD name="Name_ui1" type="ui1"/>

                       <FIELD name="Name_ui2" type="ui2"/>

                       <FIELD name="Name_ui4" type="ui4"/>

                       <FIELD name="Name_ui8" type="ui8"/>

                       <FIELD name="Name_r4" type="r4"/>

                       <FIELD name="Name_r8" type="r8"/>

                       <FIELD name="Name_binhex" type="bin.hex.5000"/>

               </FIELDS>

               <KEYS>

                       <KEY name="pk_datapack" fields="id" primary="true" unique="true"/>

               </KEYS>

               <CONSTRAINTS>

                       <CONSTRAINT name="fgn_1" type="foreign key" foreign_table="fgn_table_name" local_columns="Name_i4;Name_ui4" foreign_columns="i4;ui4" delete_rule="NO ACTION"/>

               </CONSTRAINTS>

       </META>

       <ROWS>

               <ROW id="1" Name_varchar="varchar" Name_char="char" Name_decimal="3.14e2" Name_boolean="true" Name_dateTime="2001-1-1 10:10" Name_date="2005-1-1" Name_time="23:22" Name_i1="100" Name_i2="10000" Name_i4="1000000" Name_i8="1000000000000" Name_ui1="100" Name_ui2="10000" Name_ui4="1000000" Name_ui8="100000000000" Name_r4="3.141592654" Name_r8="3.141592654" Name_binhex="70612064692073692070697A6461206D752070612064692073692070697A6461206D75"/>

       </ROWS>

</TABLE>