empty line

new problem comes out..

unix script calls sql script and save the output into a file. but now there are many empty lines in the output file.

first line is empty and follow by 13 rows of data and another empty line and data and so on..

how can I fix that?

thanks

You could use the command 'set pages 1000' in your sql statement. This should remove the blank lines.

doesnt work.

It's set pagesize 0

excellent.

You r my hero.

many thanks