Archives of the TeradataForum
Message Posted: Thu, 07 Nov 2013 @ 15:11:30 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|