Archives of the TeradataForum
Message Posted: Wed, 13 May 2015 @ 15:17:13 GMT
Is anyone loading XML files into Teradata and, if so, is this using a trickle feed (don't know if TPump can do it) or using Bteq ?
If the input file of XML messages is quite large (like a transactional canonical file) how would you handle that ?
I've played about with the example supplied in the XML manual :
CREATE TABLE customer ( customerID INTEGER, customerName VARCHAR(256), customerXML XML ) PRIMARY INDEX (customerID); INSERT INTO customer (1, 'John Hancock', CREATE_XML('< ?xml version="1.0" encoding="UTF-8"? >
... but when I do this :
sel * from customer;
all I get is
1 John Hancock
Do you think it's got something to do with the first line : < ?xml version="1.0" encoding="UTF-8"? >
(I've switched off Allow use of Named Parameters In Queries, as this was asking for a value for the question mark)
Has anyone got a simple example that does work (through Sql Assistant) ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|