Re: sql to output row as csv string

I came in a little late in the loop - sorry

If you are OK with open source and RPG - Then take a look at this sample
done with the noxDB project:

Producing a CSV from a SQL is 100% dynamic in noxDB - Look at this sample:
https://github.com/sitemule/noxDB/blob/master/examples/JSONSQL03B.RPGLE

Project home:
https://github.com/sitemule/noxDB


On Thu, Sep 20, 2018 at 7:09 AM Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

On Wed, Sep 19, 2018 at 10:38 PM Evan Harris <auctionitis@xxxxxxxxx>
wrote:

I tried Ublu for some stuff and maybe I will try again. I really needed a
lot more meaningful examples to help me on the long slow climb to
productivity.

There are a lot of examples in the two .html docs and in the examples and
extensions directories.
I'm working on creating more install technology so Ublu gets set up in a
convenient fashion automatically.

I managed to get some data from a command back onto a PC but it was

quite a

lot of work at the time.

Yes, it certainly can be some work to get used to it. When I code in Ublu,
I always have to use the manual :)

I think there needs to be quite a few usable, practical examples as the
language is quite arcane from my point of view, though I like the idea
behind it.

It's arcane because it "just grew" as I responded to customer needs
in-house. There was no plan other than "fast" :)

In any case, the example you want is examples/dbexample.ublu which is
mentioned and reproduced in the rather longish documentation to the db
command

It demonstrates a function to CSV a file

Here basically is the model to csv a file.

db -to @myconnection -dbtype as400 -connect *MYSYS MYLIB MYUID MYPASSWORD*
@myconnection -csv *MYFILE*

*.. or if you want the output of csv'in MYFILE to go to a local text file
instead of scrolling by on the screen*

@myconnection -to myfile.csv -csv
*MYFILE*

It's fair to say that I did not do enough of either to get over the

initial

hump to making it seem a bit more natural.

Well, if you do ever get around, come chat at IBMiOSS on Ryver ... I tend
to hang out there during the day.

--
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you received
this communication in error, please contact the sender and delete/destroy
all copies of this communication immediately.
--
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