<statement>
                            <sql><![CDATA[
                                update d_dcd_cards set status=?, timestamp=?, date_block=? where number=?]]></sql>
                            <parameter expression="//old_d_dcd_card/status/text()" type="NUMERIC"/>
                            <parameter expression="//old_d_dcd_card/timestamp/text()" type="VARCHAR"/>
                            <parameter expression="//old_d_dcd_card/date_block/text()" type="VARCHAR"/>
                            <parameter expression="//old_d_dcd_card/number/text()" type="VARCHAR"/>
                        </statement>
                        <statement>
                            <sql><![CDATA[insert into d_dcd_cards (id_cards, id_group_cards, id_parent_cards, number, status, date_reg, date_block, flag, balance,
                    timestamp, discount, first_pay, last_pay, cardtype, active, host, receipt, last_shop)
                                        values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]]></sql>
                            <parameter expression="//new_d_dcd_card/id_cards/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/id_group_cards/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/id_parent_cards/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/number/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/status/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/date_reg/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/date_block/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/flag/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/balance/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/timestamp/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/discount/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/first_pay/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/last_pay/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/cardtype/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/active/text()" type="NUMERIC"/>
                            <parameter expression="//new_d_dcd_card/host/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/receipt/text()" type="VARCHAR"/>
                            <parameter expression="//new_d_dcd_card/last_shop/text()" type="VARCHAR"/>
                        </statement>