August 30, 2004 at 2:59 pm
I have SP that is executed using an osql statement. The result of the sp is captured into a fixed width file. I do not need headers or footers counts. I have managed to avoid this by using -h-1 parameters. The whole thing works great except, between every batch of output, there is an empty line.
How can get rid of this empty line in the between recordsets.
Thank you in advance.
August 31, 2004 at 6:36 am
I had a discussion with some folks who were needing this as well. I believe to solve their problem, they ran the output through another program to look for the spaces and other junk at the end and beginning. If I am not mistaken, then used a perl script.
I never found a good answer to that other than what they had done. Perhaps you can perform whatever function you are doing by an alternative means? Scheduled sp dump to text file?
regards,
Michael
August 31, 2004 at 6:58 am
Thank you Michael for you input.
Seems like nobody has a straight solution for this.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply