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: "Louis Proyect" <lnp3 at columbia dot edu>
Subject: Column headings question
Date: Oct 7 2009 3:39PM

Is there an easier way to access column headings than this:

@res=$dbh->ct_sql("exec stored_procedure");

@res2=$dbh->ct_sql("sp_help table_name"); ---> this is the table that
maps to the stored procedure results

$cntr = 0;

foreach $row (@res2)   # Loop through each row
{
  print "@$row[0]: ";
  print "$res[0][$cntr]\n";
  $cntr++;
}

Most importantly, this only works if the stored procedure is returning
results that map to a single table. If the results are from joined
tables, you are out of luck.