Antwort: Access into MVS DB2 using DBI or ???

From: Manfred Beilfuss (Manfred.Beilfuss_at_dvag.com)
Date: 03/31/04 

To: "Wagner, David --- Senior Programmer Analyst --- WGO" <David.Wagner@freight.fedex.com>
Date: Wed, 31 Mar 2004 08:27:10 +0200

Hi,

to access any DB2-Server anywhere from perl you need first the dbi , then
you need a dbd e.g. dbd::db2 or dbd::odbc depending on how you intend to
connect to db2 and whether you want to connect only to db2 or to different
dbms'es using perl.

if you have at least one of these installed you should be able to connect
via perl to all cataloged db2-databases, which are cataloged on the machine
where your perl-script run's, no matter where they reside, e.g. on NT , AIX
, Linux , Mainframe or AS/400! But allways under the before mentioned
condition that you should have acces to them using the normal db2- and/or
odbc-utilities.

Mit freundlichen Gruessen / Best regards

Manfred Beilfuss

Deutsche Vermögensberatung AG
IT_Systemmanagement , DBA
Münchenerstr. 1
60329 Frankfurt
Tel.: +49 (69) 2384 - 639
Fax: +49 (69) 2384 - 329
Mailto:Manfred.Beilfuss@dvag.com

                                                                                                                      
                    "Wagner, David ---
                    Senior Programmer An: <dbi-users@perl.org>
                    Analyst --- WGO" Kopie:
                    <David.Wagner@freight. Thema: Access into MVS DB2 using DBI or ???
                    fedex.com>
                                                                                                                      
                    31.03.2004 01:34
                                                                                                                      
                                                                                                                      

           Uuncertain where to start or really what to use to try and see
if I can do this? I searched under Activestate and found a large group of
DBI modules.

           Do I just need DBI? Or are there other modules which I work with
DBI?

           I am on XP Professional running service pack 1 and Perl AS 5.8.2
build 808.

      Any questions and/or problems, please let me know.

      Thanks.

Wags ;)
Int: 9-8-002-2224
Ext: 408-323-4225x2224

**********************************************************
This message contains information that is confidential
and proprietary to FedEx Freight or its affiliates.
It is intended only for the recipient named and for
the express purpose(s) described therein.
Any other use is prohibited.
****************************************************************

Relevant Pages

  • Re: Perl 6 DBI API ideas
    ... Though I didn't raise my hand when you asked for people to contribute to a DBI module for Perl 6, I've had some ideas that I thought about sharing. ... I would also love to see some standardization on the driver names ("mysql" when it's normally written ... DBI is supposed to be query language agnostic, even if SQL is the most commonly used group of languages, and if a user can declare this explicitly, it saves the driver from having to guess what they were given, which might be ambiguous. ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Problem of DBI build
    ... I installed Oracle Application Server 4.0.8.2 included perl module. ... I need to installe DBI and DBD::Oracle module. ... You can install them any time after installing the DBI. ... line 318: error 1705: Function prototypes are an ANSI feature. ...
    (perl.dbi.users)
  • Re: use of DBI; I am getting multiple error messages mixed in with the correct output.
    ... T> expected a mature library like DBI to behave like this. ... I learned plenty about the perl side of things from her posts. ... closely represent the SQL idea of a null. ... trivially easy to perform bulk loads using the DB's particular ...
    (comp.lang.perl.misc)
  • Re: DBD::Informix and SIGBUS in perl
    ... use DBI; ... > My program is a CGI script in perl, which provides web-access to a database ... assigned to a DBD::Informix database handle. ... > LANGUAGE (unset) ...
    (perl.dbi.users)