Stacy,
Modified to allow null response_no :
Select a.fault_no,
b.response_no,
b.category
From report a,
response b
Where a.fault_no = b.fault_no(+)
ANd ( b.response_no = ( select max(response_no)
from response
For whatever reason perl Makefile.PL fails on my distro
mentions something about a glob which fails at line 207 of the makefile.
I couldn't even get to make install, because make would fail
The weirdest part is that this is machine #2 of two machine which are setup
identicallly.
The difference
Julio Santiago wrote:
> Hi there,
>
> So i have my C Compiler installed, Makefile.pl runs ok, but when it comes to
> make i get this error (first lines of the error)
>
> cc -c -I/usr/local/include -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\"
> -KPIC -I/usr/local/nsPerl5.005_03/lib/sun4-solar
Louise,
Thanks, that works great. One thing though: what about when response_no
= null? These don't show!!!
Regards,
Stacy.
"Mitchell, Louise M" wrote:
> Stacy,
>
> I'm assuming you want the max response_no per fault_no
>
> I think the following should do it..
>
> Select a.fault_no,
>
On Mon, 12 Feb 2001, Hugh Alexander wrote:
>I tried dbi-users with this question, but didn't get much response,
>perhaps someone at this address has an idea.
Mainly because I happened to be off the air (and off skiing) from Friday
through Sunday.
>I am using perl 5.005 and Informix dynamic serv
I have tried DISTINCT, but I still get the same results: ie,
SELECT DISTINCT
response.response_no,
response.category
FROM report,
response
WHERE report.fault_no = response.fault_no(+)
Results:
'1189','457','Telescope control system'
'1189
On Wed, 14 Feb 2001 11:27:34 +1100, Stacy Mader <[EMAIL PROTECTED]>
wrote:
Have you tried using DISTINCT in your SELECT query??
>>
>>Hi all,
>>
>>I am trying to perform a query from two tables linked by the field
>>fault_no. My SQL is:
>>
>>
>>SELECT report.fault_no,
>> respon
Hi all,
I am trying to perform a query from two tables linked by the field
fault_no. My SQL is:
SELECT report.fault_no,
response.response_no,
response.category
FROM report,
response
WHERE report.fault_no = response.fault_no(+)
Now th
What C compiler, gcc? You should compile with same compiler the perl was
compiled.
Ilya Sterin
-Original Message-
From: Julio Santiago [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2001 3:03 PM
To: [EMAIL PROTECTED]
Subject: DBI Installation problem
Hi there,
So i have my C
Oracle SQLPlus describe? Read the fine archive.
http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-01/msg00797.html
John
[EMAIL PROTECTED]
Hi,
Can someone
please instruct me as to how I can output a DESCRIBEd value of a table in
DBI?
Thanks.
Peter
Hi there,
So i have my C Compiler installed, Makefile.pl runs ok, but when it comes to
make i get this error (first lines of the error)
cc -c -I/usr/local/include -O -DVERSION=\"1.14\" -DXS_VERSION=\"1.14\"
-KPIC -I/usr/local/nsPerl5.005_03/lib/sun4-solaris/CORE -DDBI_NO_THREADS
Perl.c
A small terminology correction: according to The O'Reilly Distributed
Systems book: a homogenous database system is a system of databases using
the same RDBMS but possibly different platforms. A Heterogenous system is
different platforms and/or RDBMS systems.
> -Original Message-
> From
On Tue, 13 Feb 2001, David Sherrington - Enterprise Services- Data Management Systems
Engineer wrote:
> a) why the DBI connection is setting autocommit to ON? (when I beleive the
> Oracle default is OFF)
>
Not true. You are referring possibly to SQL*Plus, where the default
autocommit behavior
Franco,
This is not the place to discuss the administration of an Oracle database. I
recommend the Oracle "Concepts Guide" as a starting point. It is included on
the free documentation CD.
Anyway, don't worry about the size of these processes. The process size you can
see with top or ps includes
I must be doing something wrong here.
I have a modper/DBI/Oracle8i/solaris2.7 site. When I just have 6 users login
to the site I end up with about 8 Oracle processes at about 200MB each
(viewed using top).
I'm issuing some very basic SQL with prepared statements. The server has 2GB
or RAM and it
Just realised that FreeTDS doesn't come with a proper ODBC driver or an
ODBC bridge driver of some sort.
Alternatively use the DBD-Sybase or DBD-FreeTDS modules depending on
which version MS-SQL server you are running.
With MSSQL Server 6.5 I use the Sybase libraries that come with Sybase
ASE
Here's a quote from "perldoc DBI":
Explicitly defining the required AutoCommit behavior is
strongly recommended and may become mandatory in a later
version. This determines whether changes are
automatically committed to the database when executed, or
need to be
I didn't pay much attention to the first message from you because all you
said was it failed, not what symptoms you were seeing.
Is the program aborting with an error? If so what error messages are you
seeing?
Is the program simply not finding the table? Try running the same query
from SQL*Plu
Hi,
I am running DBI::Oracle on Solaris using Oracle 8.1.6.
When I run my perl script I get the following warning message:
commit ineffective with AutoCommit enabled at my.pl line 81
Does anybody know
a) why the DBI connection is setting autocommit to ON? (when I beleive the
Oracle default
- Forwarded message from masood <[EMAIL PROTECTED]> -
Date: Tue, 13 Feb 2001 11:21:28 +0500
From: masood <[EMAIL PROTECTED]>
X-Accept-Language: en
To: [EMAIL PROTECTED]
Subject: DBD Problem
Hello Tim
I am using DBI::DBD on sun solaris for intel with Oracle 8.1.5. The DBI
build and test
Date sent: Tue, 13 Feb 2001 00:46:51 -0500
From: Thomas A.Lowery <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject:Re: MS Access System Resource Exceeded Error
Hi interested,
on my system, I killed the scr
22 matches
Mail list logo