Difference between revisions of "Importing and Exporting Data"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Importing and Exporting Data) |
Yvonnemilne (Talk | contribs) (→Importing and Exporting Data) |
||
| Line 1: | Line 1: | ||
==Importing and Exporting Data== | ==Importing and Exporting Data== | ||
| − | The Navigational Data Access commands [[APPEND FROM|append from]] and [[COPY|copy to]] can be used to | + | The Navigational Data Access commands [[APPEND FROM|append from]] and [[COPY|copy to]] can respectively be used to import and export Recital data. |
The SQL statements [[CREATE TABLE|create table]] and [[INSERT|insert]] allow data to be imported from XML files and 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. | The SQL statements [[CREATE TABLE|create table]] and [[INSERT|insert]] allow data to be imported from XML files and 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. | ||
Revision as of 11:01, 14 January 2010
Contents
Importing and Exporting Data
The Navigational Data Access commands append from and copy to can respectively be used to import and export Recital data.
The SQL statements create table and insert allow data to be imported from XML files and the into, save as and to clauses supported by the SQL select statement offer a wide range of export formats for the selected rows.
Import From Text Files
Import from XML
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
Import Live Data using SQL Connectivity Functions
Export to Text Files
select <column-definition> from <table-definition> to file <filename>
Examples
select * from shippers to file shiptxt
Export to XML
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
Export to HTML
select <column-definition> from <table-definition> into html <html filename>
Export to JSON
select <column-definition> from <table-definition> into json <filename>
