iSQL against Sybase resultset to file

[SilvaMuppet]

Hi
This may be more an iSQL query rather than a Sybase one (Sybase being the database am using).

Am trying to get the result set to a file in the exact format my SQL Select command is getting it as.

For some reason though the resulting file has a few oddities.

Firstly there is a whitespace at the start of each row and 2 whitespaces at the end of each row.

and

secondly the file seems to start with a row of whitespaces and then a row of dashes (--------).

Any idea how to get rid of these?

FYI
am using the following command
isql -S SERVER -P password -U username -n -w 130 -c . -i RequestFile.sql -o ResultFile.dat

with RequestFile.sql containing the SQL SELECT along with set NOCOUNT ON

Cheers

Silv

 

[micha123]

Sorry, dude, you can't get rid of the additional characters added by the isql tool.
I had this problem and I solve it by removing them with another program (such as VB).


"A long life is when each day is full and every hour wide!"
(A Jewish Mentor)
M.