Top "Db2" questions

ASP.NET -- IIS7 -- IBM DB2 Issue

I'm working on a ASP.NET website that calls a DB2 database. I have Visual Studio installed on a Windows 2008 …

asp.net iis iis-7 db2

Connecting to an IBM AS/400 DB2 Database

I'm trying to connect to a client's IBM AS/400 DB2 Database from an Ubuntu Server using PHP's ODBC Driver. I …

ubuntu db2 ibm-midrange unixodbc

How to check the status of long running DB2 query?

I am running a db2 query that unions two very large tables. I started the query 10 hours ago, and it …

db2 status db2-luw

Auto Reconnect of Database Connection

I have a DBCP connection pool in Tomcat. The problem is that when the connection is lost briefly the appliction …

database tomcat jdbc db2 apache-commons-dbcp

iReport to DB2 connection ERRORCODE=-4499, SQLSTATE=08001

I am using Jasper iReport. When I try to connect to IBM DB2 I get an error: "Permission denied: ERRORCODE=…

db2 ireport

MS SQL Server 2008 "with (nolock)" equivalent for IBM DB2 9.7

In MS SQL Server 2008 you can write like this: FROM EMPLOYEE as A with (nolock) Is there an equivalent syntax …

sql-server db2 nolock

Can Hibernate default a Null String to Empty String

In our application we are pulling data from a DB2 mainframe database. If the database has "low values" in a …

java hibernate orm db2 castor

How to execute compound sql in DB2

I am facing a challenge trying to understand DB2 sql (note, I am coming from MS SQL Server) :P. Here …

sql db2 zos ibm-data-studio

Grouping by MONTH in SQL

I am trying to put together a table that will take a full date, YYYY-MM-DD, pull out only the month …

sql db2 ibm-midrange

Lob is closed. ERRORCODE=-4470, SQLSTATE=null

I am using IBM websphere commerce and db2, have following piece of code Clob clobVar = null; if (result.elementAt(3) != null) …

java jakarta-ee db2 websphere-commerce