PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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: aspivakovsky@iie.org
> 
>      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 sybperl.man
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 http://www.sybase.com/WWW/Sybperl.

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 http://www.sybase.com and
look around for 'sybooks').

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

#!/usr/local/bin/perl

use Sybase::DBlib;

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

Output:
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!

Michael