Wie wär's damit?

select week(substr(25102006, 1, 2)||'.'||
substr(25102006, 3, 2)||'.'||
substr(25102006, 5, 4))
from sysibm/sysdummy1