On Thu, 17 Oct 2002 14:05:26 +1000 "Pereira, Adrian" <[EMAIL PROTECTED]>
wrote:
> I have a simple problem which I am sure an answer has been posted but cant
> find it.
>
>
> My perl has been compiled with cc (Solaris 8). I do not have cc on this
> machine and I need to install DBI and DBD. I
Hello to all,
I have a rather strange problem when using DBI/DBD Ingres 034 on INGRES 2
I want to process a file line by line and perform certain database actions
(insert, delete) according to the data in the files.
I want to commit all changes made after processing one line, so the sequence
g
Hi guys,
I have a simple problem which I am sure an answer has been posted but cant
find it.
My perl has been compiled with cc (Solaris 8). I do not have cc on this
machine and I need to install DBI and DBD. I do have gcc. Unfortunately
Makefile.PL thinks I have cc and does not recognise gc
Hi, I am afraid this is a beginner's question. But I did not find in the
web.
I am using DB2 UDB workgroup 7.2 and DBI 0.73 and Perl 5.
I intend to run some simple db2 command like "import" , how I can do it
in perl?
I tried to run it as a normal sql command:
###
$stmt = "IMPORT FROM F
Hi
Sorry for the inconvenience of yat another request for help on long blob
insertion:
I cannot manage to get MS access accept strings over 255 in a field
defined as TYPE MEMO;
despite the FAQS etc telling me to use placeholders, and to use
bind_param;
both the bind and the execute fail; the
I'm trying to build DBD-Oracle and am not sure of what .mk file to use. I
used find to identify available .mk file and got this output:
~> find /oracle -name \*.mk
/oracle/network/lib/ins_net_client.mk
/oracle/network/lib/env_network.mk
/oracle/sqlplus/lib/env_sqlplus.mk
/oracle/sqlplus/lib/ins
On Wed, October 16 11:51 +0100, Tim Bunce wrote:
> Try:
> my $sth = $dbh->prepare("SELECT 1 FROM dual", { ora_check_sql => 0 });
Thanks, that did the trick. Thanks also for the detailed explanation
and links.
> I believe the parse at execute time is fundamentally an Oracle bug
> (and/or isn't
[EMAIL PROTECTED] wrote:
>I have snipped ALL previous discussion on this as I am finding it almost
>impossible to see the wood from the trees now.
>
Thanks, this makes it much more understandable.
>If I understand you correctly you have the following procedure:
>
>create procedure roger
> @p1 i
[EMAIL PROTECTED] wrote:
> Why not use the following SELECT statement:
> select col1 from jenny where col1<>0 and col1 is not null
>
> That should do the trick nicely. :)
>
> Gordon Dewis
what if 0 *is* a valid entry for that particular row?
chris
--
---
Just
simple fix:
while( ($col1) = $sth_1->fetchrow_array){
because $sth_1->fetchrow_array returns an array, $col1 needs to be part
of a list context.
On Wed, 2002-10-16 at 13:10, Liu, Jenny wrote:
>
>
> The following simple sql statement just try to select a column from a table.
> But if the val
Why not use the following SELECT statement:
select col1 from jenny where col1<>0 and col1 is not null
That should do the trick nicely. :)
Gordon Dewis
Production Officer
Geography Division
Statistics Canada
(613)951-4591
-Original Message-
From: Liu, Jenny [mailto:[EMAIL PROTEC
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 16 October 2002 20:10, Liu, Jenny wrote:
> The following simple sql statement just try to select a column from a
> table. But if the value is 0 or null, the row will not be printed.
> Is there any way I can make all the rows printed? Th
The following simple sql statement just try to select a column from a table.
But if the value is 0 or null, the row will not be printed. Is there any
way I can make all the rows printed? The col1 is a integer data type in
table.
Thanks
$Sql_stmt = "select col1 from jenny ";
On Wed, Oct 16, 2002 at 07:43:57AM -0700, Michael A Chase wrote:
> On Wed, 16 Oct 2002 10:57:36 +0100 Mark Buckle <[EMAIL PROTECTED]>
>wrote:
>
> > I know I'm possibly one of those 'born-every-minute' types, but I actaully
> > bought the O'Reilly book and read it cover to cover
> > before beginn
Curious. Scott, what is your NLS_LANG and what is the character set
(SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET')?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Me
Do you have icky LONG datatypes that you are fetching? That could be one
cause.
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Birchall, Austen [mailto:[EMAIL PROTECTE
Scott,
Something about your setup. Don't know what. Here's what I get
on Oracle 8.1.7.1.
$c = $dbh->prepare('select 1 from dual', { ora_check_sql => 0});
for (1..10) { $c->execute }
SQL>select parse_calls, EXECUTIONS from v$sqlarea where SQL_TEXT = 'select 1
from dual'
PARSE_CALLS EXECUTIONS
I have snipped ALL previous discussion on this as I am finding it almost
impossible to see the wood from the trees now. If I understand you correctly
you have the following procedure:
create procedure roger
@p1 int = 0
as
if (@p1 >= 0) select * from systypes;
return(@p1)
You call it using $db
Hello all
I have an user who is trying to connect to a database on a ZOS 8.1.7.3
mainframe database using Perl DBI:DBD on a HP-UX 11.0 client
He can get character data back without any problems but all other types come
back as rubbish. The message he gets is given below - anyone got any ideas,
On Wed, 16 Oct 2002 10:57:36 +0100 Mark Buckle <[EMAIL PROTECTED]>
wrote:
> I know I'm possibly one of those 'born-every-minute' types, but I actaully
> bought the O'Reilly book and read it cover to cover
> before beginning with the DBI. Now I know DBI has moved on a few versions
> since then,
Waldemar Zurowski wrote:
>On Tue, 15 Oct 2002 12:56:36 +0100 (BST)
>[EMAIL PROTECTED] wrote:
>
>
>
>>I don't see any of this being the fault of DBD::ODBC. There are other
>>issues with the MS SQL Server ODBC driver and procedures (specifically
>>cursors) you might want to be aware of - search m
Jeff Urlwin wrote:
>
>
>>I rewrote my program using JScript and the OLEDB provider for ODBC. But
>>that didn't result in any use of "SET FMTONLY..." so I assume this is
>>something that Jeff is triggering in his code.
>>
>>
>
>Not directly -- only via ODBC calls.
>
>Jeff
>
I'm beginning to
On Tue, 15 Oct 2002 12:56:36 +0100 (BST)
[EMAIL PROTECTED] wrote:
> I don't see any of this being the fault of DBD::ODBC. There are other
> issues with the MS SQL Server ODBC driver and procedures (specifically
> cursors) you might want to be aware of - search microsoft's site as I
> don't have t
On Tue, Oct 15, 2002 at 04:50:35PM -0700, Scott wrote:
> When I use DBD::Oracle 1.12 with DBI 1.30 (I also saw this on
> 1.06/1.15) I see two parse_calls for every execute on all selects.
> Update/insert/delete just have 1 parse/execute. I have a simple test
> script.
>
> #!/usr/local/bin/perl -w
Rob,
I am using 9.2.0.0.0 database that brings HTTP webserver with it. But DBD and DBI are
not bundled with it. You have to install it yourself.
In the Oracle FAQ I read that it's the same with 9iAS. Don't know , why.
Knut
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTE
I know I'm possibly one of those 'born-every-minute' types, but I actaully
bought the O'Reilly book and read it cover to cover
before beginning with the DBI. Now I know DBI has moved on a few versions
since then, but the stuff I use every doesn't seem to have
changed one bit.
Mark.
-Origin
Hi Knut,
Are you using Oracle 9iAS ? Looking at the URL below:
http://otn.oracle.com/products/ias/daily/oct04.html
appears to suggest that DBI-Oracle is already bundled, or will be soon,
so hopefully it won't be required to actually compile it ...
Regards,
Rob
-Original Message
On Wed, 16 Oct 2002 00:56:11 -0700, Knut Herzog wrote:
>the perl I use is delivered with Oracle HTTP webserver. I am pretty sure I will never
>find out what compiler Oracle used.
You can try `perl -V`.
--
Bart.
Ilya,
the perl I use is delivered with Oracle HTTP webserver. I am pretty sure I will never
find out what compiler Oracle used.
Is there a chance to find out where the missing symbols come from, means wich library
is missing ?
Regards
Knut
-Original Message-
From: Sterin, Ilya [
29 matches
Mail list logo
