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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
