Problem using function GENERATE_SPREADSHEET to generate Csv file

Hi all

I'm try to use Sql function GENERATE_SPREADSHEET to create a Csv file with
this statement:



VALUES SYSTOOLS.GENERATE_SPREADSHEET(PATH_NAME => '/tmp/sch10',
LIBRARY_NAME => 'MYLIB',
FILE_NAME => 'MYFILE',
SPREADSHEET_TYPE => 'csv',
COLUMN_HEADINGS => 'LABEL');


The MYFILE was created as below



CREATE TABLE MYLIB.MYFILE (

ARCOD VARCHAR(15) NOT NULL,

SPDESC VARCHAR(8000),

SPTECN VARCHAR(8000),

PRIMARY KEY (ARCOD)



Opening the csv file created, we note that the content of spdesc and sptecn
is splitted in more rows, as if in the content of this colunms (SPDESC and
SPTECN) there was some character like CR or LF that indicate a new row; i
tried to better esplain:

suppose i have this content



ARCOD SPDESC SPTECN

001 A B C 1 2 3



In the CSV i see:

"SPCOD","SPDESC","SPTECN"

"LB609M","A

B

C



1

2

3

,"



Any suggestion to solve this problem ?



IF I CREATE XLSX file always with SYSTOOLS.GENERATE_SPREADSHEET, i have a
correct content of the two colunms SPDESC and SPTECN;



Thanks in advance

Gio