Executing multiple .sql in one Transaction

["Brill, C" <C....@t-systems.com>]

I'm trying to execute multiple sql-files within the sql-task in one transaction.
that means a rollback should be done if one of these files doesn't work.
for example the stored procedures test1.sql and test2.sql are fine and test3.sql crashes.
in that case test1 and test2 should not be in the database.

<sql driver="com.informix.jdbc.IfxDriver"
  url="jdbc:informix-sqli://***:1551/*:*"
  userid="symosyad" password="***" onerror="stop" print="true" delimiter="§"
  keepformat="true" autocommit="off">
  <classpath>
    <pathelement location="${name.dir.jdbc}" />
    <pathelement path="${classpath}" />
  </classpath>
  <fileset dir="${name.dir.delivery}/${name.label/${name.dir.vob.root}/DB/symosy_net/procedures" includes="*.sql" />
</sql>

could you please tell me how to do that?

Thanks
Christoph

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org