on 2017 Nov 22 10:46 AM
I am outputting a list of insert commands from MS SQL Server using SQLCMD to a flat file.
When I try and run this file in DBISQL (ASA 9) I am being told there is an illegal character '/n' on line 2.
I have tried all sorts of commands in SQLCMD, but I keep getting this error. Is there anything I can do to remove this character in DBISQL?
When the SQL file is viewed in Interactive SQL there are no problems with the file.
Request clarification before answering.
There is most likely a syntax error that is being poorly diagnosed; e.g., the SQL parser has run off the end of the SQL code before realizing there is something wrong.
The bottom line is, there is no invalid /n character... look for some other problem.
One technique is to delete chunks of text until the code works, then look at the most recently-deleted chunk to find the problem.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you add a semicolon at the end of each statement or put a 'go' on a new line between statements?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
50 | |
9 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.