1)hbm.xml:

<sql-query name="queryname">
<return alias="tblname" class="tblclass"/>
DELETE FROM PHAIREP WHERE (phairep.AIALCD = 'C')
</sql-query>

2) PersistenceManager
//DELETE
String hql = string;
Query query = (Query) session.getNamedQuery(hql);
Query query2 = session.createSQLQuery(query.getQueryString());
query2.executeUpdate();


This does not work. It says:
update is only possible in HQL.

cant we write update, delete queries in this format in out hbm.xml