try
    execute from ds
    with #sql{
      delete from PAYMENT
    };
onException(ex SQLException)
    if(ex.SQLState != "02000")  // sqlState is five digits
        throw ex;
    end
end

<?xml version="1.0" encoding="UTF-8"?>
<egl:deployment xmlns:egl="http://www.eclipse.org/xmlns/edt/deployment/1.0">
  <bindings>
    <binding name="BAI" type="edt.binding.sql" useURI="false">
      <parameters>
        <parameter name="dbms" value="DB2 for i5/OS"/>
        <parameter name="sqlID" value="user"/>
        <parameter name="sqlPassword" value="xxxxxxxx"/>
        <parameter name="jarList" value="C:\IBM\jt400.jar"/>
        <parameter name="sqlJDBCDriverClass" value="com.ibm.as400.access.AS400JDBCDriver"/>
        <parameter name="sqlDB" value="jdbc:as400:www.busapp.com;prompt=false;libraries=BNTEST"/>
      </parameters>
    </binding>
  </bindings>
</egl:deployment>

<?xml version="1.0" encoding="UTF-8"?>
<egl:deployment xmlns:egl="http://www.eclipse.org/xmlns/edt/deployment/1.0">
  <bindings>
    <binding name="BAI" type="edt.binding.sql" useURI="false">
      <parameters>
        <parameter name="dbms" value="DB2 for i5/OS"/>
        <parameter name="sqlID" value="user"/>
        <parameter name="sqlPassword" value="xxxxxxxx"/>
        <parameter name="jarList" value="C:\IBM\jt400.jar"/>
        <parameter name="sqlJDBCDriverClass" value="com.ibm.as400.access.AS400JDBCDriver"/>
        <parameter name="sqlDB" value="jdbc:as400:www.busapp.com;prompt=false;libraries=BNTEST"/>
      </parameters>
    </binding>
  </bindings>
  <egl:target.project name="PaymentWeb"/>
</egl:deployment>

	dbms="DB2"
	sqlValidationConnectionURL="jdbc:as400:www.busapp.com;prompt=false;libraries=BNTEMP"
	sqlJDBCDriverClass="com.ibm.as400.access.AS400JDBCDriver"
	sqlDB="jdbc:as400:www.busapp.com;prompt=false;libraries=BNTEMP"
	sqlID="xxxxxx" sqlPassword="crypto:0ac28eeb7eab02de">

	<parameter name="dbms" value="DB2 for i5/OS"/>
        	<parameter name="sqlID" value="xxxxxx"/>
        	<parameter name="sqlPassword" value="xxxxxxxx"/>
        	<parameter name="jarList" value="C:\IBM\jt400.jar"/>
        	<parameter name="sqlJDBCDriverClass" value="com.ibm.as400.access.AS400JDBCDriver"/>
<parameter name="sqlDB" value="jdbc:as400:S10746FP;prompt=false;libraries=BNTEST;toolbox trace=all;trace=true"/>

// Check if systemName refers to the system we are running on.
private static boolean isSystemNameLocal(String systemName) {
    if (systemName.equalsIgnoreCase("localhost")) {
        if (Trace.traceOn_)
            Trace.log(Trace.DIAGNOSTIC,
                    "System name is 'localhost'.");
        return true;
    } else {
        try {
            InetAddress localInet = InetAddress.getLocalHost();
            InetAddress[] remoteInet = InetAddress
                    .getAllByName(systemName);

            for (int i = 0; i < remoteInet.length; ++i) {
                if (Trace.traceOn_)
                    Trace.log(Trace.DIAGNOSTIC,
                            "Comparing local address " + localInet
                                    + " to " + remoteInet[i]);
                if (localInet.equals(remoteInet[i])) {
                    return true;
                }
            }
        } catch (UnknownHostException e) {
            Trace.log(Trace.ERROR,
                      "Error retrieving host address information:",
                      e);
        }
    }
    if (Trace.traceOn_)
        Trace.log(Trace.DIAGNOSTIC, "System name is not local.");
    return false;
}