Archives of the TeradataForum

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

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

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>>