« Return to Thread: Isssues Running .sql from SQL Task of ANT

Isssues Running .sql from SQL Task of ANT

by Kothari, Shivani :: Rate this Message:

Reply to Author | View in Thread



Hi,

I am executing .sql which has procedure with ${@colindex.0} . This .sql
is executed from SQL Task through ANT scripts.  This .sql file having
procedure is runnin properly form sql server studio.


Statements in SQL procedure :
SET @PLOT_LINK =
'openForm("ESD_ADM032_FRM_AUTO_ROUTING&look_up=true",${@colindex.0},810,
375, "auto", false );'
REPLACE (@PLOT_LINK, '${@colindex.0}', CAST(a.row_id AS nvarchar)) AS
plot_link

Error while executing through ANT
[sql] com.inet.tds.ap: Unknown escape sequence '{ colindex.0}'

Let me know what should be done?
Thanks


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

 « Return to Thread: Isssues Running .sql from SQL Task of ANT