Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh->prepare($stmt) or die "Prepare Failed\n";
DBD::DB2 doesn't seem to return false values for failures. Instead, try
checking the sqlstate of the db handle:
my $sth = $dbh->prepare($stmt);
if ($dbh->
On Wed, Nov 05, 2003 at 08:55:16AM -0500, Anderson, James H [IT] wrote:
> As the subject says, I'm looking for a DB2 DBD (I'm running on Mac OS X).
Check with IBM:
http://www-3.ibm.com/software/data/db2/perl/
It should work wherever you can get perl and DBI to work, as long as
you can also get t
On Thu, Jun 26, 2003 at 10:44:00AM -0400, Craig Sharp wrote:
> I have done multiple combinations of #2 above but still get the
> following error on connect:
>
> DBI->connect(ISDEV) failed: Total Environment allocation failure!
> Did you set up your DB2 client environment? at domain_ret.pl line 13
On Tue, Jun 10, 2003 at 10:50:13AM +1000, James Collins wrote:
> Has anyone else in the world tried running his combination yet??
We've been trying to move from DB2 7 to DB2 8, and have used DBD::DB2
compiled against the V7 client libraries against a V8 server without
any problem.
We haven't
On Thu, Jun 05, 2003 at 10:32:58PM +0200, Bart Lateur wrote:
> FWIW, MySQL allows the syntax
>
> SELECT * FROM database.table
>
> where "table" is the name of a table in the database with name
> "database". I'm not sure how standard that is :)
Much more standard is:
SELECT * FROM schema
On Wed, May 28, 2003 at 12:31:33PM -0400, Thomas Good wrote:
> Hi, how does one use LIKE and a wildcard with variable binding??
>
> $q = qq |select * from x where y like ?|;
> ...
> $sth->execute($some_variable)
>
> where does the % go??
my $some_variable = '%here%';
The placeholder variables g
On Tue, Apr 01, 2003 at 10:26:51AM -0800, Karyn Ulriksen wrote:
> I think I've had my head buried in code too long. Why in god's
> creation is www.cpan.org now going to Matt's Script Archive?
Check the date...
-johnnn
