An example of a with RECURSIVE application in Teradata

Requirement: Splits a string that uses a delimiter connection for a fixed number of digits, such as splitting a record 215|482|850|870 into 215,482,850,870 four records
Result: The WITH RECURSIVE statement is capable of implementing this function and is tested as follows:
CREATE TABLE Dwsdata.gift_info (
gf_id varchar (50),
Channels varchar (100)
);

SELECT * from Dwsdata.gift_info;
GF_ID Channels
10710701010201002 215|482|850|870

with RECURSIVE temp_table (gf_id,channels) as
(
Select
 gf_id
 ,trim (Channels)
from Dwsdata.gift_info
where channels<> '
UNION ALL
select 
 gf_id
 ,substr ( channels,5)
from  temp_table aa
where   char (aa.channels) <>3
)
Select
  TRIM (gf_id)
 ,substr (channels,1,3)
from   temp_table
;
Result:
gf_id             channels
10710701010201002 215
10710701010201002 482
10710701010201002 850
10710701010201002  870