1 to 10 of 121
Sort by

Library Entry

DB2 for z/OS UDF that converts a date that resides in 2 bytes into a YYYY-MM-DD date. The origin of date in 2 bytes is from computing pre-history were every bit was precious. It goes like that: year in 7 bits month in 4 bits day in 5 bits if year is < 50 add '20' in front of it ...


Library Entry

DB2 for z/OS UDF to convert HEX into a bit string


Library Entry

DB2 for z/OS UDF that converts a bit string into a number


Blog Entry
DB2 SQL Enhancements You May Have Missed

Chances are that your business applications and the DB2 LUW databases that power them were built before IBM released DB2 10.1 in April 2012. While it’s no secret that the last two DB2 LUW releases delivered substantial performance gains that make upgrading to DB2 10.1 or even 10.5 a no-brainer,...

Fred Sobotka's profile image

Blog Entry
DB2 User-Defined Functions – Extending Database Capabilities

DB2 comes with a wide variety of built-in functions that enable some incredible functionality within the context of SQL statements. These functions allow for developers to very quickly incorporate application functionality inside SQL statements for fast deployment of features and reports. This...

Library Entry
DB2 Statistics and Data Studio (B09)

DATE: 2011-5-5 (08:30 AM - 09:30 AM) SPEAKERS: Bryan Smith (IBM Corportation) This presentation reviews DB2 access path and space statistics; why you need to collect them; and how DB2 uses the information. The real-time statistics are also reviewed and examples are given how you can use them to...


Bryan Smith's profile image

Library Entry
Get a free lunch with IBM Data Studio (F17)

DATE: 2010-11-11 (11:15 - 12:15) SPEAKERS: Stewart Smith (Standard Life) I don't have a presentation ready on this topic but I have just completed an evaluation of the tool and I am now in the middle of having it packaged and distributed to our development teams where it will be used mainly on...


Library Entry
versus - Using the right tool for job (C15)

DATE: 2010-11-11 (08:30 - 09:30) SPEAKERS: Serge Rielau (IBM) DB2 9.7 has greatly improved the powers of SQL PL and SQL has been quite advanced for a long time.So, with so many ways to do a job. Which way is best? It depends.In this presentation we'll tell you what it depends on.We will look at...


Library Entry
Varsity SQL for the Busy DBA (E13)

DATE: 2010-11-10 (15:45 - 16:45) SPEAKERS: Fred Sobotka (FRS Consulting, Inc.) Adding just a few tricks to your SQL repertoire can save a tremendous amount of time in administering and maintaining your DB2 databases. Advanced SQL techniques aren't just for developers; by combining these...