Clemente Biondo wrote:
ROTFL
This is not exactly the kind of feedback I was hoping for but thanks anyway
:-)
Seriously, this driver can be useful to people whose work involves (like me)
data reporting from mainframe systems.
Imagine this scenario: your boss asks you to produce a report that
require manipulation of data from different sources, one of which is a DB2
database
located on a mainframe.This scenario is very common in banking, finance and
insurance environment.
Now, the traditional way of doing this require:
-) writing a JCL and one or more Cobol programs on the mainframe side
to extract the raw information needed from the mainframe.
-) writing a program on the pc side to acquire the data from the mainframe
,combine it with other data sources, and finally format the report.
Based on my experience, using this driver and some other perl modules like
Spreadsheet::WriteExcel
you can dramatically reduce development time from weeks to days.
Don't feel lonesome...DBD::Chart gets lots of funny looks, too,
but also still seems to attract a lot of positive attention.
FWIW, many years ago I used a similar (albeit inverted) solution for
file transfers (upload/download files to/from a database for which I had drivers
when ftp wasn't an option).
E.g., DBD::iPod is still a personal favorite. Perl is great, but
sometimes good ol' SQL rules!
To reiterate (with apologies to the late Chairman of the Board),
"The more I do DBD's, the more DBD's I do".
(I spose I should throw in a plug for SQL::Preproc...it may make
your solution even easier to use)
Dean Arnold
Presicient Corp.
