The DB2 dialect translates substring in HQL to substr and hides the DB2 method substring
registerFunction( "substring", new StandardSQLFunction( "substr", StandardBasicTypes.STRING ) );
See IBM documentation for valid method signatures