Here we use a script file that do everything.
You have to remember using the set term statement before sending any create
or alter procedure or trigger.

Valdir.

----- Original Message -----
From: "afoc_nz" <AFoC_nz@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, May 07, 2003 10:19 PM
Subject: [ib-support] Updating databases


> I am creating an application (in Java) and need a method of updating
> the database (i.e. changing table structure add /removing triggers etc).
>
> Most of this sort of stuff is simple to manage through JDBC with
> simple SQL statements. What has got me stuck is how to create
> triggers/procedures from within the application. Every thing I've
> tried so far has resulted in "token unknown" errors.
>
> Has anyone been able to do this sort of thing? If so, how???
>
> Before someone says to dive into something like the isql tool and do
> the modifications there, that is the sort of solution I am trying to
> avoid.
>
> Any ideas would be apreciated.
>
> Gavin.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>