Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: OREPLACE
 
From:   David Clough

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