Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Jul 2004 @ 09:24:10 GMT


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


Subj:   Re: String variable concatenation in a Stored Procedure
 
From:   Kepinski, Marek

Dave,

thanks for the explanation. Now I understand the reason but I would actually go for choice #2. In my case I have a variable of 64000 character length, I set it to 'AAA' string, then I concatenate with 'BBB' string and I get an error having only (potentially) 6 characters in the string. And I'm not using concatenation in a SQL statement but I use SET command in a stored procedure. It seems that such a simple task (concatenating few short strings into one longer) will turn out to be quite complex. I understand that choice #1 is quick and safe but it limits seriously possible code in stored procedures. I think that all other database providers (like ORACLE or Microsoft) have selected #2 - they gave more responsibility to developers :-).


Anyway, thanks for your tests.

Mark



     
  <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: 23 Jun 2019