Top "Db2-luw" questions

DB2 rownum equivalent

I have the below query in Oracle which I want to replicate in DB2 which uses the random function and …

sql db2 db2-luw

How do I find the size of a DB2 (luw) database?

I know you can look at the size of an uncompressed backup, but that's not practical. Is there a command …

database db2 admin db2-luw

Listagg alternative in db2

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

sql db2 db2-luw

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 …

db2 db2-luw

DROP DATABASE fails

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

db2 db2-luw

IBM DB2: Generate list of dates between two dates

I need a query which will output a list of dates between two given dates. For example, if my start …

sql db2 db2-400 db2-luw

String operation in SQL to reverse a string

In DB2 9.7 I am looking for a way to reverse a string in a SQL query. I am familiar with …

sql db2 reverse db2-luw

How to rebuild index in DB2 9.7 LUW

How I can rebuild index in DB2 9.7 LUW. Is there any rebuild utility for index or I have to recreate …

db2 db2-luw db2-connect

How does the HEXTORAW() function work? What is the algorithm?

HEXTORAW is a function found in several RDBMS's like Oracle, and DB2 on LUW. It takes a character, or integer …

sql oracle algorithm rdbms db2-luw