A well-designed database schema forms the foundation of a high-performing and efficient IBM Db2 database... and therefore, also serves as th...

DB2 can use both DECIMAL and FLOAT data types to store non-integer numeric data. But the two are not equivalent. In general, use DECIMAL in...

Most DBAs have grappled with the pros and cons of choosing one data type versus another. Sometimes the decision is easy, whereas sometimes t...

The term "data integrity" can mean different things to different people and at different times. But at a high level, there really ...

DB2 allows you to add and subtract DATE, TIME, and TIMESTAMP columns. In addition, you can add date and time durations to, or subtract them ...

Here is a follow-up question and answer based on my previous blog post : Q: My format does not fit into any of the formats listed in the DB...

Regular readers of my blog know that from time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a p...