Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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 DB2 manuals.
From time to time I use the blog as a forum to answer questions I get via e-mail. Today, we address a popular theme – dealing with DB2 date data.
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 from, date and time columns.
Table expressions are frequently overlooked as a potential solution for resolving problems using only SQL. Learn more in this post.
“Does the number of columns or size of the row matter in terms of performance?” Let’s explore this question in further detail.
Let’s say I have a table A which has 500 columns. Out of those 500 columns only 5 columns have been defined as not nullable and the rest have been defined as NULLS allowed.
You should really do the investigative work required to find out the real level of support for DB2 V11 that is in the GA version of the tool. Read more.
Are any of the DB2 unload utilities able to include the column names in the same file as the unload output data? Read on to discover the answer.
We want to examine CHAR data but return only those where the entire data consists only of numbers. For example, can we write a query like this?