I frequently get e-mail from folks asking about ways to accomplish things in DB2 and SQL. A recent question I got went something like this:
Is there any option to check whether data “IS NUMERIC” in a DB2 table?
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?
The VAR variable is defined as a CHAR(5) column and it will contain data like below.
Out of the above 5…
If you are a database administrator working in a SQL environment, and are also intent on becoming a proficient or power SQL user, there is one very basic concept you’ll need to understand: what is the difference between a table and a heap?
Knowing the difference between these two objects will help you understand how SQL works. When you understand what tables and heaps are, you will understand the very foundations of how data is stored. This…
Coming up on Thursday, May 28, our senior applications tuner Chuck Ezell will present a webinar on Tuning Your ELTs for Better BI. His presentation offers high level ideas on how to tune ETLs to reach the two main goals for tuning your ETLs for better performance; enhance speed and consistency.
Here is a sneak peek at what some of the presentation will cover.
What is ETL?
Load transformed data
An ETL extracts data from a variety of sources, often performing…
Sometimes I will use this blog to post answers to questions that have been sent to me. The question being answered today, is this: I have a select query that returns 1000 rows and I want to display the rows from 200 to 500. Could you please let me how to code after the where clause? I know how to get the first 100 rows using — FETCH FIRST 100 rows only clause.
If you are using DB2 V7 or…