Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2013 @ 10:26:25 GMT

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

Mr Anonymous was right : because I hadn't prefixed OREPLACE with the correct owner, it wasn't picking up the proper function.

As it happens, I've recoded it anyway - using string concatenation - but nice to know anyway, so thank you.

So, moral of the story is, if you're going to use these Oracle style Functions, prefix with TD_SYSFNLIB.

------------------------------------------------------------------------

Actually, this all comes about because I'm constructing some Dynamic SQL, incorporate the new V14 function REGEXP_SPLIT_TO_TABLE (err, should say TD_SYSFNLIB.REGEXP_SPLIT_TO_TABLE!)

This is an amazing Function, as it allows you to, amongst other applications, to split Text strings into rows of data. ?This opens up a whole new world with using Stored Procedures; basically it means you can take in a Value string through one Interface variable, split the Value string into separate rows of Column values (perhaps a Volatile Table), then use that VT to Join to a Fact Table.

If anyone wants to do this very thing and would appreciate some ideas, by all means let me know.

Regards

David Clough

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