How to connect to db2 database using perl or php

[Excluded_Middle]

Hi,
I am trying to connect to db2 database and want to execute some basic
SQL commands like create or select.

I am on linux 7 redhat distribution and I have no rights to compile
perl or install some thing that is big in size as I am student.

I just want to experiment db2 and php or perl.

any link or suggestions ?

Thank you to all in advance.

[Darin McBride]

Excluded_Middle wrote:

Hi,
I am trying to connect to db2 database and want to execute some basic
SQL commands like create or select.

I am on linux 7 redhat distribution and I have no rights to compile
perl or install some thing that is big in size as I am student.
If you cannot get DB2 installed on the machine, then there's not much
anyone can do except suggest you get a Linux box at home. I've heard
you can get this all running on Windows, too, if that's what you have
at home, but I wouldn't personally want to go there.

Assuming that DB2 is already installed, you can simply get the DBI and
DBD::DB2 modules installed in a private, local directory, and you can
use it with the perl that is already installed with RH7. You don't
need root access to install a private module, nor do you need to
compile/install the entire perl privately. I presume you can do
similarly with php, but I'm not proficient with that language.
I just want to experiment db2 and php or perl.

any link or suggestions ?

Thank you to all in advance.

[Todd Huish]

On Mon, 31 May 2004 23:54:34 GMT, Darin McBride
<dm******@naboo.to.org.no.spam.for.me> wrote:

Excluded_Middle wrote:

Hi,
I am trying to connect to db2 database and want to execute some basic
SQL commands like create or select.

I am on linux 7 redhat distribution and I have no rights to compile
perl or install some thing that is big in size as I am student.

If you cannot get DB2 installed on the machine, then there's not much
anyone can do except suggest you get a Linux box at home. I've heard
you can get this all running on Windows, too, if that's what you have
at home, but I wouldn't personally want to go there.

Assuming that DB2 is already installed, you can simply get the DBI and
DBD::DB2 modules installed in a private, local directory, and you can
use it with the perl that is already installed with RH7. You don't
need root access to install a private module, nor do you need to
compile/install the entire perl privately. I presume you can do
similarly with php, but I'm not proficient with that language.

I just want to experiment db2 and php or perl.

any link or suggestions ?

Thank you to all in advance.

Getting db2 working with php does require compilation of php. It can be
installed as a module. You will need the headers from the Workgroup or
developer edition in the include directory of your db2 install. You can
get the php source into your directory and then you compile just the odbc
module with the "--with-ibm-db2=shared,/opt/IBM/db2/V8.1" configuration
flag and put the resulting odbc.so in your local directory. You can then
load this in your php code with the dl() function. I believe this may
require php to be compiled with module support allthough I think that is
the default. I agree with Darin though, getting a linux box at home would
be the best bet. Nothing beats having full control of a machine for this
sort of testing.

--
Todd Huish

[Excluded_Middle]

Thank you Mr Darin and Mr Todd. So there is a possibility using DB2
without root permmission.

I am interested in trying both of the methods and I am planning to buy
a machine that run linux OS as soon as I get money. I was so curious
about that I couldn't wait to try it on my university linux account.

The second restriction is that I have only 30 MB disk quota. So if you
guys think that the method you both describe don't need to much disk
space then please give me the detail or provide me a link where these
methods are described clearly.

One more time I will thank you guys for reply.

[Todd Huish]

On 1 Jun 2004 22:17:58 -0700, Excluded_Middle <ib****@hotmail.com> wrote:

Thank you Mr Darin and Mr Todd. So there is a possibility using DB2
without root permmission.

I am interested in trying both of the methods and I am planning to buy
a machine that run linux OS as soon as I get money. I was so curious
about that I couldn't wait to try it on my university linux account.

The second restriction is that I have only 30 MB disk quota. So if you
guys think that the method you both describe don't need to much disk
space then please give me the detail or provide me a link where these
methods are described clearly.

One more time I will thank you guys for reply.

I started looking at the dynamic module thing and realized you are going
to have a problem with only 30MB home dir. I just compiled php and the
source dir alone is 31MB before anything's even compiled. I actualy hit
some weird problems trying to just compile the odbc module. I know I have
done similar things in the past but for some reason it just isn't working.
I did realize though that you should have no problem compiling a local
copy of php for your own usage. As an example you can use this script to
compile php. Just edit the DIR_PRE to point to your home directory and
where you want php to install. I tried this as a regular user on a machine
and it worked fine.

http://toddlee.org/php/cfg_php.sh

This is the script that I basicaly use on any machine that has db2 on it
because it lets me have quick and easy script access via a very stripped
down cli php. Good luck!

--
Todd Huish

[Darin McBride]

Excluded_Middle wrote:

Thank you Mr Darin and Mr Todd. So there is a possibility using DB2
without root permmission.
Only if you have someone that does have root permission do the initial
installation.
I am interested in trying both of the methods and I am planning to buy
a machine that run linux OS as soon as I get money. I was so curious
about that I couldn't wait to try it on my university linux account.

The second restriction is that I have only 30 MB disk quota. So if you
guys think that the method you both describe don't need to much disk
space then please give me the detail or provide me a link where these
methods are described clearly.
You should be able to read the installation instructions for perl
modules in the perl documentation. Especially reading the
documentation for ExtUtils::MakeMaker which talks about the PREFIX and
LIB variables. This should apply to any module(s) you may need to
install, notably DBI and DBD::DB2. Also note that your administrator
may have already installed these globally, or you may be able to
convince them to do so.
One more time I will thank you guys for reply.