Archives of the TeradataForum

Message Posted: Thu, 07 Nov 2013 @ 15:11:30 GMT

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

As you may be aware, Dave, "replace" functionality is inherently risky because the user can replace a short string with a long string, and can do that more than once. In extreme cases, you could wind up with something like this:

     oreplace('aaaaba', 'a', 'some horribly long string that will be repeated 5 times.....')

... on all AMPs ... and behold, there is a segmentation fault.

I don't know the details of the OREPLACE in R14, but it is likely that they have limited the size of the input strings and the result for just this reason.

If opening a ticket doesn't give you satisfaction, your only recourse may be to implement your own UDF that allows longer strings.

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