RE: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Borrill, Chris
#x27;Ant Users List' Subject: RE: Writing a DB2 Java Stored Procedure compiling task I would think you could deploy a package or stored procedure with the sql task, but it does not appear to be the case. I get an error message that says: BUILD FAILED file:C:/cygwin/home/rhanders

RE: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Anderson, Rob H - VSCM
sqlplus to load the code as follows: sqlplus user/pass@database @package_body.sql -Original Message- From: Antoine Levy-Lambert [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 9:24 AM To: Ant Users List Subject: Re: Writing a DB2 Java Stored Procedure compiling task Deploying

Re: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Antoine Levy-Lambert
Deploying stored proc should be possible with the ant SQL task. Antoine - Original Message - From: "Anderson, Rob H - VSCM" <[EMAIL PROTECTED]> To: "'Ant Users List'" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 6:00 PM Subject: RE: Writing

RE: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Anderson, Rob H - VSCM
:44 AM To: Ant Users List Subject: RE: Writing a DB2 Java Stored Procedure compiling task Hi Kola, I'm aware of the sql task but what I meant was a task to compile a SQLJ JAVA STORED PROCEDURE Here is an example Java stored proc: package javastoredproc; #sql iterator MyIter ( int, int ); p

RE: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Hien Q. Nguyen
de for the book for example of ??? http://www.amazon.com/exec/obidos/tg/detail/-/047120708X/104-2318894-5881526 ?vi=glance KolaF > -Original Message- > From: "Antoine Levy-Lambert" > @MCGRAW-HILL > Sent: Tuesday, January 07, 2003 8:11 AM > To: Ant Users List

RE: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Fajimolu, Kola
t; Subject: Re: Writing a DB2 Java Stored Procedure compiling task > > > There is a SQL task in ant, which requires a JDBC driver. If you are using > a > JDBC driver for DB2, and > the JDBC driver supports the creation of stored procedures, you can create > your st

Re: Writing a DB2 Java Stored Procedure compiling task

2003-01-07 Thread Antoine Levy-Lambert
There is a SQL task in ant, which requires a JDBC driver. If you are using a JDBC driver for DB2, and the JDBC driver supports the creation of stored procedures, you can create your stored procs with ant. Antoine - Original Message - From: "Hien Q. Nguyen" <[EMAIL PROTECTED]> To: <[EMAIL PR