How to delete a photo from a blog?
perl dbi
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > Perl web-programming > perl dbi 18 July 2008 20:30:17

  Recent blog posts: 
  They have birthday today: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

perl dbi

Christopher Burger 18 July 2008 20:30:17
 Hello,

I using the perl dbi and mysql and I was wondering if their was a load
command with this.

The following statement works with php
LOAD DATA LOCAL INFILE '$file_location' INTO TABLE $table FIELDS
TERMINATED BY ','

However I can not get the same command to work in perl.

Any answers would be appreciated.

Chris Burger
Add comment
Rajsekar R 31 May 2006 17:45:37 permanent link ]
 Hi ,

how do i ensure that DBI is installed in my machine..

will it be automatically installed when perl is installed...


i am getiing error when i start using use DBI;

and i need to connet to ORACLE DATABASE.


please help me regding this issue..



regds
R . Rajasekar

Add comment
Chris Werner 31 May 2006 18:15:26 permanent link ]
 Hello, R . Rajasekar

perl -e 'use DBI;'

I would ask what platform you are using that does not have perl installed?
Most unix platforms will already have a default installation of perl and
DBI. If you are installing on windows, you will likely use ActiveState; it
has been a while since I installed active state, but I seem to recall that
it installed DBI.

Oracle and the DBD driver are another story. DBD::Oracle will be required to
use DBI to connect to an Oracle database. No, this is not likely installed
on a default installation.

Perhaps you could post more information: platform, error message, connection
code...

Hope this helps,

Christian Werner

-----Original Message-----
Hi ,

how do i ensure that DBI is installed in my machine..

will it be automatically installed when perl is installed...


i am getiing error when i start using use DBI;

and i need to connet to ORACLE DATABASE.


please help me regding this issue..



regds
R . Rajasekar
Add comment
David Landgren 31 May 2006 18:22:29 permanent link ]
 Chris Werner wrote:> Hello, R . Rajasekar>
perl -e 'use DBI;'>
I would ask what platform you are using that does not have perl installed?> Most unix platforms will already have a default installation of perl and> DBI. If you are installing on windows, you will likely use ActiveState; it> has been a while since I installed active state, but I seem to recall that> it installed DBI.

DBI is not core. You have to install it from CPAN or via ppm on ActiveState.

David

--
Much of the propaganda that passes for news in our own society is given
to immobilising and pacifying people and diverting them from the idea
that they can confront power. -- John Pilger


Add comment
Ron Reidy 31 May 2006 18:32:24 permanent link ]
 Neither DBI nor DBD::Oracle are installed as part of the Perl distro.
To see if either module is installed:

$ perl -MDBI -e '0'
$ perl -MDBD::Oracle -e '0'

If you need to install either module, google will be your friend.

-----Original Message-----
From: R, Rajsekar [mailto:Rajasekar.R@ps.net]
Sent: Wednesday, May 31, 2006 7:46 AM
To: dbi-users@perl.org
Subject: perl- dbi

Hi ,

how do i ensure that DBI is installed in my machine..

will it be automatically installed when perl is installed...


i am getiing error when i start using use DBI;

and i need to connet to ORACLE DATABASE.


please help me regding this issue..



regds
R . Rajasekar

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


Add comment
Jonathan Leffler 31 May 2006 20:01:40 permanent link ]
 On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net­> wrote:> how do i ensure that DBI is installed in my machine..> will it be automatically installed when perl is installed...>
i am getiing error when i start using use DBI;> and i need to connet to ORACLE DATABASE.

You've received a few workable answers - but there's a better one.

perl -MDBI -e 'print "$DBI::VERSION\n"'

This tells you which version of DBI you have installed - which can be
even more valuable than simply knowing that DBI is installed.

Similarly:

perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERS­ION\n"'

Similarly for any other (civilized) module - whether in the DBI/DBD
collection or not.

--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org­
"I don't suffer from insanity - I enjoy every minute of it."

Add comment
Philip Garrett 31 May 2006 20:06:20 permanent link ]
 -----Original Message-----
