XinYu_RZMES/.svn/pristine/ea/ea299df0b7bc6b3a750e70475ae9e57fc25a43c8.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">

	<query id="NIG060100_TC_SEND" desc="  " fetchSize="10">
		<![CDATA[
			  
      SELECT  SEQ_NO                                           
             ,MSG_FLAG                 
             ,TC_ID                                                        
             ,PLAN_CHARGE_NO                                                     
             ,STL_GRD                                                         
             ,PREV_CHARGE_WGT                                                
             ,CAST_CHARGE_SEQ                                            
             ,CAST_EDT_CHARGE_CNT    
       FROM TBG06_L2_SEND  
      WHERE MSG_FLAG = 'N' 				  
        ]]>
	</query> 
	<query id="NIG060100_TC_SEND.update" desc=" " fetchSize="10">
		<![CDATA[	
			update TBG03_LADLE_PROG set 
				MSG_FLAG = 'C' 
					
			where SEQ_NO=?	
		]]>
	</query>  
	<query id="NIG060100_L2_CHEM_RST.update" desc=" " fetchSize="10">
        <![CDATA[   
			UPDATE TBG06_L2_CHEM_RESULT SET
				MSG_FLAG = 'C'
			WHERE ROWID IN (SELECT RID FROM(
				SELECT ROWID RID, ROW_NUMBER() OVER(ORDER BY TRAN_DTIME)
				FROM TBG06_L2_CHEM_RESULT
				WHERE MSG_FLAG = 'N'
				AND ROWNUM < ?))
        ]]>
    </query>  
	
    
</queryMap>