The last post I made to this blog used functions to translate data from one form to another. Functions frequently can be used to overcome issues when you are reading data from your DB2 tables. With that in mind, I thought it might make sense to go over DB2 SQL functions at a basic level - as a review for those who might not have used them before and to refresh the memory of those who have.Functions can be specified in SQL statements to transform data from one state to another. Two types of functions can be applied to data in a DB2 table using SQL:...
Wednesday, 31 January 2007
Saturday, 27 January 2007
Sorting Out a Solution in DB2
Posted on 22:54 by Unknown
Sometimes an application can require different, perhaps even somewhat "odd" data sorting. These needs may cause developers to sit and scratch their head for hours trying to make DB2 do something that seems "unnatural." But often you can conjure up an answer by properly understanding the problem and applying some creative SQL.Some of you might be asking "What the heck is he talking about?" That's a fair question, so let’s look at an example to clarify.Assume that you have a table containing transactions, or some other type of interesting facts....
Subscribe to:
Posts (Atom)
