I’m trying to use STRTOK_SPLIT_TO_TABLE in teradata to split space delimited column into multiple rows. All other column values should be repeated in the new rows. I can’t find anywhere in TD reference to accomplish this. Any thoughts?

Something like this but I need more than one column for inkey/outkey

select
d.*
from table
 (STRTOK_SPLIT_TO_TABLE('abc', 'a b', ' ') 
 RETURNS (outkey  varchar(20), tokennum integer, token varchar(20)character set unicode) ) as d 

I tried multiple attempts at adding more columns to paramters but they all cause syntax error