From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Sent: Wednesday, May 31, 2006 12:02 PM
To: R, Rajsekar
Cc: dbi-users@perl.org
Subject: Re: perl- dbi>
On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net­> wrote:> > how do i ensure that DBI is installed in my machine..> > will it be automatically installed when perl is installed...> >
i am getiing error when i start using use DBI; and i need to connet
to ORACLE DATABASE.>
You've received a few workable answers - but there's a better one.>
perl -MDBI -e 'print "$DBI::VERSION\n"'

Or this:
perl -MDBI -e 'DBI->installed_ver­sions'

which tells you what DBD modules are installed, and the versions of
pretty much anything that matters to DBI, as someone recently
pointed out to me.

E.g.:

$ perl -MDBI -e 'DBI->installed_ver­sions'
Perl : 5.008003 (i586-linux-thread-­multi)
OS : linux (2.6.5)
DBI : 1.50
DBD::Sponge : 11.10
DBD::SQLite : 1.11
DBD::SQLRelay : 0.37
DBD::Proxy : install_driver(Prox­y) failed: Can't locate
RPC/PlClient.pm in @INC
DBD::Oracle : 1.17
DBD::File : 0.33
DBD::ExampleP : 11.12
DBD::DBM : 0.03

Philip

Add comment
Jeff Zucker 31 May 2006 20:09:48 permanent link ]
 Jonathan Leffler wrote:> You've received a few workable answers - but there's a better one.>
perl -MDBI -e 'print "$DBI::VERSION\n"'>­
This tells you which version of DBI you have installed - which can be> even more valuable than simply knowing that DBI is installed.>
Similarly:>
perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERS­ION\n"'

And here's an even better one, assuming a relatively modern DBI:

perl -MDBI -e "DBI->installed_ver­sions"

That tells you the versions of DBI, Perl, OS, and all DBDs installed.

--
Jeff

Add comment
Rajsekar R 1 June 2006 13:55:04 permanent link ]
 Hi,

I am getting this error . please let me know.. what needs to be done further

perl -MDBI -e 'print "$DBI::VERSION\n"'
Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/­sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_per­l/5.005/sun4-solaris­ /usr/perl5/site_per­l/5.005 .).
BEGIN failed--compilation­ aborted.



Regds,
R.Rajasekar

___________________­_____________

From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com]
Sent: Wed 31/05/2006 21:31
To: R, Rajsekar
Cc: dbi-users@perl.org
Subject: Re: perl- dbi



On 5/31/06, R, Rajsekar <Rajasekar.R@ps.net­> wrote:> how do i ensure that DBI is installed in my machine..> will it be automatically installed when perl is installed...>
i am getiing error when i start using use DBI;> and i need to connet to ORACLE DATABASE.

You've received a few workable answers - but there's a better one.

perl -MDBI -e 'print "$DBI::VERSION\n"'

This tells you which version of DBI you have installed - which can be
even more valuable than simply knowing that DBI is installed.

Similarly:

perl -MDBD::Oracle -e 'print "$DBD::Oracle::VERS­ION\n"'

Similarly for any other (civilized) module - whether in the DBI/DBD
collection or not.

--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org­
"I don't suffer from insanity - I enjoy every minute of it."




Add comment
Jonathan Leffler 1 June 2006 18:55:55 permanent link ]
 On 6/1/06, R, Rajsekar <Rajasekar.R@ps.net­> wrote:> I am getting this error . please let me know.. what needs to be done further>
perl -MDBI -e 'print "$DBI::VERSION\n"'>­ Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/­sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_per­l/5.005/sun4-solaris­ /usr/perl5/site_per­l/5.005 .).> BEGIN failed--compilation­ aborted.


Download, compile and install DBI. And the driver for the DBMS you plan to use.


--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org­
"I don't suffer from insanity - I enjoy every minute of it."

Add comment
Jonathan Leffler 1 June 2006 18:57:59 permanent link ]
 On 6/1/06, Jonathan Leffler <jonathan.leffler@g­mail.com> wrote:> On 6/1/06, R, Rajsekar <Rajasekar.R@ps.net­> wrote:> > I am getting this error . please let me know.. what needs to be done further> >
