[
https://issues.apache.org/jira/browse/TRAFODION-2703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16126366#comment-16126366
]
ASF GitHub Bot commented on TRAFODION-2703:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1202#discussion_r133055159
--- Diff: docs/odb_user/src/asciidoc/_chapters/load.adoc ---
@@ -637,6 +637,64 @@ odb considers the string following the “em” character
as the path of the fil
NOTE: odb does not load rows where the size of the input file is greater
than the target database column.
+[[load_xml_files]]
+== Load XML Files
+Trafodion odb supports loading xml files into tables, the key construct
for xml files can be an element or an attribute.
--- End diff --
XML is an acronym (eXtensible Markup Language), and so should be
capitalized when it appears in prose. If it appears as a file extension (for
example, xyz.xml) or as part of a code example then lower case is fine. Also,
this appears to be a run-on sentence. Better perhaps would be "Trafodion odb
supports loading XML files into tables. The key construct for XML files may be
an element or an attribute."
> 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)
