DB2 for z/OS UDF to convert HEX into a bit string
HEX2BIT.txt
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 ...
DT2B2DT.txt
DB2 for z/OS UDF that converts a bit string into a number
BIT2NUM.txt
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,...
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...
DATE: 2011-5-6 (09:15 AM - 10:15 AM) SPEAKERS: Matthias Nicola (IBM Silicon Valley Lab) What!? An entire presentation on just one SQL function? Yes! DB2 supports well over 200 functions that can be used in SQL statements, and one of them is XMLTABLE. What makes XMLTABLE different from most...
NA11E14.pdf
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...
NA11B09.pdf
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...
EU10F17.pdf
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...
EU10C15.pdf
DATE: 2010-11-10 (17:00 - 18:00) SPEAKERS: Robert Catterall (Catterall Consulting) Stored procedures have been widely used for years in DB2 for Linux, UNIX, and Windows application environments. On the mainframe side, adoption of the technology has been somewhat more limited. That situation is...
EU10E14.pdf