perl -MDBI -e 'print "$DBI::VERSION\n"'>­ > Can't locate DBI.pm in @INC (@INC contains: /usr/perl5/5.00503/­sun4-solaris /usr/perl5/5.00503 /usr/perl5/site_per­l/5.005/sun4-solaris­ /usr/perl5/site_per­l/5.005 .).> > BEGIN failed--compilation­ aborted.>
Download, compile and install DBI. And the driver for the DBMS you plan to use.

And, since you're using a seriously down-version of Perl, you need to
get yourself a sufficiently *old* version of DBI - one that will work
with Perl 5.5.3; the current version requires 5.6.1.

You'd be best off getting Perl 5.8.8 and redoing all the modules.
It'll be harder in the short term, but you might not need to do it
again for another 3 years.


--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org­
"I don't suffer from insanity - I enjoy every minute of it."

Add comment
Will Rutherdale 5 June 2006 23:25:36 permanent link ]
 If one wanted to get up to date for a while on a Perl-DBI-Informix
combo, would this be a good set of versions:

Perl 5.8.8
DBI 1.50
DBD::Informix 2005.02

We're not changing Informix itself at this point. Just wanted to recap
versions for Perl and libraries based on what's been mentioned in this
list and what I've seen on CPAN. The OS is Sun.

-Will

-----Original Message-----> From: Jonathan Leffler [mailto:jonathan.leffler@gmail.com] > Sent: Thursday 01 June 2006 10:58> To: R, Rajsekar> Cc: dbi-users@perl.org>­ Subject: Re: perl- dbi>
And, since you're using a seriously down-version of Perl, you need to> get yourself a sufficiently *old* version of DBI - one that will work> with Perl 5.5.3; the current version requires 5.6.1.>
You'd be best off getting Perl 5.8.8 and redoing all the modules.> It'll be harder in the short term, but you might not need to do it> again for another 3 years.>


- - - - - Appended by Scientific Atlanta, a Cisco company - - - - -
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.


Add comment
Jonathan Leffler 5 June 2006 23:29:19 permanent link ]
 On 6/5/06, Rutherdale, Will <Will.Rutherdale@sc­iatl.com> wrote:> If one wanted to get up to date for a while on a Perl-DBI-Informix> combo, would this be a good set of versions:>
Perl 5.8.8> DBI 1.50> DBD::Informix 2005.02>
We're not changing Informix itself at this point. Just wanted to recap> versions for Perl and libraries based on what's been mentioned in this> list and what I've seen on CPAN. The OS is Sun.

Those are all the most recent versions, though Tim is preparing a DBI
1.51 release.

That's what I have on my Solaris machine at the office.

--
Jonathan Leffler <jonathan.leffler@g­mail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org­
"I don't suffer from insanity - I enjoy every minute of it."

Add comment
Gene Golub 18 July 2008 06:19:33 permanent link ]
 
Hi Tim

I read your post on http://search.cpan.­org/src/TIMB/DBI_Adv­ancedTalk_2004/index­.htm. Thank you for the great information.
I was using korn shell for years.
few things I do not see there is:
1. how do you process procedures
2. what if I have multiple select or exec statements? Can dump output to file and process it in awk or egrep manner?

thank you, Gene.
Add comment
Douglas Wilson 18 July 2008 20:30:17 permanent link ]
 On Thu, Jul 17, 2008 at 7:19 PM, gene golub <gene_golub@hotmail­.com> wrote:

1. how do you process procedures

Often the same or nearly the same way you process other SQL statements.
There are often examples in the DBD::* (whatever DBD you are using)
documentation.

2. what if I have multiple select or exec statements? Can dump output to file and process it in awk or egrep manner?

You're not very clear here. Yes you can execute multiple statements...with
multiple calls to execute(). You can pretty easily output results to a
file, there
are probably even modules to make it even easier.

HTH,
Douglas Wilson

Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > Perl web-programming > perl dbi 18 July 2008 20:30:17

see also:
DIV visiblility Notification…
initdb failure with PostgreSQL 7.3.2 /…
[ROOT] Urgent message
пройди тесты:
What is Your Temperament?
see also:
Presentation
Konichi-wa
)))))))))))))))))))))

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .