How do I go about substringing a value with a delimiter, a la UNSTRING Fieldname
Delimited by 'x'
End-String
in Datamigrator?

I have tried doing the following in SQL and copying it to my DM Code, but the DM engine tells me that LOCATE is unsupported.

SELECT DISTINCT
TRIM (SUBSTR (T2.MS_NAME,LOCATE (',' , T2.MS_NAME )+1 )) AS SQLDEF01
FROM
(dwdstg_glmoacti T1 INNER JOIN dwdstg_ismmastr T2
ON
T1.TR_EMPLOYEE = T2.MS_CMPY )

This message has been edited. Last edited by: T.Peters,

1) Check the syntax for POSIT, not LOCATE.
2) Do it in WebFPOCUS, not SQL.

Doug, you are the man, thanks!

You're Welcome...

Shame on me, I typoed WebFOCUS above as "WebFPOCUS"