AS/400 DSTDTA now handles SQL STRINGS for selecting data

Ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet?

Now you can… all from one IBMi command without having to write any CL code to do it.

I added this new function to the PROJEX400 - Distribute Data command last night – so it can now take a bite of selected data using SQL and send it as a TXT, CSV, XML or PDF as EMAIL.

Huge timesaver for me and has been on my wish-list for ages.

Example:

DSTDTA FILE(CSP20) DATA(*SQL) DATASQL('select * from CSP20 where CONO20 = ''??'' and PSTD20 between 1061001 and 1101022') METHOD(*EMAIL) TYPE(*XML) EMAIL(*prompt) INSERT(*LINK) SUBJECT('Here is the spreadsheet for data range 10/01/2010 thru 10/22/2010') IFSDIR(*USER) IFSDOC('CSP20 Spreadsheet') STAMP(*YES)

Creates a spreadsheet in the IFS called /home/nlitten/csp20spreadsheet[10-26-2010_08.34.06].csv and emailed a link to me.

It's a thing of beauty. Hope it helps somebody.

This interesting article was originally published at: http://www.projex.com

An interesting and funny video on the IBM AS/400





You will find information and training on the IBM iSeries (ex AS(400) at:

==> http://www.Datamission.co.uk

==> http://as400softwaredownloads.com/

IBM i on POWER7

I report an interesting news by IBM.

This year IBM has announced the first of the POWER7 processor-based systems that compared to POWER6, deliver huge improvements in performance and energy efficiency at a greatly improved price. Simply put, this is one of those rare breakthrough announcements that delivers a massive leap in system technology. And, yes, IBM i is right at the centre of the POWER7 action!

They have also announced a new release of IBM i (formerly known as OS/400). This new release contains a wide range of important new and enhanced capabilities.

With this clearly defined roadmaps for POWER processors and the IBM i operating environment, IBM's commitment to i clients is solid and unchanged. They are making substantial investments in the future of i as an important, strategic element in the IBM product portfolio.

You will find useful information on the IBM iSeries (AS400) on our website Datamission Ltd.

You will find useful utilities for the IBM iSeries (AS400) on our blog AS400SoftwareDownloads