UDB DB2 and Perl DBI

- Weitergeleitet von Michael Hartmann/D292812/Trinkaus/DE am 10.01.2003 08:08 - Michael Hartmann

Re: UDB DB2 and Perl DBI

[EMAIL PROTECTED] writes: > I worte a perl cgi script invoking Perl DBI to > query a few tables and display values on > a web browser and I am receving this error > message. Any help? > > The error was: DBI->connect(sample) failed: Total Environment allocation > failure! Did you set up your DB2 c

Re: Why can't use SQL "GROUP BY..."?

On Thu, 9 Jan 2003 22:59:03 +0800 (CST), [EMAIL PROTECTED] (Gary fung) wrote: > My coding is similar as: > > $value2 = $dbh->prepare("SELECT page FROM $Table > > GROUP BY page") || die "Couldn't add record, ".$dbh->errstr(); > > Whenever I use "GROUP BY.." , an error statement will go out : >

Re: Can't locate Thread.pm in @INC

Hi, Thank you for the kind advice. I copied Thread.pm (from Thread_52.tar.gz) to Net -> Daemon -> Thread.pm Then I got myself aen error:_ Can't locate object method "bootstrap" via package "Thread" at D:/Perl/site/lib/ Net/Daemon/Thread.pm line 18. So, I commented:- # bootstrap Thread; Now, I g

Re: Can't locate Thread.pm in @INC

Hi, Sorry, a typo. I am using Perl 5.005 (build 522). I was using Perl 5.6. But when DBI::Proxy (on Win XP) accepting connection from Client (on Linux). The error message says the current Perl 5.6 uses iThread, BUT DBI:Proxy needs Thread (supported in 5.005 not 5.6 and above). That is why

RE: List files - Thanks and new one :-)

http://listserv.ActiveState.com/mailman/mysubs perl-win32-users & perl-unix-users lists are good for this :) anyway, you can use object orientation and use ++ operator on $self->{my_counter} in the sub you want > -Original Message- > From: Brian McCain [mailto:[EMAIL PROTECTED]] > Sent:

Re: List files - Thanks and new one :-)

This is really off-topic for this list. The DBI-users list is supposed to be for questions related to the DBI perl module. - Original Message - From: "Don Mathews" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 4:10 PM Subject: RE: List files - Thanks and new

Re: List files - Thanks and new one :-)

Don Mathews wrote: I have a subroutine say FOO in my program. This mailing list is about DBI. If you have questions that aren't directly related to DBI, please send them to a more appropriate place, for example comp.lang.perl.misc. -- Jeff

RE: List files - Thanks and new one :-)

Thanks to all who replied. Now for a slightly tougher one . I have a subroutine say FOO in my program. Before my program executes I want to know how may times FOO is called in my program which is going to execute. Kind of parser ? Any design ideas? samples ? will be appreciated ! Don ___

RE: List files

or: #!usr/bin/perl -w use strict; my $dir = shift or die "Usage: $0 "; my $type = shift or die "Usage: $0 "; chdir $dir; while (<*>) { print "$_\n" if $_ =~ m,$type,i; } __END__; call it like: perl.pl /my/dir txt > -Original Message- > From: Cary Penington [mailto:[EMAIL PROTEC

Re: List files

try this open (OUT, "ls -1 $target_dir/bin/$foo.*.dat|") || die "can not list the dir/file $!"; my @files = ; this will include $target_dir/bin/ and end line character, need process if necessary hope this is what you want. zlm - Original Message - From: "Don Mathews" <[EMAIL PROTECTED]>

RE: List files

use DirHandle; my @files = (); # your array to hold the files found my $PATH = ""; opendir DIR, $PATH or die "Unable to open ".$PATH." folder!"; # put your pattern here following the grep command, # this pattern gets *.dat files from $PATH @files = grep /\w+\.(dat)/, readdir DIR; if ($#f

Using perl to startup/shutdown database

