Difference between revisions of "Importing and Exporting Data"

Revision as of 10:40, 14 January 2010

Navigational Data Access

SQL

The into, save as and to clauses supported by the SQL select statement offer a wide range of export formats for the selected rows.

The create table statement allows a new table to be created from metadata stored in an XML file and the data to be optionally loaded.

create table <table>
  [from] xml <.xml file> [load]

Example

create table customer2;
  from xml cust.xml load

The SQL insert statement supports the import of data from an XML file:

insert into <table> from [xml] <xml filename>

Example

insert into products;
  from xml prices.xml

select <column-definition> from <table-definition> to file <filename>

Examples

select * from shippers to file shiptxt

select <column-definition> from <table-definition> into xml <xml filename>

or

select <column-definition> from <table-definition> save as xml <xml filename>

Examples

select employeeid, lastname, firstname;
  from employees save as xml emp

select <column-definition> from <table-definition> into html <html filename>

select <column-definition> from <table-definition> into json <filename>

@@ Line 5: / Line 5: @@
 SQL
+* CREATE TABLE
 * INSERT
 * SELECT
 The ''into'', ''save as'' and ''to'' clauses supported by the [[SQL SELECT|SQL select]] statement offer a wide range of export formats for the selected rows.
 ===Import From Text Files===
 ===Import from XML===
-The [[SQL INSERT|SQL insert]] statement allows data to be imported from an XML file:
+The [[CREATE TABLE|create table]] statement allows a new table to be created from metadata stored in an XML file and the data to be optionally loaded.
+<pre>
+create table <table>
+  [from] xml <.xml file> [load]
+</pre>
+'''Example'''
+<code lang="recital">
+create table customer2;
+  from xml cust.xml load
+</code>
+The [[SQL INSERT|SQL insert]] statement supports the import of data from an XML file:
 <pre>