use Sybase::Simple;

my $dbh = new Sybase::Simple $user, $pwd, $server;

my $data = $dbh->ArrayOfHash("exec my_stored_proc");
# $data is an arrayref, where each row is a row from the proc.
# This will also cleanly handle multiple result sets from 
# the same proc.
[download]

Michael

The DBI module together with the DBD::Sybase database driver will be a lot easier than using ctlib of Sybperl.

"The first rule of Perl club is you don't talk about Perl club."

There is a good example of using the Sybase DBI library on CPAN. Go to the script section and look for a script called sqlgui. I used to work with the author and this script contains a lot of excellent tricks for database programming.

If you really, really, really don't want to learn how to program against a Sybase server (using ctlib/Sybperl/DBI/DBD) then you may consider executing the existing command line tool isql from inside your Perl script.

f--k the world!!!!
/dev/world has reached maximal mount count, check forced.

Hehehehe... the very first version of sybperl (back in 1990) used two-way pipes over pseudo-ttys to talk to isql...

:-)

Michael

thanks, but what would be a good reference to learn the basic of sybperl. Thanks

Well, mpeppler the author of both Sybperl and DBD::Sybase is occasionally in the monastery, so he might jump in on this thread at any time.

But my opinion (as someone who spent many years using Sybperl] is that the DBI interface is much easier to understand. There's a good book on it called Programming the Perl DBI.

--
<http://www.dave.org.uk>

"The first rule of Perl club is you don't talk about Perl club."

http://www.mbay.net/~mpeppler/ is probably the best place to start.

Michael

This actually depends on which type of sybase server you are trying to connect to. I know of the following 3 types:

1. Sybase Adaptive Server Enterprise aka ASE (formerly known as Sybase SQL Server)
2. iAnywhere SQL Anywhere aka ASA (formerly known as Adaptive Server Anywhere and way way back as Watcom SQL)
3. Sybase IQ server

You're mostly right ;-)

IQ does not use ASA 'under the covers'. It uses ASE or ASA for it's metadata and handles the data by itself.

I'd suggest to fetch DBD::ASAny from CPAN to have a common source for all modules and make installation easier.