SELECT SENTENCE THAT LOCK THE INSERT WHEN THERE IS ATRIGGER ON THE WRKCASH TABLE.

SELECT ATTIPO,ATCICL,ATFUNC,'---',-1,COUNT(ATTIPO) AS CANTIDAD FROM WRKCASH,ICSRCNTO WHERE ATTIPO=RTRCTO AND (attras='T' OR ATTRAS='F') AND ATSIST='2095' AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))  GROUP BY ATTIPO,ATCICL,ATFUNC HAVING COUNT(ATTIPO)<1000 UNION SELECT ATTIPO,ATCICL,ATFUNC,ATZONA,-1,COUNT(ATTIPO) FROM WRKCASH,  ( SELECT ATSIST AS SIST,ATTIPO AS TIPO,ATCICL AS CICL,ATFUNC AS FUNC FROM WRKCASH,ICSRCNTO    WHERE ATTIPO=RTRCTO AND (attras='T' OR ATTRAS='F') AND ATSIST='2095' AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))    GROUP BY ATSIST,ATTIPO,ATCICL,ATFUNC HAVING COUNT(ATTIPO)>=1000 ) AS B WHERE (attras='T' OR ATTRAS='F') AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))  AND ATSIST=SIST AND ATTIPO=TIPO AND ATCICL=CICL AND ATFUNC=FUNC GROUP BY ATTIPO,ATCICL,ATFUNC,ATZONA HAVING COUNT(ATTIPO)<1000 UNION SELECT ATTIPO,ATCICL,ATFUNC,ATZONA,ATFILA,COUNT(ATTIPO) FROM WRKCASH,  ( SELECT ATSIST AS SIST,ATTIPO AS TIPO,ATCICL AS CICL,ATFUNC AS FUNC,ATZONA AS ZONA FROM WRKCASH,     ( SELECT ATSIST AS SIST,ATTIPO AS TIPO,ATCICL AS CICL,ATFUNC AS FUNC FROM WRKCASH,ICSRCNTO        WHERE ATTIPO=RTRCTO AND (attras='T' OR ATTRAS='F') AND ATSIST='2095' AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))         GROUP BY ATSIST,ATTIPO,ATCICL,ATFUNC HAVING COUNT(ATTIPO)>=1000 ) AS B     WHERE (attras='T' OR ATTRAS='F') AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))        AND ATSIST=SIST AND ATTIPO=TIPO AND ATCICL=CICL AND ATFUNC=FUNC     GROUP BY ATSIST,ATTIPO,ATCICL,ATFUNC,ATZONA HAVING COUNT(ATTIPO)>=1000) AS C  WHERE (attras='T' OR ATTRAS='F') AND  (ATDATE<'2005-10-10' OR (ATDATE='2005-10-10' AND ATHORA<='09:32:26'))     AND ATSIST=SIST AND ATTIPO=TIPO AND ATCICL=CICL AND ATFUNC=FUNC AND ATZONA=ZONA  GROUP BY ATTIPO,ATCICL,ATFUNC,ATZONA,ATFILA  ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC;





INSERT SENTENCE THAT GETS LOCKED.

INSERT INTO WRKCASH (ATTIPO,ATUSER,ATDIST,ATDSPV,ATCICL,ATFUNC,ATZONA,ATFILA,ATBUTA,ATPREU,ATPRUS,ATDTOE,ATPORE,ATDTOV,ATPORV,ATVARD,ATIDVD,ATPVAD,ATVVDI,ATIMPT,ATPAGO,ATDATE,ATHORA,ATANUL,ATTRAS,ATRIMP,ATAUDT,ATFLG1,ATFLG2,ATFLG3,ATFLG4,ATUSIM,ATDAIM,ATCOTA,ATCOPR,ATTINV,ATIDTK,ATUSED,ATRFVT,ATCONT,ATTCOA,ATTARJ,ATCANAL,ATMPAGO,ATVALC,ATVALE,ATSIST) VALUES ('AE','ICSOFT    ','ICS','ANGELXP','9999999','MANOL32','AA1',4,18,4000,NULL,'99',0,'99',0,'11','I',0,60,4000,'001',CURDATE(),CURTIME(),' ',' ',0,'B',' ',' ',' ',' ','ICSOFT    ',CURDATE(),'99','9','99','010000753894',0,318545,'          ','99','999','TAQ','001',0,0,'2095');