Hello All,
I have data in a well-formed xml file. I’d like to use the db2 load command load the data into a table. Would someone guide me on how to code the Load command to accomplish this task? Example:
Target Person Table: All columns are varchar 254
Thanks in advance for any help
I have data in a well-formed xml file. I’d like to use the db2 load command load the data into a table. Would someone guide me on how to code the Load command to accomplish this task? Example:
Code:
<Person gender="Male">
<Name>
<Last>Cool</Last>
<First>Joe</First>
</Name>
<Confidential>
<Age unit="years">5</Age>
<Birthdate>2002-03-16</Birthdate>
<SS>111-22-3333</SS>
</Confidential>
<Address>5224 Rose St. San Jose, CA 95123</Address>
</Person>
Code:
LAST_NAME FIRST_NAME AGE BIRTHDATE ADDRESS Cool Joe 5 2002-03-16 5224 Rose St...
Thanks in advance for any help