Thank you very much for your help.
-Original Message-
From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 19, 2008 12:30 PM
To: Ant Users List
Subject: RE: ant sql call stored procedure
It looks like the sql you are trying to execute is vendor specific
specific statements that may work fine in the vendor supplied client.
-Rob Anderson
-Original Message-
From: Chaohua Wang [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 9:23 AM
To: Ant Users List; [EMAIL PROTECTED]
Subject: RE: ant sql call stored procedure
Hi,
Thank you for your
:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 9:23 AM
To: Ant Users List; [EMAIL PROTECTED]
Subject: RE: ant sql call stored procedure
Hi,
Thank you for your suggestion. But I used UTF-8,
It changed a little bit, still can not get through.
[sql] Executing file: C:\workspace\Canoo\billPay
When executing sql using Ant, you are using a jdbc connection, not the sql
client that is available from the database vendor. Some of the features that
are database specific are not available when using a jdbc connection.
If you find that the Ant sql task does not support your vendor specific sq
essage-
From: Olivier Gies [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 8:02 PM
To: Ant Users List
Subject: Re: ant sql call stored procedure
Hi,
It looks like the SQL file is encoded in some version of Unicode (UTF-8
or Unicode/UTF-16 ?), with each character using 2 bytes, and your
NTIFIER ON
GO
CREATE PROCEDURE [dbo].[uspSelectCount]
AS
BEGIN
SET NOCOUNT ON;
Select count(*)
from dbo.Payments_Staging;
End
-Original Message-
From: Olivier Gies [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 8:02 PM
To: Ant Users List
Subject: Re: ant sql call stored proc
Hi,
It looks like the SQL file is encoded in some version of Unicode (UTF-8
or Unicode/UTF-16 ?), with each character using 2 bytes, and your
task is loading it in ISO-8599 by default.
You should verify your source file format (using 'file' command on *nix
systems, or any editing tool in Wi
Can you please attach sql file with the mail
- Original Message
From: Steve Loughran <[EMAIL PROTECTED]>
To: Ant Users List
Sent: Friday, March 14, 2008 3:47:20 PM
Subject: Re: ant sql call stored procedure
Chaohua Wang wrote:
> Hi folks,
>
>
> I am using ant sq
Chaohua Wang wrote:
Hi folks,
I am using ant sql to call a stored procedure of Ms Sql server
I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. But when I am using ant sql to call the file uspSelectCount.sql that is located with the build fil
