Blog : What’s On Our Mind?

Sharing Our Point of View
By Craig Mullins | On May 26th 2015
Returning Only Numeric Data
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. 123aa 2234a 34256 32102 add91 Out of the above 5…
By Bill Mitalski | On May 21st 2015
DBA 101: What’s the Difference Between a Table and a Heap?
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…
By John Kaufling | On May 20th 2015
Tuning ETLs
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? Extract data Transform data Load transformed data An ETL extracts data from a variety of sources, often performing…
By Craig Mullins | On May 19th 2015
db2_cursors
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…