DB2 equivalent of Oracle DBMS_LOB.SUBSTR etc
How about DBMS_LOB.SUBSTR, introduced in Db2 for LUW 9.7 as part of the Oracle compatibility feature?
If you are migrating from Oracle consider reading about that feature and how to use it, it might save you some effort.
Plain old SUBSTR will work as well.