Archives of the TeradataForum

Message Posted: Wed, 13 May 2015 @ 15:17:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

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', CREATEXML('
     
     John Hancock
     
100 1st Street, San Francisco, CA 94118
 (858)555-1234 (858)555-9876
     (858)555-9999 John@somecompany.com
      Mary Jane (987)654-3210
     Some company, 2467 Pioneer Road, San Francisco, CA - 94117 434.99
     32.55 467.54 10 F54709
     Motorola S10-HD Bluetooth Stereo Headphones 29.50
     295.00   1 Z19743
     Motorola Milestone XT800 Cell Phone 139.99
     139.99   '));

... 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 :

(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) ?

Regards

David Clough
Senior BI Database Designer
BI Competency Centre

	<Prev	Next>		<<First	<Prev	Next>	Last>>