Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 10 May 2016 @ 22:44:27 GMT


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


Subj:   SOAP xml shredding process
 
From:   Shetty, Vinay

Hi,

We are trying to shred SOAP xml file to teradata relational table on teradata 14.10. Please find a sample xml file below. Currently we are shredding normal xml document using shred batch procedure / XML_TABLE function.

Any help would be appreciated..


Thanks,

Vinay Umesh Shetty
Associate Lead Technical Consultant
Global Delivery Center


--------------------------------------

     
        
           en_GB
           
              su
              gw
           
        
        
           
              
                 
                    

     c7eb4590f66611e58487005056842ab3
                       
                          
                             PRV
                             
                                CompPlus
                                Comp
                             
                          
                          
                             CHU
                             
                                CompPlus
                                Comp
                             
                          
                       
                       
                          USWI
                          2016-03-30T12:07:12
                          
                             
                                PRV
                                0
                             
                             
                                CHU
                                0
                             
                             
                                PRV
                                0
                             
                             
                                CHU
                                0
                             
                          
                          2016-04-04
                          
                             Mr
                             Avinash
                             
                             Singh
                             M
                             1979-11-28
                             single
                             EMPF
                             C820
                             190
                             
                                20 Louisa Square
                                
                                
                                ROSEWELL
                                EH24 9BB
                                GB
                             
                             1234567890

     [email protected]
                          

     
                          
                             
                                
                                   1
                                   
                                      Mr
                                      Avinash
                                      
                                      Singh
                                      M

     1979-11-28

     single

     EMPF
                                      C820

     190
                                      
                                         20 Louisa Square
                                         
                                         
                                         ROSEWELL
                                         EH24 9BB
                                         GB
                                      
                                      
                                      
                                   
                                   

     true
                                      
                                      FLUK
                                      5
                                      0

     U
                                   
                                   false
                                   false

     1979-11-28
                                   1

     na

     
                                   0

     true
                                   tpv
                                   0
                                   0

     true
                                
                             
                             
                                

     2016-03-30T12:07:12
                                   ND58KXA
                                   141.00
                                   4
                                   1995
                                   1940
                                   1421
                                   4520
                                   1817
                                   14
                                   SALN
                                   BMW
                                   318D EDITION ES
                                   3 SERIES
                                   2008
                                   DIESEL
                                   MANUAL
                                   1940
                                   
                                   5
                                   WBAVG12060A391201
                                   150
                                   7000
                                   true
                                   EH24 9BB

     DRW
                                    
                                   HOME
                                   9000
                                   

     2014-02-01

     POLH

     LessSixMonths
                                   SDPEC

     false
                                   
                                      0
                                      tpv

     

     2016-03-30T12:07:12
                                   
                                   
                                      

     COMP
                                         
                                         
                                            

     

     

     

     
                                            
                                         
                                      
                                   
                                   
                                      
                                         1
                                         true
                                      
                                   
                                
                             
                          
                          
                       
                    
                 
              
           
        
     


     
  <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