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: Ashish Pant <panta at ing-americas dot com>
Subject: Help with script
Date: Feb 9 1998 11:52PM

Hi all,

I have recently upgraded from 4.9.2 to System 11.

I had some Sybperl scripts where I was reloading databases.  These
scripts are no longer working.  System11 uses backupserver.  The code
reads


$query = "load database $DATABASE from '/dump03/data'";
&SybaseExecute( $dbproc, $query );
if ($rc < 0) {
   printf ("Error loading database $DATABASE from dump_production");
   exit;
}
while(( @dbrow = &dbnextrow( $dbproc )))
  {
    printf ("@dbrow\n");
  }

$query="online database $DATABASE"
&SybaseExecute( $dbproc, $query );

In 4.9.2 the script (minus the online database) worked.
In Sys11 it starts off the load, then moves on to the next SQL
statements.  In effect the while...dbnextrow loop does not peocess the
rows that come from loading a DB.


Please help
regards
Ashish