What's the difference between REGEXP_SUBSTR and REGEXP_EXTRACT?
They are both the same function but one was specifically designed for IBM PureData System for Analytics, which is the regexp_extract() function. The other function REGEXP_SUBSTR() is for DB2 only and doesn't exist on PureData System for Analytics.
Use the one that correlates to whichever system you're working in (seems like DB2).