Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Loading XML files into Teradata
 
From:   David Clough

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', CREATE_XML('< ?xml version="1.0"
     encoding="UTF-8"? >
     
     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 : < ?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) ?


Regards

David Clough
Senior BI Database Designer
BI Competency Centre



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020