|
|
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
>
|
