× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



This still seems arbitrary and unfriendly to me; I seem to remember from my
own testing that you can't run any of the services statements using the
data transfer plug in
it ought to be dead simple to run any random SQL statement - including SQL
Service statements - and have it create a .csv file

I've been following this thread as I still would like to be able to execute
SQL statements by putting them in a source file and then running a plug-in
to produce a csv.
Every solution I've seen so far (and I could well be missing something)
requires me to create a temporary file, or a stored procedure or has
restrictions on the SQL statements that can be run.

On Thu, Sep 20, 2018 at 11:20 AM B. Dietz <bdietz400@xxxxxxxxx> wrote:

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

--
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




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.