Demand for: statement-level triggers (after the for statement), after all the data into should be executed only once

 ALTER TRIGGER "AC_sendshipper" after  INSERT
    ORDER 4 ON "DBA"."act_recv_line"
      REFERENCING NEW AS new_act_recv_line old as old_act_recv_line
    FOR EACH STATEMENT   
    BEGIN
        declare @html_result long varchar;
        declare @mailid long varchar;
        declare @name long  varchar;
        declare @trans_no long varchar;
    select Distinct customer.e_mail,customer.short_name,shipper.trans_no into @mailid,@name,@trans_no from
    (select * from new_act_recv_line
    EXCEPT
    select * from old_act_recv_line)a,
     act_recv_line,shipper,customer where
             a.trans_no=act_recv_line.trans_no and a.line_no=act_recv_line.line_no
       and shipper.trans_no=act_recv_line.shipper_no and shipper.customer_id=customer.customer_id;
    END

ALTER TRIGGER "AC_sendshipper" after INSERT
ON "DBA"."act_recv_line"
 REFERENCING NEW AS new_act_recv_line 
FOR EACH STATEMENT
BEGIN
    declare @html_result long varchar;
    declare @mailid long varchar;
    declare @name long  varchar;
    declare @trans_no long varchar;
select Distinct customer.e_mail,customer.short_name,shipper.trans_no into @mailid,@name,@trans_no from
dba.shipper,dba.customer,dba.act_recv_line where 
    new_act_recv_line.trans_no=act_recv_line.trans_no and 
    new_act_recv_line.line_no=act_recv_line.line_no and  
         act_recv_line.shipper_no=shipper.trans_no     and 
          customer.customer_id=shipper.customer_id ;

create table a_table (
   trans_no varchar(64),
   part_id varchar(64),

 );

create table b_table (
   trans_no varchar(64),
   part_id varchar(64),
);

insert into b_table values ('FH0001', 900);
insert into b_table values ('FH0003', 900);
insert into b_table values ('FH0003', 100);
insert into b_table values ('FH0003', 200);
commit;

insert into a_table values (trans_no,part_id,) select trans_no,part_id from test where trans_no='FH0003')

USES the results of trigger to send an E-mail to me,
FH0003   900
FH0003   100
FH0003   200

ALTER TRIGGER "a_table" after INSERT order 4
ON "DBA"."act_recv_line"
 REFERENCING NEW AS new_a_table

BEGIN
    declare @html_result long varchar;
     --get result html
select xmlelement(name "html",    
           xmlelement (name "head",    
               xmlelement(name "title", 'shipper_notif'),    
               xmlelement(name "META", xmlattributes('Content-Type' as "http-equiv" , 'text/html;charset=GBK' as "content"))    
        ),    
           (xmlelement (name "body",      
            xmlelement(name "table", xmlattributes('1' as "border"),  
             xmlelement(name "thead",  
                  xmlelement(name "tr",    
               xmlelement(name "th",  'trans_no),    
                 xmlelement(name "th", 'quantity)
              )    
               ),    
                 xmlelement(name "tbody",    
                  xmlagg( xmlelement (name "tr",    
                       xmlelement(name "td", a_table.trans_no),    
                     xmlelement(name "td", a_table.quantity)

                     ))))))) into @html_result from dba.shn where new_a_table.trans_no=a_table.trans_no ;
--send mail
  call xp_startsmtp(  smtp_sender = '1310636398@qq.com', smtp_server='smtp.qq.com', smtp_port='25',  
 timeout=240, smtp_auth_username='1310636398', smtp_auth_password='password');  
     call xp_sendmail( recipient=test@gmail.com,
                        subject='DEAR Recently, we send you product as follows the arrival of the goods, please find the logistics situation, thank you',  
                       "message"=@html_result,content_type = 'text/html');  
     call xp_stopsmtp( );  
END