Ayntax error (Sqlcmd: Error: Syntax error at line XX near command '$' in file 'fdstore.sql’) from the SQL script generated with be-jdbcdeploy.exe when run using sqlcmd script.
Article ID: KB0094537
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
=========
Getting a syntax error (Sqlcmd: Error: Syntax error at line XX near command '$' in file 'fdstore.sql’) from the SQL script generated with be-jdbcdeploy.exe when run using sqlcmd script.
Environment:
==========
TIBCO Product name and version: TIBCO BusinessEvents (BE) 5.0.0
Operating System(s): All
Cause:
=====
Sqlcmd script is not able to handle special characters properly. Problem is specific to Microsoft’s sqlcmd script.
Resolution:
========
Use osql instead of sqlcmd script.
OR
SQL Server Management Studio tool.
Description:
=========
Getting a syntax error (Sqlcmd: Error: Syntax error at line XX near command '$' in file 'fdstore.sql’) from the SQL script generated with be-jdbcdeploy.exe when run using sqlcmd script.
Environment:
==========
TIBCO Product name and version: TIBCO BusinessEvents (BE) 5.0.0
Operating System(s): All
Cause:
=====
Sqlcmd script is not able to handle special characters properly. Problem is specific to Microsoft’s sqlcmd script.
Resolution:
========
Use osql instead of sqlcmd script.
OR
SQL Server Management Studio tool.
Issue/Introduction
Ayntax error (Sqlcmd: Error: Syntax error at line XX near command '$' in file 'fdstore.sql’) from the SQL script generated with be-jdbcdeploy.exe when run using sqlcmd script.
Feedback
Yes
No
Powered by
