Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Users List" <user@ant.apache.org>
content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: Ant SQL Task can define stored procedure?
Date: Fri, 2 Apr 2004 14:31:37 -0800
Message-ID: <200404022231.i32MVjxC002737@barrierb241.nike.com>
Thread-Topic: Ant SQL Task can define stored procedure?
Thread-Index: AcQY/g0Vyt1ZiEkWSo2QoVKTyzRWuAAA+0lg
From: "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com>
To: "Ant Users List" <user@ant.apache.org>
Content-Type: text/plain;
 charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

> -----Original Message-----
> From: jax@purematrix.com [mailto:jax@purematrix.com]
> Sent: Friday, April 02, 2004 2:01 PM
> To: Ant Users List
> Subject: Re: Ant SQL Task can define stored procedure?
>=20
>=20
> "Anderson, Rob (Global Trade)" wrote:
>=20
> > Check out keepformat attribute of the sql task.
>=20
> I am already using that one, thanks!
>=20
> > Also, the escapeprocessing attribute may need to be set.
>=20
> Ah, didn't catch that one.
>=20
> > I found these two attributes to be necessary when loading=20
> packages and procedures into a database with ant. If you are=20
> running serveral sql statements and loading a procedure, all=20
> via a single sql file, you might need to specify=20
> delimeter=3D"row" and organize your statements and procedure in=20
> the file accordingly.
>=20
> Thanks for the tips ...
>=20
> Incidentally,  REM comments don't seem to work within the=20
> stored procedure even with keepformat ...

With keepformat=3D"true" I think it is up to your database to decide =
what is or isn't a comment.

-Rob Anderson=20


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