Archives of the TeradataForum
Message Posted: Sun, 28 Jul 2002 @ 11:55:31 GMT
It's weekend now, so more time for tests ;-))
ins switcher('one-minus'); *** Insert completed. One row added. *** Total elapsed time was 1 second. =1 *** Failure 2662 SUBSTR: string subscript out of bounds. Statement# 1, Info =0 *** Total elapsed time was 1 second.
And i'd like to have an extended one for replacing more than 2 times ;-)
I think we'll have to wait for NCR to provide more string functions or for UDFs in R5.1 :-( I once tried it with a Stored Procedure and with a cross join, but was too slow for a large dataset.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|