Liu Yu created TRAFODION-2703:
---------------------------------
Summary: Add *Load XML Files* for ODB User Guide
Key: TRAFODION-2703
URL: https://issues.apache.org/jira/browse/TRAFODION-2703
Project: Apache Trafodion
Issue Type: Documentation
Reporter: Liu Yu
Assignee: Liu Yu
suppose you have below table:
./odb64luo -x "create table testxmlload(id int, name char(20))"
then you can load xml file like this:
-bash-4.1$ cat test.xml
<?xml version="1.0" encoding="UTF-8"?>
<data>
<id>1</id>
<name>hello</name>
</data>
by running a command like this:
./odb64luo -l src=test.xml:tgt=testxmlload:xmltag=data
you can also load xml file like this:
-bash-4.1$ cat test.xml
<?xml version="1.0" encoding="UTF-8"?>
<data id="1" name="hello"></data>
by running a command like this:
./odb64luo -l src=test.xml:tgt=testxmlload:xmltag=+data
if you only want to see what will be load, you can run a command like this:
./odb64luo -l src=test.xml:tgt=testxmlload:xmltag=data:xmldump
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
