[
https://issues.apache.org/jira/browse/TRAFODION-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Liu Yu resolved TRAFODION-2703.
-------------------------------
Resolution: Fixed
> 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)
