SYBASEASEFORLINUX installation and perl connection SYBASE

SYBASEASEFORLINUX installation and perl connection SYBASE -- Linux Enterprise Application-Linux server application information. The following is a detailed description. Install Sybase ASE

Sybase-common-11.9.2-1.i386.rpm
Sybase-ase-11.9.2-1.i386.rpm

Install Sybase OpenClient

Sybase-openclient-11.1.1-1.i386.rpm

Source:
Http://www.sybase.com/products/d .. x/thankyou1192.html

Method:
Rpm-hiv sybase-common-11.9.2-1.i386.rpm
Rpm-hiv sybase-ase-11.9.2-1.i386.rpm
Rpm-hiv sybase-openclient-11.1.1-1.i386.rpm
The default installation path is/opt/sybase-11.9.2 if you need to reset the path to/home/sybase:

Rpm -- relocate "/opt/sybase-11.9.2" = "/home/sybase"-hiv...

Run
$ HOME/install/sybinstall. sh
$ HOME/. profile

The installation program is $ HOME/bin/srvbuild, which must be run in Xwindows and is included in. profile.
After installation, you also need to set Environment Variables
SYBASE =/home/sybase
DSQUERY = sybase (servername)

Install PERL DBI
1. Required package

DBI-1.xx.tar.gz

DBD-Sybase-0.xx.tar.gz


Source:
Http://www.perl.com/CPAN-local/authors/Michael_Peppler/

Http://www.perl.com/CPAN-local/modules/by-module/DBI/TIMB/


2 Installation Method

Gunzip DBI-1.xx.tar.gz
Tar xvf DBI-1.xx.tar

Perl Makefile. PL
Make
Make test
Make install

Gunzip DBD-Sybase-0.xx.tar.gz
Tar xvf DBD-Sybase-0.xx.tar
Perl Makefile. PL
Make
Make test
Make install


3 basic programming example:

#! /Usr/bin/perl
Use DBI;

My $ server = "sybase ";

My $ dbh = DBI-> connect ('dbi: Sybase: ', 'sa ','',);
My $ something = $ dbh-> prepare ("sp_help ");
$ Something-> execute ();
My $ text;

While ($ text) = $ something-> fetchrow)
{
Print $ text ."";
}
Exit (0 );