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: 1FA91-Rolf Kamp <rfk at uhura dot jazz dot att dot com>
Subject: Sybase Column Names
Date: Oct 27 1997 8:47PM

Greetings:
	I am writing a generic sybperl routine to read a sybase table and
	create an HTML table out of the results, with the sybase table's
	column names as the HTML table's headers.  The DBlib routine
	dbcolsource seems to be what I need to get the sybase table's
	columns names.  I attempt to use it as:

use Sybase::DBlib;
$dbh=new Sybase::DBlib $user, $passwd, $db;
$dbh->dbcmd("select * from blahblah");
$dbh->dbsqlexec;
$dbh->dbresults;
$i=0;
@ColNames = ();
while ($ColNames[$i++] = $dbh->dbcolsource($i)) {
	 print "ColNames[$i-1]:$ColNames[$i-1]\n"; 
}

	I get:
Can't locate auto/Sybase/DBlib/dbcolsource.al in @INC (@INC contains: /opt/perl5/lib/PA-RISC1.1/5.00401 /opt/perl5/lib /opt/perl5/lib/site_perl/PA-RISC1.1 /opt/perl5/lib/site_perl .) at ./x.pl line 11

	Am I calling dbcolsource incorrectly, or do I need to modify @INC?

	I am using sybperl 2.07c.

	Thanks...

- Rolf F. Kamp.
(rolf.kamp@att.com)