Problem with dynamic sql

[Hemant . Kamatgi]

Hi All,

I'm getting an exception when trying to execute a dynamic sql in iBATIS. The 
query is below:

      <select id="selectPatterns" parameterClass="searchCriteriaVO" 
resultMap="patternAttributeResult">
            select ptrn_i,ptrn_n from ${schema}.eprs_ptrn <isNotNull prepend=" 
where " property="status"> ptrn_statc_c = #status# </isNotNull>
      </select>
The database is db2. Please lemme know what I'm doing wrong in the sql.

Regards
Hemant