Showing posts with label functions. Show all posts
Showing posts with label functions. Show all posts
Thursday, June 02, 2022

Db2 13 for z/OS is Here!

›
Here we are, in June 2022, about 5 years or so since Db2 12 for z/OS was released. And lo' and behold, IBM has given us a new version of...
1 comment:
Monday, January 24, 2022

Db2 DATE and TIME Arithmetic

›
After turning the last page on the 2021 calendar to embark on another year, I thought it might be a good time to reflect on date and time da...
Thursday, June 29, 2017

The DB2 12 for z/OS Blog Series - Part 12: New Built-in Functions

›
As with most new releases of DB2 for z/OS, at least lately, there are several new built-in functions (or BIFs) that have been added. DB2'...
Tuesday, October 06, 2015

Sorting by Day of the Week in DB2

›
Today's blog will walk you through a sorting "trick" that you can use when you are dealing with days of the week. A relativel...
2 comments:
Monday, June 01, 2015

DB2 User-Defined Functions

›
In my last post here, I talked about the importance of built-in DB2 functions and how they can be used to simplify development. But DB2 als...
1 comment:
Tuesday, May 19, 2015

The Importance of Using DB2 Functions

›
There are three basic types of built-in functions available to DB2 users:  aggregate functions,  scalar functions, and  table functio...
Monday, April 14, 2014

Aggregating Aggregates Using Nested Table Expressions

›
Sometimes when you are writing your SQL to access data you come across the need to work with aggregates. Fortunately, SQL offers many sim...
Wednesday, October 09, 2013

Using the DISPLAY Command, Part 4

›
In this fourth entry of our series on the DISPLAY command, we take a look at using the DISPLAY command to monitor DB2 stored procedures and ...