The DSTDTA command uses the internal API’s from a wide range of communications applications to distribute native IBM i data to remote nodes in your network. It can convert your data in a range of formats before transmission.
Remote nodes do NOT have to be IBM i or AS/400 – For example, the DSTDTA *FTP command generates an Internet Ready FTP stream, which can distribute your data direct to any platform that supports the FTP protocol.
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.
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.