Top "Db2" questions

DB2 is a family of database servers developed by IBM.

Listagg alternative in db2

My customer is using db2 database without listagg function, but I need to somehow aggregate the primary key information within …

Read More
sql db2 db2-luw
How to apply a method to a parameter in MyBatis

After reading about Mapper XMLs I can't help to wonder how one might go about appling some common transforms to …

Read More
db2 mybatis ognl
DB2 database directory shows DB that does not exist

I have an old test database showing when I run db2 list database directory Database 8 entry: Database alias = TEST_AN …

Read More
db2 db2-luw
DB2: How to insert a clob with line breaks

I have a simple thing which I want to do, yet is so frustrating in attempting and completing. I just …

Read More
sql db2 clob
get the list of db2 tables which have been changed since a particular timestamp say since 20120801185856 timestamp

Is there any way in IBM DB2 to get the list of tables which have been changed(updated/added/deleted) …

Read More
db2 database-restore
How to calculate maximum length of VARCHAR type in DB2?

According to this: VARCHAR(n) Varying-length character strings with a maximum length of n bytes. n must be greater than 0 …

Read More
sql db2 varchar page-size
How to get the IBM DB2 provider to work with Entity Framework 4.0

Can someone please tell me how to get the DB2 provider to show up in the "Change Data Source" dialog …

Read More
visual-studio db2 entity-framework-4 provider
Run a SQL query on a DB2 file with a dot "." in the name?

I have a DB2 file with a name like "my.test". The DB2 filename contains a dot '.' If …

Read More
db2 ibm-midrange
Get Distinct property values from List

I am trying to get distinct FullNames from a list that contains FullNames and IDs then displaying these in a …

Read More
c# wpf db2
DROP DATABASE fails

I have a DB2 database (let's call it mydb) that I would like to delete. However, when I do db2 …

Read More
db2 db2-luw