Articles & Content


How Many 's' are There in Mississippi? (G01)

Topic: DB2 for z/OS

Subtopic: 2007

DATE: 2007-5-7 (09:50 AM - 10:50 AM)
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.