Have y’all used  Graeme’s DB2 Cook book.   It has a wealth of SQL examples .  I always find the sql tips and tricks in that book very handy.  Give it a shot . According to the website, the 472 pages of his new edition contains over 1000 sample sql statements as example.