Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2001 @ 03:35:35 GMT


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


Subj:   Re: Vartext and instr
 
From:   James Judge

Specifying "vartext" assumes a field delimiter between fields. If this is true then this could be a little easier. Thinking that you should be able to redefine the last VARCHAR FIELD with additional FIELD stmts for each different value. Also assuming that each different value has some value type header in variable data. If so you could have an APPLY for each case pointing to the different UPSERT label(s) for each type of field data. Haven't tried this, so this is just an educated guess on my part.



     
  <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: 15 Jun 2023