Re: CHKDIR command

[Stephen Richter <stephenrichter@xxxxxxxxx>]

On Mon, Mar 16, 2026 at 4:53 PM Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> To reply to Stephen's question - ways other than CPYTOIMPF to write to
> CSV files - generate_spreadsheet function can process the CSV option.



ok, good to know:

select
       SYSTOOLS.GENERATE_SPREADSHEET(
         PATH_NAME => '/home/shopmigr/test',
         SPREADSHEET_QUERY  => 'SELECT * from shopmigr/qsqlsrc',
         SPREADSHEET_TYPE   => 'csv',
         COLUMN_HEADINGS    => 'LABEL')
from    sysibm/sysdummy1

SELECT char(line,256) FROM TABLE(QSYS2.IFS_READ_UTF8(
         PATH_NAME => '/home/shopmigr/test.csv'))