Re: sql to output row as csv string

On Wed, Sep 19, 2018 at 4:40 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

you can call an external rpg from the sql stored procedure, that can then
execute the cl command... but wayyyy too much engineering for what I'm
trying to accomplish...

And what ARE you trying to accomplish?

It actually wasn't clear to me whether you wanted a CSV string for
each row, or for the whole result set. Or are your queries going to be
formulated such that at most one row is ever selected?

And in any case, why a string? (As opposed to depositing directly into
a stream file, say.)

In another post, you said:

thx - not looking for a utility, but rather an IBM supplied function i may
be overlooking.
I could easily write my own udf but prefer something out of the box.

there must not be anything... ??

The short answer to that is: Correct, there isn't any IBM-supplied
function for this.

I daresay there probably aren't even many, if any, third-party
functions to do (exactly) what you're asking. CSV is not a common
format to want, unless you are ultimately writing a stream file.

John Y.