Re: sql to output row as csv string

I put the acsbundle.jar in the IFS and use the /plugin=download to create a CSV file into the IFS using a pre-created .dtfx data transfer definition.


http://www-01.ibm.com/support/docview.wss?uid=nas8N1020552 <http://www-01.ibm.com/support/docview.wss?uid=nas8N1020552>

you can also use the /plugin=cldownload to download a whole file or run some sql with the result into a CSV or xlsx

the below is from the getting started file:
ftp://ftp.software.ibm.com/as400/products/clientaccess/solutions/GettingStarted_en.html

9.1.17 CLDownload

/PLUGIN=cldownload /system=<system>
[/userid=<userid>]
{/hostfile=<library/filename> | /sql="statement"}
{/clientfile=<path><filename>.<extension> | /display}

/userid - user id to use when connecting to the target system
/hostfile - Source library and file on the IBM i system for the download
e.g. /hostfile=QIWS/QCUSTCDT
/sql - specify an SQL statement
e.g. /sql="select CUSNUM,LSTNAM,INIT,ZIPCOD from QIWS/QCUSTCDT"
/clientfile - Target file location for the download.
The format of this file will be determined by the specified
extension (for example, .csv .ods .xlsx .xlsx)
If the file extension is not specified or is of a type
not supported, the data will be formatted as a .csv file
/display - write the output to the terminal

On Sep 19, 2018, at 3:20 PM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

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