Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: OREPLACE
From:   Geoffrey Rommel

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020