Posted by yanakal on 09/30/32 11:27

Hi,
I'm using isql to query data and output the same to a flat file.
The isql has the following command options ' -h-1 -w500 -n -b -s"" '.
In the SQL_CODE, the first two lines before the select statement are
use dbname
set nocount on
go
When I run this, an additional blank line is put into the output file.
Actually, there are two lines after the last result set in the output
file. This file is being fed into another system and the blank line is
causing validation issues.
How can I supress this blank line?

This script is run from windows and the isql is called from a bat
script.
Batch script ...
==========================================================
.....
isql -Uuserid -Ppassword -Sserver -i"%SQL_CODE%" -h-1 -w500 -n -b -s""
>>"%OUT_FILE%"
IF ERRORLEVEL 0 SET RC=0
IF ERRORLEVEL 1 exit 4
==========================================================
SQL code ...
==========================================================
use punclaim
set NOCOUNT ON
GO
select * from XYZ;
GO
==========================================================

Your help is greatly appreciated.
Yash

• Next in forum: Re: Connecting Trace info to blocked users?
• Prev in forum: Error : Difference of two datetime columns caused overflow at runtime.
• Thread view: iSQL - Blank line at the end of the iSql output file

[Reply to this message]