there are no functions or store procedures that comes with Teradata with replace string, however you can go into Teradata.com, search for UDF, there is one UDF, (user defined function) called replace that you can use.
insert into TableA
select
csum(1,1)
, colA
, colB
from
TableB
--------------------------
that requires no sorting, no ordering, and it works fast!
Edgar
I just wanted to clarify a few issues
with my designs of a recent model that
i did, can you give me some
recommendations.
I have a 3NF marketing datamart build,
various information feeds from various
credit unions are sent, I build a
staging area to do ETL process, then do
loads to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.