DBI on IBM AS/400 DB2

Hi,

On paper it is theoretically possible to install Perl on an
IBM System i
box (aka AS400) running i5/OS (aka OS400) using some AIX
shim. Apparently
it's also possible to connect to IBM's DB2 for i5/OS using
the DB2
driver for the DBI.

As I don't happen to have an IBM System i box to test any of
this on
does anyone know how easy this is to do? Apparently Zend
makes PHP
work on AS400 and that will be the solution a friend will
use unless
he can get a Perl based solution.

Has anyone any experience they wish to share...?

Thanks in advance.

-- 
Adam Trickett
Overton, HANTS, UK

Linux? Il y a moins bien, mais c'est plus cher.
	-- anon

Not of direct technical help, but at times like these, I
like to ask :
'What would Buffy Do?'.

HTH, M.

On 15/01/2008, A J Trickett <adamiredale.net> wrote:
>
> Hi,
>
> On paper it is theoretically possible to install Perl
on an IBM System i
> box (aka AS400) running i5/OS (aka OS400) using some
AIX shim. Apparently
> it's also possible to connect to IBM's DB2 for i5/OS
using the DB2
> driver for the DBI.
>
> As I don't happen to have an IBM System i box to test
any of this on
> does anyone know how easy this is to do? Apparently
Zend makes PHP
> work on AS400 and that will be the solution a friend
will use unless
> he can get a Perl based solution.
>
> Has anyone any experience they wish to share...?
>
> Thanks in advance.
>
> --
> Adam Trickett
> Overton, HANTS, UK
>
> Linux? Il y a moins bien, mais c'est plus cher.
>         -- anon
>

Buffy would give me a lap dance, that's what Buffy would
do!

On Jan 15, 2008 10:54 AM, Martin Robertson
<mansionhouseprojectsgooglemail.com> wrote:
> Not of direct technical help, but at times like these,
I like to ask :
> 'What would Buffy Do?'.
>
> HTH, M.
>
>
> On 15/01/2008, A J Trickett <adamiredale.net> wrote:
> >
> > Hi,
> >
> > On paper it is theoretically possible to install
Perl on an IBM System i
> > box (aka AS400) running i5/OS (aka OS400) using
some AIX shim. Apparently
> > it's also possible to connect to IBM's DB2 for
i5/OS using the DB2
> > driver for the DBI.
> >
> > As I don't happen to have an IBM System i box to
test any of this on
> > does anyone know how easy this is to do?
Apparently Zend makes PHP
> > work on AS400 and that will be the solution a
friend will use unless
> > he can get a Perl based solution.
> >
> > Has anyone any experience they wish to share...?
> >
> > Thanks in advance.
> >
> > --
> > Adam Trickett
> > Overton, HANTS, UK
> >
> > Linux? Il y a moins bien, mais c'est plus cher.
> >         -- anon
> >
>



-- 
jeffa

On Tue, Jan 15, 2008 at 11:38:25AM +0000, A J Trickett
wrote:
> Hi,
> 
> On paper it is theoretically possible to install Perl
on an IBM System i
> box (aka AS400) running i5/OS (aka OS400) using some
AIX shim. Apparently
> it's also possible to connect to IBM's DB2 for i5/OS
using the DB2
> driver for the DBI.

http://search.cpan.org/dist
/DBIx-Class/lib/DBIx/Class/Storage/DBI/ODBC/DB2_400_SQL.pm

Dunno if the stuff in here helps. Author might be able to
shed some light
though as you might guess from the class name he uses ODBC
rather than the
DB2 driver.

-- 
      Matt S Trout       Need help with your Catalyst or
DBIx::Class project?
   Technical Director                    http://www.shado
wcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or
deployment platform?
http://chainsawblues.vo
x.com/            http://www.shadow
cat.co.uk/servers/

On Wednesday 16 Jan 2008, Matt S Trout wrote:
> On Tue, Jan 15, 2008 at 11:38:25AM +0000, A J Trickett
wrote:
> > Hi,
> >
> > On paper it is theoretically possible to install
Perl on an IBM System i
> > box (aka AS400) running i5/OS (aka OS400) using
some AIX shim. Apparently
> > it's also possible to connect to IBM's DB2 for
i5/OS using the DB2
> > driver for the DBI.
>
> http://search.cpan.org/dist/DBIx-Clas
s/lib/DBIx/Class/Storage/DBI/ODBC/DB2_
>400_SQL.pm
>
> Dunno if the stuff in here helps. Author might be able
to shed some light
> though as you might guess from the class name he uses
ODBC rather than the
> DB2 driver.

Thanks I'll forward to my colleague. I don't think he cares
what Buffy would 
do...

-- 
Adam Trickett
Overton, HANTS, UK

The animals are not as stupid as one thinks - they have
neither
doctors nor lawyers.
    -- L Doquier