ELSEIF L_DATATYPE='MES_DATA_KEY_T.ID1' THEN
SELECT A.`ID1`,A.`ID2`,A.`ID3`,A.`ID4`,A.`ID5`
INTO l_real,L_ID2,L_ID3,L_ID4,L_ID5 FROM
sfc.MES_DATA_KEY_T A WHERE a.`SN`=L_SN LIMIT 1;
IF(stopflag=0)THEN
if(L_ID2 in ('Y','N') and L_ID3 in ('Y','N') and L_ID4 in ('Y','N')
and L_ID5 in ('Y','N') )then
SET COMMAND1=concat('02:01,',L_SN,',',L_real,',',L_ID2,',',L_ID3,',',L_ID4,',',L_ID5);
end if;
end if;