BTEQ -- Enter your DBC/SQL request or BTEQ command: with recursive temp_table (subpart, rest) as ( select substring(subpart from 1 for position(',' in subpart)-1), substring(subpart from position(',' in subpart)+1 for char(subpart)) || ',' from my_data union all select substring(rest from 1 for position(',' in rest)-1), substring(rest from position(',' in rest)+1 for char(rest)) from temp_table where char(rest) > 1) select subpart from temp_table;
*** Query completed. 4 rows found. One column returned. *** Total elapsed time was 1 second.
But of course! This was just a sample showing how to do it. It is just a query and you can make it a sub query of something more complicated or insert the results into another table. That is up to you.