RE: SQL output to csv

Thanks John Y. for the re-post >I hope I got that right<,
I plan to use the article to implement our first use of
Open Access - and get a shop utility as a bonus, and
kudos for the work of Jon Paris and Susan Gantner >

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, December 05, 2013 5:06 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL output to csv

Looks nice. So, how does that handle these column types:
CLOB
BINARY
DATALINK
I ran into some of these just last week trying to use iNav's Export.
I suppose you have to CAST, like I did when I used the export, right?


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: John Yeung <gallium.arsenide@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/04/2013 05:26 PM
Subject: Re: SQL output to csv
Sent by: midrange-l-bounces@xxxxxxxxxxxx



On Wed, Dec 4, 2013 at 4:23 PM, Gary Thompson <gthompson@xxxxxxxxxxx>
wrote:

Jon,
You got my attention also, but the link seems incomplete...
maybe you can re-post ?

http://www.ibmsystemsmag.com/ibmi/developer/rpg/Getting-a-Handle-on-RPG%E2%80%99s-Open-Access/


The tricky character in the link is one of those slanted/curved right
single-quotes (for the apostrophe in "RPG's").

Since we're mentioning alternatives, I'll bring up again
iSeriesPython. Use SQL or RLA to access your physical file, use the
built-in CSV module to write out to IFS stream file. For my taste,
using SQL in Python is not as ugly as using it in RPG, and the CSV
module not as involved as Open Access. The whole thing would look
like

import csv, db2
connection = db2.connect()
c1 = connection.cursor()
c1.execute('select * from mylib.myfile')
with open('output.csv', 'wb') as f:
writer = csv.writer(f)
for row in c1.fetchall():
writer.writerow(row)

And you're done. Eight lines for the entire program.

John