Archives of the TeradataForum
Message Posted: Tue, 06 Jul 2004 @ 09:24:10 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|