Top "Db2-luw" questions

DB2 for Linux, UNIX and Windows

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
Failing update table in db2 with SQLCODE: -668, SQLSTATE: 57016, SQLERRMC: 7;

I am using db2 9.5 i have created a column in table which is created successfully but i am not able …

sql database db2 db2-luw
Db2 connection problem with java

I am having problem with DB2. I just installed the db2 as a db2admin and with a password. When …

java jdbc db2 db2-luw
DB2: Purge large number of records from table

I am using DB2 9.7 FP5 for LUW. I have a table with 2.5 million rows and I want to delete about 1 …

database performance db2 db2-luw
how can I rename a table / move to a different schema in sql DB2?

I am trying to rename a table in db2 like so rename table schema1.mytable to schema2.mytable but getting …

db2 rename db2-luw
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 constraints columns in DB2

I want to know the columns (names) which belong to each unique constraint. I can easily find the constraints and …

db2 constraints db2-luw
SQL update from one Table to another based on a ID match IN db2

The Query below is suited in SQL sErver. But in DB2 it does not give results: Error is SQLCODE = -199, …

db2 sql-update db2-luw correlated-subquery
db2 not listening for TCPIP connection on localhost

I am not able to connect my db2 application to my localhost database. The db2 API used by the application …

db2 db2-luw
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