Hello This Guy Wants Help,
I'm no Perl expert (more of a database guy) but I have used it to play
with Sybase.
You can use the DBI modules or there is a Sybperl module that is
maintained by Michael Peppler. Either one works well and there is a great
O'Reilly book on Programming the Perl DBI. I would suggest that these
would be the first port of call. There are also some pretty good
tutorials on the web. You can get the DBI and Sybperl modules from CPAN.
Having said that, if it is the sprocs that are taking time then I don't
think that changing languages will do much - sounds more like you should
be looking at either the database (indexing etc) or the sprocs themselves.
If you are talking about loading large volumes of data then you might
want to think about using bcp.
john
Mark-Jason Dominus <[EMAIL PROTECTED]>
04/07/2001 07:00 AM
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: This guy wants help
------- Forwarded Message
Message-ID: <39DBECB00505D411882F00C04FA06B490353C173@EXCHAPHYD1>
From: Bhaskar Reddy <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Help needed.
Date: Tue, 3 Jul 2001 15:34:30 +0530
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2650.21)
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C103A7.8D0EBE60"
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
- ------_=_NextPart_001_01C103A7.8D0EBE60
Content-Type: text/plain;
charset="iso-8859-1"
Hi Mark,
I have a requirement to change my Visual Basic program which reads huge
amount of Data from text files and executes SyBase stored procedures to
insert or update, select the data to/from SyBase Database. Currently its
taking lot of time to complete the process. So we are planning to rewrite
the Visual Basic program either in Java or in PERL. I am new to PERL
programming. If you can, please guide me through some useful information
and
websites that needs to go through as new programmer in PERL. I need
information regarding file reading, writing data into file, database
access
(SYBASE DataBase) (like DB drivers), executing DB stored procedures, error
handling etc..
Thanks in advance.
Thanks and Regards
Bhaskar Reddy
- ------_=_NextPart_001_01C103A7.8D0EBE60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>Help needed.</TITLE>
</HEAD>
<BODY>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Hi Mark,</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">I have a requirement =
to change my Visual Basic program which reads huge amount of Data from =
text files and executes SyBase stored procedures to insert or update, =
select the data to/from SyBase Database. Currently its taking lot of =
time to complete the process. So we are planning to rewrite the Visual =
Basic program either in Java or in PERL. I am new to PERL programming. =
If you can, please guide me through some useful information and =
websites that needs to go through as new programmer in PERL. I need =
information regarding file reading, writing data into file, database =
access (SYBASE DataBase) (like DB drivers), executing DB stored =
procedures, error handling etc..</FONT></P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Thanks in =
advance.</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Thanks and =
Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Bhaskar =
Reddy</FONT>
</P>
<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"> </FONT>
</P>
<BR>
</BODY>
</HTML>
- ------_=_NextPart_001_01C103A7.8D0EBE60--
------- End of Forwarded Message
