Forum Stats

  • 3,826,761 Users
  • 2,260,705 Discussions
  • 7,897,072 Comments

Discussions

SQLcl 20.2 places two blank lines at top of CSV file

Jayson
Jayson Member Posts: 10 Blue Ribbon
edited Sep 14, 2020 12:36PM in SQLcl

Hi folks,

I'm finding a strange issue in which SQLcl 20.2 in explicably places two blank lines at the top of any CSV file I create using SET SQLFORMAT CSV / SPOOL myfile.csv.

Here is a simple set of commands that produce the behavior:

SET ECHO OFF

SET SQLFORMAT CSV

SPOOL myfile.csv

SELECT * FROM SOME_TABLE;

EXIT

Using identical commands doesn't do this in SQLcl 18.2 or 17.3.

This is running from the command line on Red Hat Enterprise Linux 7.8.

Am I missing something or doing something wrong without realizing it? Thanks for any help anyone can give.

OverlordBR

Answers