RE: Wildcards
-Original Message-
From: Clinton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 3:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Wildcards
Thanks for the response Neil.
It did in 97. I think this has changed in Access2000. I tried
'A%' via Perl
and directly both with no success.
Sorry. Didn't type the whole thing. Should be like 'A%'.
That's the general syntax for what you are doing. Otherwise there might be
an error being generated, though this is probably the cause you should use {
RaiseError = 1} in the attributes of your database connection.
--Neil
Regards
CCJ
- Original Message -
From: Neil Lunn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 3:25 PM
Subject: RE: Wildcards
-Original Message-
From: Clinton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 3:11 PM
To: [EMAIL PROTECTED]
Subject: Wildcards
My problem is if I run the query from perl I get no response -
the program
runs to completion with no errors (using strict and w).
my $sql = SELECT custID, ac_name, ac_address FROM tblAccount
WHERE ac_state
= 'VICTORIA' AND ac_name = 'A*' ORDER BY ac_name;
= 'VICTORIA' AND ac_name = 'A%' ORDER BY ac_name;
The Access ODBC driver uses '%' instead just like SQL Server.
--Neil
___
___
Please Note :
Only the intended recipient is authorised to access or use
this e-mail.
If you are not the intended recipient, please delete this e-mail and
notify
the sender immediately. The contents of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies
unless expressly stated.
We use virus scanning software but exclude all liability for
viruses or
similar in any attachment.
__
Please Note :
Only the intended recipient is authorised to access or use this e-mail.
If you are not the intended recipient, please delete this e-mail and notify
the sender immediately. The contents of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies
unless expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
RE: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Given what someone else reported recently, try editing your script to add newline characters at the end of the username and password. Let me know if that fixes it. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
Re: DBI-1.19 leak?
Keep removing bits till the leak stops to find out which bit leaks.
Tim.
On Fri, Aug 17, 2001 at 01:30:51AM +0200, Toni Andjelkovic wrote:
the following code appears to leak memory with
DBI-1.19, but not with DBI-1.18. i tried with
perl-5.6.1.
can anyone confirm this?
# ---
use DBI;
use Getopt::Std;
getopts('n:', my $opt = {}) or die usage: $0 [-n loops]\n;
my $loops = $opt-{n} || 1;
for (1 .. $loops) {
my $dbh = DBI-connect(
'DBI:Pg:dbname=foobar;host=dbhost01;port=5432',
'dbuser',
'dbpassword',
);
my $sth = $dbh-prepare(SELECT * FROM Customer WHERE ID = 1);
$sth-execute;
my $hashref = $sth-fetchrow_hashref;
$sth-finish;
$dbh-disconnect;
print STDERR .;
}
# ---
cheers,
--
Toni Andjelkovic
[EMAIL PROTECTED]
RE: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Nop, same picture... :-( Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 12:50 PM To: Oleg Mechtcheriakov Cc: 'Tim Bunce'; [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 Given what someone else reported recently, try editing your script to add newline characters at the end of the username and password. Let me know if that fixes it. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
You'll have to try building one of the oci demo programs in $ORACLE_HOME/rdbms/demo and see if that connects okay. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
RE: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
OK, I've tried that. But the result is very tricky. When I did it first time it was OK, at least the connection was established. When I apply one minor change with the source file -- it doesn't work anymore even when I went back to the initial source code. It looks absolutely misterious but I'll try to sort it out somehow to have at least stable result. BTW, if I switch to DBI proxy -- how big would be slow-down? Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:26 PM To: Oleg Mechtcheriakov Cc: 'Tim Bunce'; [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 You'll have to try building one of the oci demo programs in $ORACLE_HOME/rdbms/demo and see if that connects okay. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
Re: DBI-1.19 leak?
Tim Bunce wrote on Fri, Aug 17 2001 (11:51:18 +0100): Keep removing bits till the leak stops to find out which bit leaks. even this leaks: my $dbh = DBI-connect(...); $dbh-disconnect; undef $dbh; this might stop it: --- DBI.xs.dist Fri Aug 17 16:00:36 2001 +++ DBI.xs Fri Aug 17 16:27:34 2001 @@ -948,0 +949 @@ + sv_free(_imp2com(imp_xxh, attr.FetchHashKeyName)); cu, -- Toni Andjelkovic [EMAIL PROTECTED]
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
On Fri, Aug 17, 2001 at 03:48:39PM +0200, Oleg Mechtcheriakov wrote: OK, I've tried that. But the result is very tricky. When I did it first time it was OK, at least the connection was established. When I apply one minor change with the source file -- it doesn't work anymore even when I went back to the initial source code. It looks absolutely misterious but I'll try to sort it out somehow to have at least stable result. Talk to Oracle. Till their own code works DBD::Oracle is unlikely to. BTW, if I switch to DBI proxy -- how big would be slow-down? This big |--| Try it. Tim. Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:26 PM To: Oleg Mechtcheriakov Cc: 'Tim Bunce'; [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 You'll have to try building one of the oci demo programs in $ORACLE_HOME/rdbms/demo and see if that connects okay. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: Hi, thanks for a reaction. Here comes the protocol of my SQLPLUS session: == root@XXX:/root sqlplus scott/tiger@VENUS SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected to: Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production SQL select count(*) from emp; COUNT(*) -- 14 SQL exit Disconnected from Oracle8 Release 8.0.6.0.0 - Production PL/SQL Release 8.0.6.0.0 - Production root@XXX:/root == Select is made just to make sure that it really works:-) And it is really the Oracle instance on the remote host as can be seen from version numbers... Reg's Oleg -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 5:40 PM To: Oleg Mechtcheriakov Cc: [EMAIL PROTECTED] Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. With what command line, exactly? P.S. Forgot to say that to get to that point we had to recompile Perl and DBI/DBD without threads support. Without that we saw just segmentation faults... Such is the way with threads and perl. Tim.
Re: DBI-1.19 leak?
On Fri, Aug 17, 2001 at 04:32:31PM +0200, Toni Andjelkovic wrote: Tim Bunce wrote on Fri, Aug 17 2001 (11:51:18 +0100): Keep removing bits till the leak stops to find out which bit leaks. even this leaks: my $dbh = DBI-connect(...); $dbh-disconnect; undef $dbh; this might stop it: --- DBI.xs.dist Fri Aug 17 16:00:36 2001 +++ DBI.xs Fri Aug 17 16:27:34 2001 @@ -948,0 +949 @@ + sv_free(_imp2com(imp_xxh, attr.FetchHashKeyName)); Excellent. Many thanks. Tim.
When DBI::err gets overwritten
Hi. I understand that DBI::err is very transient. My question is, is it going to get overwritten in between the different calls in selectcol_array? That is, I'm doing: my $arrayref = $dbh-selectcol_arrayref($statement, undef, @bind) or die($dbh-errstr()); my @arr = @$arrayref; I realized that this won't check for all possible errors, because if there's an error during selectcol's first fetch, it will just return [] (as far as I can tell, from the docs saying it returns all the information it has so far). I could add: die $dbh-errstr() if !@arr $DBI::err; Or, I could do just one test by changing the code to: my $arrayref = $dbh-selectcol_arrayref($statement, undef, @bind); die($dbh-errstr()) if $DBI::err; my @arr = @$arrayref; However, both these methods require that DBI::err will still be set at the right time. So, will either these work, or is there a different way to do it? Amir Karger Curagen Corporation LEGAL NOTICE - Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
SET TRANSACTION READ ONLY / SET TRANSACTION USE ROLLBACK SEGMENT
O.K. Excuse my ENGLISH, but i try to tell to you my problem, if any body can undestand in spanish and can translate to english best. I use this sentences: Set Transaction read only / Set transaction use rollback segment , in perl's progrmas, but still use any rollback, and my idea is that use none or one in exclusive, from PERL. The version is ORACLE 8.1.7, and PERL 5.003. One more time: excuse my english, i promise to you be better about this. Thanks, Hugo Gonzalez. --- 0 - Buenos Dias: Utilizando ORACLE 8.1.7 y PERL 5.003 Al utilizar sentencias en PERL : Set Transaction read only / Set transaction use rollback segment , y no lo aplica en el programa donde lo utilizo, Y por supuesto siempre termina con SNAP SHOT TOO OLD Hugo Gonzalez.
Re: SET TRANSACTION READ ONLY / SET TRANSACTION USE ROLLBACKSEGMENT
On Fri, 17 Aug 2001, Hugo A. Gonzalez F. wrote: .. I use this sentences: Set Transaction read only / Set transaction use rollback segment , in perl's progrmas, but still use any rollback, and my idea is that use none or one in exclusive, from PERL. The version is ORACLE 8.1.7, and PERL 5.003. $dbh-do(SET TRANSACTION USE ROLLBACK SEGMENT U7); seems to work for me.. -- Orlando Andico [EMAIL PROTECTED] Mosaic Communications, Inc. -BEGIN GEEK CODE BLOCK- Version: 3.12 GE d(-) s: a-25 C UBLSI$ P+++ L+++ E- W++ N(+) o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@ b++ DI++ G e++@ h--(*) r% y+ --END GEEK CODE BLOCK--
Re: SET TRANSACTION READ ONLY / SET TRANSACTION USE ROLLBACK SEGMENT
On Fri, Aug 17, 2001 at 12:26:29PM -0400, Hugo A. Gonzalez F. wrote:
O.K.
Excuse my ENGLISH, but i try to tell to you my problem, if any body can
undestand in spanish and can translate to english best.
I use this sentences: Set Transaction read only / Set transaction
use rollback segment , in perl's progrmas, but still use any
rollback, and my idea is that use none or one in exclusive, from PERL.
Okay... Hugo is doing Set Transaction statements that should change how
his queries use rollback segments, but the behavior of his queries isn't
actually changing.
Have you turned off AutoCommit? With AutoCommit on, I think that the Set
Transaction will last only for the duration of the Set Transaction
statement.
You can turn off AutoCommit when you connect:
$dbh = DBI-connect($dsn, $username, $password, { AutoCommit = 0 });
or sometime after you connect:
$dbh-{AutoCommit} = 0;
Also, after you call $dbh-commit(), I think you will need to do the Set
Transaction statement again.
The version is ORACLE 8.1.7, and PERL 5.003.
Are you really using perl5.003, or did you mean perl5.005_03? perl5.003 is
quite old.
I hope that's helpful!
Ronald
AM I GETTING TO THE USER GROUP??? --How to install DBI on AIX; need DBDSybase and DBDOracle to work
-Original Message- From: Rice, Wayne R (Sybase) Sent: Thursday, August 16, 2001 1:56 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: How to install DBI on AIX; need DBDSybase and DBDOracle to work Anyone, (Eric of Sybase, can you help me/Wes with this?) This is my third attempt at getting a reply from the [EMAIL PROTECTED] group. PLEASE, ANYONE SAY SOMETHING SO I KNOW I'M GETTING THROUGH. I need to gain access to Oracle and Sybase on an AIX Unix system via trying to install DBI (non-ActiveStat DBI). I tried perl makefile.pl; make; etc. as the README suggested to no avail. Please advise what steps do I need to follow to get things to work on this platform. Wes Stephens, also in this email, will receive any mail in reply as I may be out some of next week so please reply to ALL. (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages on NT for this and it all went smooth...) But getting DBI to work (makefile.pl, make, etc) has not been possible. Could someone reply from the user group so I know I'm getting through please... THANKS IN ADVANCE! Any help will be greatly appreciated!!! Here are the files requested per Mr. Bunce re the runtimes and perl -V environment ... Thank You, Wayne Rice Sybase, Inc.
Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Rice, Wayne R (Sybase) writes: Anyone, I need to gain access to Oracle and Sybase on an AIX Unix system. I tried perl makefile.pl; make; etc. to no avail. Please advise what steps do I need to follow to get things to work on this platform. (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. ricew@spnode01 perl makefile.pl Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi /u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI /u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase /usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 /usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at DBI.pm line 185 BEGIN failed--compilation aborted at DBI.pm line 185. BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Michael, To clear things up a little, I have my Sybase laptop with Windows 2000 which has Active State installed. I then used the PPM to install my DBI and Sybase and Oracle DBDs. This is one environment where things work ok. The other environement which is going to be the official production environment is UNIX AIX. I am having no success here. Now, you say to type perl Makefile.PL (noting caps). However, after expanding the file after the download, the file is all lowercase. The way I expand it is to use my NT 4.0 workstation using winzip. Then I ftp the files over to a unix folder where it is lowercase. Then I type 'perl makefile.pl'. Can I use winzip and ftp the files as I have? Where should I put the expanded files on my unix server? What authorization do I need to do the work (i.e. root level)? Concerning the PERL5LIB variable, it is not set... see below... ricew@spnode01 echo $PERL5LIB /u/ricew ricew@spnode01 Thanks, Wayne -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:14 PM To: Rice, Wayne R (Sybase) Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work Rice, Wayne R (Sybase) writes: Anyone, I need to gain access to Oracle and Sybase on an AIX Unix system. I tried perl makefile.pl; make; etc. to no avail. Please advise what steps do I need to follow to get things to work on this platform. (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. ricew@spnode01 perl makefile.pl Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi /u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI /u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase /usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 /usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at DBI.pm line 185 BEGIN failed--compilation aborted at DBI.pm line 185. BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to wo rk
I've been working with AIX, DBI and DBD::Oracle since 1998, I installed them with differents versions of AIX, Oracle, DBI, DBD::Oracle and C compilers and never had big problems. I recommend that you transfer the 'tarball' file to the AIX box and then unpack it. Some windows ftp clients don't care about uppercase and lowercase. Best regards, Marcelo Rice, Wayne R (Sybase)To: 'Michael Peppler' [EMAIL PROTECTED], Rice, Wayne R RiceWR@navair(Sybase) [EMAIL PROTECTED] .navy.mil cc: '[EMAIL PROTECTED]' [EMAIL PROTECTED], '[EMAIL PROTECTED]' [EMAIL PROTECTED], 17/08/2001'[EMAIL PROTECTED]' [EMAIL PROTECTED], 14:49 '[EMAIL PROTECTED]' [EMAIL PROTECTED] Please respond Subject: RE: How to install DBI on AIX; need DBDSybase and DBDOracle to Rice, to wo rk Wayne R (Sybase) Michael, To clear things up a little, I have my Sybase laptop with Windows 2000 which has Active State installed. I then used the PPM to install my DBI and Sybase and Oracle DBDs. This is one environment where things work ok. The other environement which is going to be the official production environment is UNIX AIX. I am having no success here. Now, you say to type perl Makefile.PL (noting caps). However, after expanding the file after the download, the file is all lowercase. The way I expand it is to use my NT 4.0 workstation using winzip. Then I ftp the files over to a unix folder where it is lowercase. Then I type 'perl makefile.pl'. Can I use winzip and ftp the files as I have? Where should I put the expanded files on my unix server? What authorization do I need to do the work (i.e. root level)? Concerning the PERL5LIB variable, it is not set... see below... ricew@spnode01 echo $PERL5LIB /u/ricew ricew@spnode01 Thanks, Wayne -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:14 PM To: Rice, Wayne R (Sybase) Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work Rice, Wayne R (Sybase) writes: Anyone, I need to gain access to Oracle and Sybase on an AIX Unix system. I tried perl makefile.pl; make; etc. to no avail. Please advise what steps do I need to follow to get things to work on this platform. (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. ricew@spnode01 perl makefile.pl Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi /u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI /u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase /usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 /usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at DBI.pm line 185 BEGIN failed--compilation aborted at DBI.pm line 185. BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Maybe I've missed something... but I'd recommend not using a tarball directly and just use the CPAN module to install it: perl -MCPAN -e install 'DBI' perl -MCPAN -e install 'DBD::Sybase' perl -MCPAN -e install 'DBD::Oracle' assuming you have a standard setup on your box, you can probably just select the defaults for everything and let CPAN.pm do all the dirty work. This is pretty much the same way PPM works with ActiveState. HTH, Curt
RE: Java error with Perl DBI
I have the following: #LogR'WriteHTMLPage(5a Entering connect, about to connect); #exit; $dbh = DBI-connect(dbi:Oracle:infotest,globalcomm, global_comm); LogR'WriteHTMLPage(5b Entering connect, about to connect); exit; If I leave the first log statement and exit commented in, it produces the html page ok, but when I comment it out ( as shown above) the 2nd WriteHTMLPageand exit never executes (I dont believe it gets that far), and the Java error mentioned below ends up in the Netscape server log. Dave Halliwill Infobus Technology Solutions Intranet Strategy and Access IS Applications Solutions Nortel Networks 615-432-4382 (ESN 222) [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:46 PM To: Halliwill, Dave [NASH:8M90:EXCH] Subject: Re: Java error with Perl DBI How about posting your connect statement to the list? Does the same page run ok if you comment out the DBI-related code? Dave Halliwill [EMAIL PROTECTED] on 08/17/2001 03:37:11 PM To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] cc:(bcc: Wesley Sheldahl/Lex/Lexmark) Subject: Java error with Perl DBI I'm trying to use DBI, along with DBD::Oracle to port an application, and alter it from using Informix (DBD::Informix, I believe). When executing the DBI-connect statement, my Netscape Webserver is giving the following truncated message: [17/Aug/2001:11:47:42] failure (11594): for host 47.185.72.182 trying to POST /cgi-bin/step_1.cgi, cgieng_scan_headers reports: the CGI program /disc1/webs/2001/cgi-bin/step_1.cgi did not produce a valid header (name without value: got line you must install a solaris patch to run this version of the java runtime.) I'm thinking this may be because DBD::JDBC was also installed on this machine, and possibly DBI is trying to use DBD::JDBS instead of DBD::Oracle I'm wondering 1.) How I can tell what all is installed properly (I didnt set perl up on this box myself) 2.) How I can tell what driver DBI is set to use. 3.) How to uninstall JDBC, or what solaris patch I need to get to alleviate the error Below is a list of some of the file showing whats on the machine. Any help is greatly apprieciated Dave Halliwill Infobus Technology Solutions Intranet Strategy and Access IS Applications Solutions Nortel Networks 615-432-4382 (ESN 222) [EMAIL PROTECTED] # find . -name *DBD* -print ./usr/dt/share/include/uil/UilDBDef.h ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI/DBD.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD ./usr/local/lib/perl5/site_perl/5.6.0/DBD ./usr/local/man/man3/DBD::Proxy.3 ./usr/local/man/man3/DBD::ADO.3 ./usr/local/man/man3/DBI::DBD.3 ./usr/local/man/man3/DBD::Multiplex.3 ./usr/local/man/man3/DBD::Oracle.3 ./usr/local/man/man3/DBD::Oraperl.3 ./usr/local/man/man3/DBD::JDBC.3 ./export/home/jlocum/DBD-Oracle-1.05 ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/auto/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/arch/auto/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oracle.3 ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oraperl.3 ./export/home/jlocum/tars/DBD-Oracle-1.05.tar ./export/home/jlocum/tars/DBD-JDBC-0.63.tar ./export/home/jlocum/tars/SUNWj2dem/reloc/demo/JAVA1.2/demo/ jfc/DBDemos ./export/home/jlocum/DBI-1.14/lib/DBD ./export/home/jlocum/DBI-1.14/lib/DBI/DBD.pm ./export/home/jlocum/DBI-1.14/blib/lib/DBD ./export/home/jlocum/DBI-1.14/blib/lib/DBI/DBD.pm ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Proxy.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBD::ADO.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::DBD.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Multiplex.3 ./export/home/jlocum/DBD-JDBC-0.63 ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/auto/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/arch/auto/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/man3/DBD::JDBC.3 # find . -name *DBI* -print ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBIXS.h ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.so ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.bs ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Win32/DBIODBC.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Bundle/DBI.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI ./usr/local/man/man3/DBI::ProxyServer.3
Help with concatenating record segments pulled from a DBIQuery
Hello:
Relevant background info: I program in an academic library, using Perl/DBI to connect
to our Oracle8 database and query information about our books, etc.. Each book has a
record, called a MARC record, which contains various information about Title, Size,
Call Number, etc. This MARC record is contained in one or more record segments in the
database. What I need to do for my latest project is string these record segments
together to form the whole MARC record.
So for every book that has ID=X, I need to concatenate the record segments into a
unified whole, so that I can use the Perl module MARC.pm which parses through the
various parts of a MARC record to give very granular results... The catch : MARC.pm
can only recognize whole MARC records, not a record segment that may be lopped off in
the middle of a field somewhere, which is why I need to concatenate and create only
one supersegment for each ID number.
Any ideas on how to do this within the return loop of a DBI query?
A rough example of oversimplified code is below:
use DBI;
### Grab the ID and Record Segments ###
select
id
segment
from
table1
where
id 52
id 99
while (@row = $sth-fetchrow_array)
{
$id = $row[0];
$seg = $row[1];
then, I need something like (sorry for the mix of Perl and English) -
if ($id = another $id during the loop)
{
pull together the $seg from each $id and call the new supersegment $full_record;
}
### Basically, I am trying to make it so that if two or more record segments exist for
a single ID, collapse those record segments by joining them together ###
use Marc.pm;
### Now parse through the MARC record with my newly created Supersegments ###
etc.
etc.
Thanks in advance for your help on this hard-to-describe problem...
Jeff
Jeff Suszczynski
Systems Department, Rush Rhees Library
University of Rochester
716.275.1060
RE: Help with concatenating record segments pulled from a DBIQuery
Very easily, you can either use || within your query and select from
multiple tables, if that's not possible due to complexity, then you just
select as many segments as you can (means run many queries) and then
concatinate them into a perl string. This is also not really related to
DBI, but rather to general programming and a little SQL.
Hope this helps you, if I understood the question right.
Ilya
-Original Message-
From: Jeff Suszczynski [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 12:17 PM
To: [EMAIL PROTECTED]
Subject: Help with concatenating record segments pulled from a DBIQuery
Hello:
Relevant background info: I program in an academic library,
using Perl/DBI to connect to our Oracle8 database and query
information about our books, etc.. Each book has a record,
called a MARC record, which contains various information about
Title, Size, Call Number, etc. This MARC record is contained in
one or more record segments in the database. What I need to do
for my latest project is string these record segments together to
form the whole MARC record.
So for every book that has ID=X, I need to concatenate the record
segments into a unified whole, so that I can use the Perl module
MARC.pm which parses through the various parts of a MARC record
to give very granular results... The catch : MARC.pm can only
recognize whole MARC records, not a record segment that may be
lopped off in the middle of a field somewhere, which is why I
need to concatenate and create only one supersegment for each ID number.
Any ideas on how to do this within the return loop of a DBI query?
A rough example of oversimplified code is below:
use DBI;
### Grab the ID and Record Segments ###
select
id
segment
from
table1
where
id 52
id 99
while (@row = $sth-fetchrow_array)
{
$id = $row[0];
$seg = $row[1];
then, I need something like (sorry for the mix of Perl and English) -
if ($id = another $id during the loop)
{
pull together the $seg from each $id and call the new
supersegment $full_record;
}
### Basically, I am trying to make it so that if two or more
record segments exist for a single ID, collapse those record
segments by joining them together ###
use Marc.pm;
### Now parse through the MARC record with my newly created
Supersegments ###
etc.
etc.
Thanks in advance for your help on this hard-to-describe problem...
Jeff
Jeff Suszczynski
Systems Department, Rush Rhees Library
University of Rochester
716.275.1060
