why dont you try SybPerl?
use Sybase::DBlib;
$sqlits="select * from baseD..myTable";
&forSybase($sqlits);
while($dbh->dbresults != NO_MORE_RESULTS) {
while(@data = $dbh->dbnextrow){
... # do what you want whit the Array returned (@data)
}
}
sub forSybase {
my $user="user";
my $pwd="password";
my $server="server";
my $baseD="myBD";
$dbh = new Sybase::DBlib $user, $pwd, $server, $baseD;
$dbh->dbcmd($sqlits);
$dbh->dbsqlexec;
}
----- Original Message -----
From: "Waghmare, Satish (IE03x)" <[EMAIL PROTECTED]>
To: "Waghmare, Satish (IE03x)" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <[email protected]>
Sent: Wednesday, January 12, 2005 6:22 AM
Subject: RE: PERL script - access Sybase DB
> How do I install DBI package. I'm getting an error: Please help me to know
> about about how install perl packages and make use of it in script.
>
> Thanks!!
>
> ~Satish
>
> Error:
>
> C:\Perl\bin>ppm
> PPM - Programmer's Package Manager version 3.1.
> Copyright (c) 2001 ActiveState SRL. All Rights Reserved.
>
> Entering interactive shell. Using Term::ReadLine::Stub as readline
library.
>
> Type 'help' to get started.
>
> ppm> install dbi
> Error: No valid repositories:
> Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown
error)
> Error: 500 Can't connect to ppm.ActiveState.com:80 (connect: Unknown
error)
> ppm>
>
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
Waghmare,
> Satish (IE03x)
> Sent: Tuesday, January 11, 2005 9:45 PM
> To: [EMAIL PROTECTED]
> Cc: [email protected]
> Subject: PERL script - access Sybase DB
>
>
>
> Hi Gurus:
>
> I want to know about how to access 'Sybase' database from PERL script.
> I never done any database scripting in PERL.My knowledge in PERL is
very
> limited, I only know file handling, I/O handling.
> I Kindly please let me know detailed explaination with sample scipt to
> do so.
> Looking forward to your valuable inputs and expecting help.
>
> Thank You,
>
> Best Regards
> ~Satish
>
>
>
>
>
>
>
>
>
>
----------------------------------------------------------------------------
----
> _______________________________________________
> ActivePerl mailing list
> [email protected]
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
