Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: mpeppler at itf dot ch (Michael Peppler)
Subject: Re: Sybperl primer
Date: Feb 19 1996 8:23AM

> From:
>      Is there any documentation, or example scripts, explaining how to work 
>      with Sybperl to a beginner.
>      My perl is not too bad, but I need something that will describe the 
>      different features of Sybperl. I've been lurking on the list for a few 
>      months now hoping I would figure it out, with no luck.

The sybperl docs (in pod/sybperl.pod for versions 2.x, in
for version 1.x) are the place to start.

You can get the text, and examples of my sybperl presentation at the
London ISUG conference from

The eg/ directory in release 2.x contains a number of example scripts
that should point you in the right direction.

You also need access to the Sybase OpenClient docs (They are available
on the web if you don't have them localy: try and
look around for 'sybooks').

To really get you started, here is the prototypical sybperl script
(assumes version 2.x):


use Sybase::DBlib;

$dbh = new Sybase::DBlib username, password;
$dbh->dbcmd("select * from sysusers");
while($dbh->dbresults != NO_MORE_RESULTS) {
    while(@dat = $dbh->dbnextrow) {
        print "Name = $dat[3], Uid = $dat[1]\n";

Name = replication_role, Uid = 16390
Name = navigator_role, Uid = 16389
Name = sybase_ts_role, Uid = 16388
Name = oper_role, Uid = 16387
Name = sso_role, Uid = 16386
Name = sa_role, Uid = 16385
Name = edp, Uid = 16384
Name = public, Uid = 0
Name = dbo, Uid = 1
Name = mpeppler, Uid = 3
Name = Schaer, Uid = 4
Name = Savatier, Uid = 7
Name = infoback, Uid = 15
Name = gilles, Uid = 12
Name = ken, Uid = 13
Name = infotool, Uid = 14
Name = tara, Uid = 16
Name = nobody, Uid = 17

>      Also. Does anyone use WDB? What are the limitations?

Sorry, I don't use wdb.

Hope this helps!