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

From: Hardy Merrill (HMerrill_at_dhcr.state.ny.us)
Date: 03/31/04


Date: Wed, 31 Mar 2004 07:55:15 -0500
To: <David.Wagner@freight.fedex.com>,<dbi-users@perl.org>

You normally need DBI *and* the appropriate DBD:: module for your
particular database - in this case probably DBD::DB2. I have no
experience connecting to MVS DB2 so I can't offer any more help here.

Hardy Merrill

>>> "Wagner, David --- Senior Programmer Analyst --- WGO"
<David.Wagner@freight.fedex.com> 03/30/04 06:34PM >>>
        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: fetchrow_array performance
    ... I agree - set RasieError. ... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: Evaluated "require $database" not found.
    ... DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ...
    (perl.dbi.users)
  • Re: Cant call method "prepare" on an undefined value
    ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ... Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script. ...
    (perl.dbi.users)
  • Balasan: RE: Balasan: RE: Balasan: RE: Balasan: RE: cant execute "use $database"
    ... dictionary of the each database of my MSSQL. ... to load it -- DBI will load it for you. ... Subject: Balasan: RE: Balasan: RE: Balasan: RE: ...
    (perl.dbi.users)
  • RE: fetchrow_array performance
    ... takes a few seconds to return the rows that makes your selection ... Not sure how big your database is but for anything other than ... This will create a trace file in the ... You aren't error checking your dbi statements - do you have RaiseError ...
    (perl.dbi.users)