Re: Describe table

2004-07-12 Thread Sapet Frederic
On Thu, 8 Jul 2004 18:42:47 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > On Thu, Jul 08, 2004 at 10:48:35AM +0200, Sapet Frederic wrote: > > On Wed, 7 Jul 2004 18:29:18 +0100 > > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > > > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > >

(Fwd) DB2 and "Upgrade" Re: Describe table

2004-07-10 Thread Tim Bunce
y-To: [EMAIL PROTECTED] Organization: Skywarn - MoP Newsgroups: perl.dbi.users To: Tim Bunce <[EMAIL PROTECTED]> Subject: DB2 and "Upgrade" Re: Describe table Tim Bunce answered ... > > > Upgrade. to which the reply was > > and all the methods I needed work fine n

Re: Describe table

2004-07-08 Thread Tim Bunce
On Thu, Jul 08, 2004 at 10:48:35AM +0200, Sapet Frederic wrote: > On Wed, 7 Jul 2004 18:29:18 +0100 > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > > > I am using > > > > > Oracle 8.1.5 > > > > > DBI 1.42 > > > and $DBD::Oracle::V

Re: Describe table

2004-07-08 Thread Sapet Frederic
On Wed, 7 Jul 2004 18:29:18 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > > I am using > > > > Oracle 8.1.5 > > > > DBI 1.42 > > and $DBD::Oracle::VERSION = '1.06'; > > > column_info= (not implemented) ? > > I don't understand

Re: Describe table

2004-07-07 Thread Tim Bunce
On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote: > > > I am using > > > Oracle 8.1.5 > > > DBI 1.42 > and $DBD::Oracle::VERSION = '1.06'; > column_info= (not implemented) ? > I don't understand :0( Upgrade. Tim.

Re: Describe table

2004-07-07 Thread Sapet Frederic
> > I am using > > Oracle 8.1.5 > > DBI 1.42 and $DBD::Oracle::VERSION = '1.06'; I laucnh the script like this : >DBI_TRACE=2 column_info.pl my script looks like: #!/bin/perl -w use strict; use diagnostics; use warnings; use DBI; my $dbh = DBI->connect('dbi:Oracle:gpdvt', 'OSNP', 'pwd') or

Re: Describe table

2004-07-07 Thread Tim Bunce
On Tue, Jul 06, 2004 at 06:11:18PM +0200, Sapet Frederic wrote: > On Tue, 6 Jul 2004 16:07:28 +0100 > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > I think in some cases it's better to use > > > > $sth = $dbh->column_info(...) > > > > :) > I am using > Oracle 8.1.5 > DBI 1.42 DBD::Oracle ?

Re: Describe table

2004-07-06 Thread Sapet Frederic
On Tue, 6 Jul 2004 16:07:28 +0100 Tim Bunce <[EMAIL PROTECTED]> wrote: > I think in some cases it's better to use > > $sth = $dbh->column_info(...) > > :) > > Tim. > hi I am using Oracle 8.1.5 DBI 1.42 I tried to use this method like this : $sth = $dbh->column_info( undef,'OSNP', '%

Re: Describe table

2004-07-06 Thread Tim Bunce
> > -Original Message- > From: PerlDiscuss - Perl Newsgroups and mailing lists > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 06, 2004 5:16 AM > To: [EMAIL PROTECTED] > Subject: Re: Describe table > > > Hi > > You cannot use the DESCRIBE statement as

RE: Describe table

2004-07-06 Thread Helck, Timothy
under consideration, then user_tab_columns won't show that table. Tim Helck -Original Message- From: PerlDiscuss - Perl Newsgroups and mailing lists [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 06, 2004 5:16 AM To: [EMAIL PROTECTED] Subject: Re: Describe table Hi You cannot use the DESCRIBE

Re: Describe table

2004-07-06 Thread PerlDiscuss - Perl Newsgroups and mailing lists
Hi You cannot use the DESCRIBE statement as it is. Try it in the following way select * from sys.user_tab_columns where table_name = ''; Cheers Prabu Jimmy Jauhal wrote: > Hi All, > I am trying to execute a DESCRIBE table statement from my perl script that > connects t

Re: Describe table

2004-05-13 Thread David N Murray
> Hi All, > > I am trying to execute a DESCRIBE table statement from my perl script that > connects to an oracle DB. For some reason the execute fails saying that > "describe table" is not a valid SQL statement. When I try SELECT > statements they work fine and fetch dat

Describe table

2004-05-13 Thread Jimmy Jauhal
Hi All, I am trying to execute a DESCRIBE table statement from my perl script that connects to an oracle DB. For some reason the execute fails saying that "describe table" is not a valid SQL statement. When I try SELECT statements they work fine and fetch data properly. DBI versio

Re: How to perform "describe table" ?

2001-08-28 Thread Thomas A . Lowery
gne wrote: > to select something from the database I do > $qw = "select * from table"; > $sth = $dbh->prepare(qq ($qw)); > $sth->execute(); > to perform delete's, update's and insert's I use > $qw = "delete from table"; >

RE: How to perform "describe table" ?

2001-08-28 Thread tziem
ct: How to perform "describe table" ? > > Hi all, > > to select something from the database I do > $qw = "select * from table"; > $sth = $dbh->prepare(qq ($qw)); > $sth->execute(); > to perform delete's, update's and insert's I u

How to perform "describe table" ?

2001-08-28 Thread Koen Gogne
Hi all, to select something from the database I do $qw = "select * from table"; $sth = $dbh->prepare(qq ($qw)); $sth->execute(); to perform delete's, update's and insert's I use $qw = "delete from table"; $dbh->do(qq ($qw)); BUT WHAT DO I NEED TO