I have search through the archives and read the manuals (probably missed the answer) I can connect to an Oracle database as sysdba using DBD::Oracle, now can I shutdown and startup the database using the DBI/DBD? Thanks Mike -- Michael W. Bates Fairbanks, AK 99708 Email: mailto:[EMAIL PROTECTE

List files

Hello: I need to list all the files matching a pattern in a directory.Can anyone provide an example to do that. eg. I would do $target_dir/bin/ls $foo.*.dat in UNIX. I want to do the same thing in perl and just store the names of all the $foo.*.dat files in a temporary array which I can manip

Re: Problem Pg.pm ? DBI ?

I use DBD::Pg on a Mac OS X 10.2.3 box every day, and have since 10.1.1. It works fine, and should work equally well on Mac OS X Server. However, since you're asking whether you should switch to DBI, I'm guessing that you're not actually using DBD::Pg, but PGPerl. That's a separate project, ind

UDB DB2 and Perl DBI

I worte a perl cgi script invoking Perl DBI to query a few tables and display values on a web browser and I am receving this error message. Any help? The error was: DBI->connect(sample) failed: Total Environment allocation failure! Did you set up your DB2 client environment? at testdisplay.pl line

RE: Can't locate Thread.pm in @INC

First, take a look to see where Thread.pm actually resides, If its path is ~/pathToThread, add a 'use lib' directive to your script use lib ('~/pathToThread'); This prepends the specified directory to @INC Also, make sure you are referring your script to the right interpreter.Use # ~/pathToTh

Problem Pg.pm ? DBI ?

I am very disapointed to see that I can't make Pg.pm work on my macOSX server, I have a lot of perl done usint Pg.pm A Friend tol me that dbi is doing almost the same, and that Pg.pm is not compatible with current perl version. I have a Postgresql database I would prefer not to rewrite all my scr

RE: Licence

In general, you would not have a problem distributing the compiled, unaltered Perl binaries to your company. In addition, you are even allowed to alter the source and distribute it to your company, so long as you include a reference to where you obtained the source. It really isn't much of an is

Re: Licence

On Thu, 9 Jan 2003 05:40:54 -0800 (PST) steve hatfield <[EMAIL PROTECTED]> wrote: > I need to know if I download the Perl source code for windows nt and > use a compiler to complile it would I need a licence to distribute it > out to clients for my company. > > > > Please get back to me with t

Re: (Fwd) DBD::Oracle - interface

On Thu, 9 Jan 2003 12:21:39 + Tim Bunce <[EMAIL PROTECTED]> wrote: > - Forwarded message from [EMAIL PROTECTED] - > > Delivered-To: [EMAIL PROTECTED] > Subject: DBD::Oracle - interface > To: [EMAIL PROTECTED] > From: [EMAIL PROTECTED] > Date: Thu, 9 Jan 2003 10:55:55 +0100 > I have a

Re: Why can't use SQL "GROUP BY..."?

Could be that page does not exist in the table you are trying to query, or that $Table is not set or calling a non-existant table... Try printing out $Table by itself before calling the SQL statement. On Thu, 2003-01-09 at 10:09, Francis Henry wrote: > Hi Gary: > > What happens when you run the

Re: Why can't use SQL "GROUP BY..."?

Hi, Is $Table defined before the prepare is executed? I've used group by in perl without issues. The error returned is complaining about a missing table name, so I can only conclude that $Table is either blank or undef when the prepare statement is executed by perl. Regards, Michael Nha

Re: Can't locate Thread.pm in @INC

On Thu, 9 Jan 2003 17:00:06 +0800 pevee <[EMAIL PROTECTED]> wrote: > I encounter this message when I run the > dbiproxy --configfile=c:\tmp\dbiproxy.conf. > How can I fix it? > > Can't locate Thread.pm in @INC (@INC contains: C:/Perl/lib > C:/Perl/site/lib .) at C:/Perl/site/lib/Net/Daemon.pm lin

Re: Why can't use SQL "GROUP BY..."?

Hi Gary: What happens when you run the SQL statement by itself, outside of the perl script? The error seems to lie with the SQL and not with perl/DBI. Once you're sure that the SQL statement works by itself, then put it into your script. Regards, Francis Gary Fung wrote: > Hi, > > I have

RE: Why can't use SQL "GROUP BY..."?

What DB are you using. Just as a matter of interest what happens if you make it "SELECT page,count(*) FROM $Table GROUP BY page" Also I don't know if this is really the statement you want to execute but the same effect can be acheived with "SELECT DISTINCT page FROM $Table" Ken. -Original

Why can't use SQL "GROUP BY..."?

Hi, I have a Perl program using DBI. I don't know why it will cause error when I use "GROUP BY..." in SQL "SELECT" statements. My coding is similar as: $value2 = $dbh->prepare("SELECT page FROM $Table GROUP BY page") || die "Couldn't add record, ".$dbh->errstr(); Whenever I use "GROUP BY

Licence

Could someone please Help.. I need to know if I download the Perl source code for windows nt and use a compiler to complile it would I need a licence to distribute it out to clients for my company. > > Please get back to me with this issue. Thanks, Steve - Do

Re: CLOB substrings

Hi Josh, Yo may wish to investigate the Oracle Intermedia option. It allows complex statements against LOBs using the Oracle SQL extension CONTAINS An example SELECT title, author FROM books WHERE content CONTAINS 'whatever you need to match'; There are no meaningful size limitations, it

(Fwd) DBD::Oracle - interface

- Forwarded message from [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Subject: DBD::Oracle - interface To: [EMAIL PROTECTED] From: [EMAIL PROTECTED] Date: Thu, 9 Jan 2003 10:55:55 +0100 Hi! Sorry for my bad English... I have a question according to your DBD::Oracle-interface... I

Can't locate Thread.pm in @INC

Hi, I encounter this message when I run the dbiproxy --configfile=c:\tmp\dbiproxy.conf. How can I fix it? Can't locate Thread.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) a t C:/Perl/site/lib/Net/Daemon.pm line 267. I am using Perl 5.19 because I wish to use Thread rather than iThr