Top "Db2" questions

DB2 is a family of database servers developed by IBM.

Is there any opensource DB2 client?

I am using db2 version 7 , i need an windows application (similar to MSSQL) to do the database operations.

db2
How do I write a query that outputs the row number as a column?

How do I write a query that outputs the row number as a column? This is DB2 SQL on an …

sql db2
Make a column nullable in DB2 when Data Capture is enabled

I'm using db2 version 9.7* and it seems impossible to make a NOT NULL column nullable in any straightforward way. Unfortunately …

db2 nullable alter non-nullable notnull
Does DB2 have an "insert or update" statement?

From my code (Java) I want to ensure that a row exists in the database (DB2) after my code is …

sql database db2 insert-update upsert
decimal(s,p) or number(s,p)?

recently, while working on a db2 -> oracle migration project, we came across this situation. the developers were inadvertently …

oracle db2 ansi type-conversion
DB2 Comma Separated Output by Groups

Is there a built in function for comma separated column values in DB2 SQL? Example: If there are columns with …

sql db2 db2-luw
ERRORCODE=-4461, SQLSTATE=42815 in DB2

I have exported some data from schema A (table x)to XML and I am reading the XML and inserting …

java sql db2
Way to decrease column length in DB2

Is there a way to decrease the column length in DB2? Say I have a table temp with column col1 …

sql database db2
How to get table name from column in DB2?

I need the db2 sql query to find the table/tables from column name. I have the column name but …

sql db2 tablename columnname
Insert throws SQLCODE: -180, SQLSTATE: 22007 on IBM DB2

I'm using a data integration tool (Talend) to insert some rows on a IBM Db2, but the following command throws …

db2 talend