Articles & Content


How many 's' are there in Mississippi? (E03)

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2006

DATE: 2006-10-2 (16:15 - 17:15)
SPEAKERS: Peter Backlund (Peter Backlund DB2-Konsult AB)

A classical problem in computing is finding the needle in a haystack. This presentation will first discuss various ways of solving this problem.A more intersting problem is to find the number of needles and also their positions in the haystack.Various ways of solving this problem is discussed, using UDFs, recursive UDFs, Stored Procedures, recursive Stored Procedures, and recursive SQL

EXP. LEVEL: Intermediate,Advanced


Understanding the various ways of finding a needle in a haystack

Understanding the use of recursive SQL

Understanding the use of UDFs

Understanding the use of recursive UDFs

Understanding the use of recursive Stored Procedures

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.