Re: sql to output row as csv string

Have you tried with something like:

CREATE TABLE MYLIB1/MYFILE1 AS (SELECT * FROM XYZ/ABC123)

and then

CPYTOIMPF  FROMFILE(MYLIB1/MYFILE1 ) TOSTMF('/home/USER1/MYFILE1.csv'  ) MBROPT(*REPLACE) STMFCCSID(*PCASCII) RCDDLM(*CRLF) DATFMT(*YYMD) TIMFMT(*JIS) ADDCOLNAM(*SQL)

??


Regards

Diego E. KESSELMAN

El 19/9/18 a las 14:32, Jeff Crosby escribió:

I note that you did the search including the term "sql2csv" meaning you
knew sql2csv existed. If Jay didn't know that, he would not necessarily
come up with it as a search term.

Just sayin'

On Wed, Sep 19, 2018 at 3:25 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

Something like SQL2CSV?
http://lmgtfy.com/?q=sql2csv+and+%22IBM+i%22


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Jay Vaughn" <jeffersonvaughn@xxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 09/19/2018 03:21 PM
Subject: sql to output row as csv string
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Been searching for a way to output a csv string from an sql select
statement and have found nothing good.

i simply want to take the row selected and output the column values such
as...
"data1", "data2", "data3", etc...

I do NOT want to have to implicitly name and concat each column together
in
the statement... I'll need a function to do that for me.

Is there anything avail to do this?

Jay
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD