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: "Athey, Keith" <Keith dot Athey at twc dot state dot tx dot us>
Subject: RE: Help with script
Date: Feb 10 1998 1:07AM

Unfortunately, system 4 tables won't reload into system 11... or so I'm
told.  Check with sybase tech support to make sure.

> -----Original Message-----
> From:	Ashish Pant [SMTP:panta@ing-americas.com]
> Sent:	Monday, February 09, 1998 5:52 PM
> To:	SYBPERL-L@trln.lib.unc.edu
> Subject:	Help with script
> 
> 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
>