Install SybaseASEsybase-common-11.9.2-1.i386.rpmsybase-ase-11.9.2-1.i386.rpm install SybaseOpenClientsybase-openclient-11.1.1-1.i386.rpm Source: www.sybase.comproductsdatabaseserverslinuxthankyou1192.html method: rpm-hivsybase-common-11.9.2-1. SybasePerl
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/databaseservers/linux/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', ', {syb_dbd_server => $ server });
My $ Something = $ dbh-> prepare ("sp_help ");
$ Something-> execute ();
My $ text;
While ($ text) = $ Something-> fetchrow)
{
Print $ text. "\ n ";
}
Exit (0 );
