How to split a string value based on a delimiter i

Question

How do you split a string value in DB2?

For example, given the value:

CHG-FFH.

I want to split on the dash (-), which would result in two values:

CHG 
FFH. 

I tried using split function but it is not a function in DB2.

Any help will be appreciated.

Answer 1

Try this statement:

select substr(your_value, 1,3), substr(your_value, 4, 3) from your_table