Re: sql to output row as csv string

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

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