sybperl-l Archive

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