sybperl-l Archive

From: ddrumm at rush dot edu
Subject: SybPerl error.
Date: Sep 9 1997 11:05PM

I tried to use the 'update' SQL command for the first time with SybPerl
2.03 and Perl 5.002. Much to my chagrin, I got this error:

Can't locate auto/Sybase/DBlib/dbmcd.al in @INC at ./update.pl line 15

I looked, and there was no dbmcd.al file in this directory. Only the
following:

autosplit.ix  dbclose.al    dbsucceed.al  sql.al

What does the .al stand for? 
Why wouldn't dbmcd.al be there? I checked my /usr/local/src tree, where I
still had copies of everything, and it wasn't there either.

Here was my program:
 
#!/usr/local/bin/perl

$ENV{'SYBASE'} = "/opt/sybase";
use Sybase::DBlib;

$name = "foo";
$password = "bar";
$dbproc =  Sybase::DBlib->dblogin("$name","$password","SYBASETEST");

$uid = 2001;
$passwd = "hal";

$dbproc->dbuse('TestDB');
$dbproc->dbcmd("update Testtable");
$dbproc->dbmcd("set passwd = \"$passwd\"");   # Line 15 - error
$dbproc->dbcmd("where uid = $uid");
$dbproc->dbsqlexec;


--
Daniel G. Drumm - ddrumm@rush.edu
Rush Presbyterian St. Luke's Medical Center - Chicago, IL
Network Division - Information Services