|
|
sybperl-l Archive
Up Prev Next
From: "Ravipudi, Murali" <Murali dot Ravipudi at gs dot com>
Subject: RE: DBlib bcp in/out sample
Date: Aug 23 1999 10:33PM
But this bcp is the system call.
used back ticks....
murali
> -----Original Message-----
> From: Damodharan, Venkat (VDamodharan)
> [SMTP:Venkat.Damodharan@dresdnerrcm.com]
> Sent: Monday, August 23, 1999 6:31 PM
> To: SybPerl Discussion List
> Subject: RE: DBlib bcp in/out sample
>
> This is because you have cleared your result set. The result sets are in
> the output buffer. Either you have get all the results by fetching them
> or
> cancel the result before going for the next execution.
>
> Rgds
>
> Venkat
>
> -----Original Message-----
> From: Ravipudi, Murali [mailto:Murali.Ravipudi@gs.com]
> Sent: Monday, August 23, 1999 11:50 AM
> To: SybPerl Discussion List
> Subject: RE: DBlib bcp in/out sample
>
>
>
> Yes, I am already using it that way.
>
> My code is like :
>
> dblib : create temp table
> dblib : call stored proc ( which fills this temp table)
> system : bcp the data out from the temp table
> dblib : clear the temptable ( not necessary, but in future there will be
> more actions added after this. )
>
> and I wanted to do the bcp also using dblib, rather than using the back
> ticks.
> In the above sequence, I am getting a "Sybase error: Attempt to initiate
> a
> new SQL Server operation with results pending." when the bcp is called.
> that is why !! ?? !! ??
>
> Murali
>
>
> > -----Original Message-----
> > From: Charles Zhao [SMTP:charles.zhao-next@attws.com]
> > Sent: Monday, August 23, 1999 1:28 PM
> > To: SybPerl Discussion List
> > Subject: Re: DBlib bcp in/out sample
> >
> > I would not suggest using DBLib bcp calls if your data is huge. If you
> > are
> > handling large data set, using direct sybase bcp calls is more
> efficient.
> > An
> > example (bcp in) is:
> >
> > $bcpCommand = "$ENV{SYBASE}/bin/bcp $db..$Table in $inFile -f $fmtFile
> -U
> >
> > $user -P $psw -S $DBSERVER -b $batchSize -m $maxNumOfErrors -e
> $errFile";
> > @output = `$bcpCommand`;
> >
> > REF: Sybase utilities manual.
> >
> > Points to Know:
> > 1. Failover roll back;
> > 2. If you have bcp v.11, go back use v10. as v11 has a bug.
> >
> > Charles Zhao
|
