Re: Exporting DB2/400 records . . .

I had considered mentioning Excel and either this approach or the CA addin - but since the question was about "exporting", I didn't go there - if Excel is pulling it, one might say that is not an export.

But it depends on what James meant by exporting. I took it to mean an action performed on the IBM i.

Cheers
Vern

On 6/5/2015 5:44 AM, paultherrien@xxxxxxxxxxxxxxxxxx wrote:

I like to use Excel and an ODBC connection to IBM i.
>From Excel (2007) choose: >Data>From other sources>From Microsoft Query
Select 'Databases' tab
Select your IBM I ODBC connection.
Sign on to IBM I if needed.
In MS Query you can scroll through the library and file list to select your file(s), but I prefer to close the file list and instead use the SQL tool.
You specify files in SQL as libname.filename.
It is a full function SQL that does joins and unions and most anything else you need.
I usually build my sql statement on the I and then cut and paste to the MS Query sql window.
Then you only need to change the library/filename to library.filename.

Also I Series Navigator SQL client works well with the 'Allow Copy Data' option.


Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Thursday, June 04, 2015 9:23 PM
To: Midrange Systems Technical Discussion
Subject: Re: Exporting DB2/400 records . . .

Excel has a data import data that gets installed if you install Excel after Client Access that allows you to query an iSeries table and pull what you need into Excel.

http://www.code400.com/forum/showthread.php/539-Add-in-for-Excel-to-pull-data-from-AS400

On Thu, Jun 4, 2015 at 5:27 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Lots of options in addition to this one, which works OK if all you
need is a basic data dump and you don't care what Excel does to things
like leading zeroes.

Another free one is a utility called SQL2POI or SQL2JXL - they're a
little long in the tooth - both put the data into XLS files - the
latter will never be updated to write XLSX that I know of, the former,
you might be able to modify if you know some Java.

Almost any of the reporting products have this as an option - SEQUEL,
IBM Web Query, NGS-IQ, BCD's Clover, etc.

RJS has a couple products that can do this.

There's something at easy400.net that is free or minimal annual
donation to the cause there.

HTH
Vern

On 6/4/2015 6:14 PM, Diego Kesselman wrote:

Try with CPYTOIMPF and create a .CSV on the IFS, or use the Excel plugin .

El 04/06/2015 a las 06:01 p.m., James H. H. Lampert escribi :

Question:

How would you go about exporting records from a database file into
something a spreadsheet could deal with?

--
JHHL

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.