Top "Db2" questions

DB2 is a family of database servers developed by IBM.

Differences between DB2 and Oracle

We had a talk with colleagues about databases yesterday as we will have a DB2 education in few weeks. I'm …

database oracle db2
How do I download the DB2 Data Server Provider 9.7 for .Net?

I have been successfully using Entity Framework 4.1 with my Sql Server for quite a while now. The company is integrating …

visual-studio-2010 entity-framework-4.1 db2 dataprovider
Existing DB2 column reported as not being a column of the table

In a Moodle 2 install running on DB2, deleting a user is unsuccessful, returning an error reading from database: Debug info: […

sql db2 moodle db2-luw
How to find table and column in DB2 with tbspaceid tableid specified in error message

I get following error message when trying to insert an object in the database: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: …

database db2 tablespace
DB2: Won't Allow "NULL" column?

Part of a complex query that our app is running contains the lines: ...(inner query) SELECT ... NULL as column_A, …

sql db2
How to do a safe "SELECT FOR UPDATE" with a WHERE condition over multiple tables on a DB2?

Problem On a DB2 (version 9.5) the SQL statement SELECT o.Id FROM Table1 o, Table2 x WHERE [...] FOR UPDATE WITH …

db2 database-deadlocks
How to write DB2 SELECT statement in unload job for delimiters

I have been over this... seems silly but couldnt figure out! I wanna UNLOAD a table but with a delimiter …

select db2 mainframe jcl
SQL1159 Initialization error with DB2 .NET Data Provider, reason code 2

I am trying to connect to DB2 from .NET 2.0 application in my development machine running windows 7 64 bit. I am getting …

c# .net db2
Performance of SQL comparison using substring vs like with wildcard

I am working on a join condition between 2 tables where one of the columns to match on is a concatentation …

sql optimization db2 ibm-midrange
Establish connection to db2 using the jt400.jar

I have tried using the db2jcc.jar and I successfully establish connection to db2 but now I am trying …

java jdbc db2 jt400 jtopen