[ https://issues.apache.org/jira/browse/TRAFODION-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16124847#comment-16124847 ]
ASF GitHub Bot commented on TRAFODION-2703: ------------------------------------------- GitHub user liuyu000 opened a pull request: https://github.com/apache/incubator-trafodion/pull/1202 [TRAFODION-2703] Add *Load XML Files* for ODB User Guide Changes proposed in this pull request: 1. Add **Load XML Files** You can merge this pull request into a Git repository by running: $ git pull https://github.com/liuyu000/incubator-trafodion loadxmlfiles Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-trafodion/pull/1202.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 #1202 ---- commit d19c364e05ec69505d73ffafdfffb7136ef9a760 Author: liu.yu <yu....@esgyn.cn> Date: 2017-08-13T08:06:25Z add Load XML Files ---- > 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)