XinYu_RZMES/.svn/pristine/b5/b5f86080c9b0665b8b9ddcb3edb26e2769115da5.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH050010_01.select" desc="" fetchSize="10">
		<![CDATA[
			select (YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ) YARD_ADDR
					,coil_no 
			from tbh05_coil_yard 
			where yard_clf LIKE  ?||'%'
			--and   coil_no is not null
		]]>
	</query> 
	<query id="UIH050010.INIT_PARAM_01" desc="UIH050010 INIT_PARAM" fetchSize="10">
		<![CDATA[
      select distinct substr(yard_clf,0,3) LABEL,  
              substr(yard_clf,0,3) VALUE 
                from tbh05_coil_yard 
                 where yard_clf like 'C1%' 
                    or yard_clf like 'C2%' 
                    or yard_clf like 'C3%'
                    or yard_clf like 'C4%'
		]]>
	</query>
	<query id="UIH050010_02.select" desc="init " fetchSize="10">
		<![CDATA[
			select distinct yard_clf LABEL,yard_clf VALUE from tbh05_coil_yard where substr(yard_clf,0,3) = ?
		]]>
	</query>
	<query id="UIH050010_01.update" desc=" " fetchSize="10">
		<![CDATA[
			update tbh05_coil_yard 
			set coil_no = ? 
			where YARD_CLF||STEP_CLF||STORELAY||STORE_SEQ = ?
		]]>
	</query>
</queryMap>