[
https://issues.apache.org/jira/browse/TRAFODION-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16136208#comment-16136208
]
ASF GitHub Bot commented on TRAFODION-2703:
-------------------------------------------
GitHub user liuyu000 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1215
Cherry-pick changes of [TRAFODION-2703] & [TRAFODION-2710] to 2.2
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/liuyu000/incubator-trafodion
cherrypickaltercolumn
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1215.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1215
----
commit ef73b7719c746bc721587f2b4b4a032d71d03c65
Author: liu.yu <[email protected]>
Date: 2017-08-15T04:12:48Z
cherry-pick altercolumn
----
> 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)
