Today "AM" NY page 33, level-3 5 sec.
I want give to not just solution, as usual, but a Source part.
You can replace your Source part by this
Code:
Source (line, sudoku_str) as
(
select 1, '000010603'
from sysibm.sysdummy1
union all
select 2, '200000010'
from sysibm.sysdummy1
union all
select 3, '067380004'
from sysibm.sysdummy1
union all
select 4, '400900005'
from sysibm.sysdummy1
union all
select 5, '080000060'
from sysibm.sysdummy1
union all
select 6, '000008009'
from sysibm.sysdummy1
union all
select 7, '500093280'
from sysibm.sysdummy1
union all
select 8, '010000006'
from sysibm.sysdummy1
union all
select 9, '803070000'
from sysibm.sysdummy1
)
and get solution on your machine in seconds:
Quote:
Sudoku Line
XXXX1X6X3
2XXXXXX1X
X6738XXX4
4XX9XXXX5
X8XXXXX6X
XXXXX8XX9
5XXX9328X
X1XXXXXX6
8X3X7XXXX
Line 1: | 9 | 5 | 8 | 2 | 1 | 4 | 6 | 7 | 3 |
Line 2: | 2 | 3 | 4 | 5 | 6 | 7 | 9 | 1 | 8 |
Line 3: | 1 | 6 | 7 | 3 | 8 | 9 | 5 | 2 | 4 |
Line 4: | 4 | 7 | 1 | 9 | 2 | 6 | 8 | 3 | 5 |
Line 5: | 3 | 8 | 9 | 4 | 5 | 1 | 7 | 6 | 2 |
Line 6: | 6 | 2 | 5 | 7 | 3 | 8 | 1 | 4 | 9 |
Line 7: | 5 | 4 | 6 | 1 | 9 | 3 | 2 | 8 | 7 |
Line 8: | 7 | 1 | 2 | 8 | 4 | 5 | 3 | 9 | 6 |
Line 9: | 8 | 9 | 3 | 6 | 7 | 2 | 4 | 5 | 1 |
|
Lenny