[lennykhiger]

I create Sudoku Solver in DB2 and I am looking for some testers of my code.

You have to change

Source (line, sudoku_str) as
(
select 1, '000000000'
from sysibm.sysdummy1
union all
select 2, '070006030'
from sysibm.sysdummy1
union all
select 3, '030720040'
from sysibm.sysdummy1
union all
select 4, '700008001'
from sysibm.sysdummy1
union all
select 5, '600307005'
from sysibm.sysdummy1
union all
select 6, '509100000'
from sysibm.sysdummy1
union all
select 7, '080091020'
from sysibm.sysdummy1
union all
select 8, '091600070'
from sysibm.sysdummy1
union all
select 9, '000000000'
from sysibm.sysdummy1
)

by Sudoku numbers from any source (newspaper, etc), where "0" is unknown cage, run and compare results.

Lenny Khiger, ADSPA&VP

[lennykhiger]

Now attach pt2 to pt1 and execute !

Sorry, code is big, because one statement solved the difficult game.

Lenny

[lennykhiger]

I'd like to explain to you how has to look the complete statement:

with <-- start of pt1 -->
all_nbrs (k, search_no) as
(
select 1, varchar('1', 1)
  from sysibm.sysdummy1
union all
select k + 1, varchar(k + 1)
  from all_nbrs 
 where k + 1 <= 9 )
,
Source (line, sudoku_str) as 
(
select 1, '000000000'
  from sysibm.sysdummy1
union all
select 2, '070006030'
  from sysibm.sysdummy1
union all
select 3, '030720040'
  from sysibm.sysdummy1
union all 
select 4, '700008001'
  from sysibm.sysdummy1
union all
select 5, '600307005'
  from sysibm.sysdummy1
union all
select 6, '509100000'
  from sysibm.sysdummy1
union all
select 7, '080091020'
  from sysibm.sysdummy1
union all
select 8, '091600070'
  from sysibm.sysdummy1
union all
select 9, '000000000'
  from sysibm.sysdummy1
) 
...
...
...
(select cand S from SudokuSt2 where i = 2 and j = 8
and cand not in (s21.s, s22.s, s23.s, s24.s, s25.s, s26.s, s27.s)
and cand not in (s17, s18, s19) 
)  s28, table          
(select cand S from SudokuSt2 where i = 2 and j = 9
and cand not in (s21.s, s22.s, s23.s, s24.s, s25.s, s26.s, s27.s, s28.s)
and cand not in (s17, s18, s19) 
)  s29 
)  SL2  <-- end   of pt1 -->
, Table <-- start of pt2 -->
(
select s31.s S31, s32.s S32, s33.s S33, s34.s S34, s35.s S35, s36.s S36, s37.s S37, s38.s S38, s39.s S39
 From  table
(select cand S from SudokuSt2 where i = 3 and j = 1
 and cand not in (s11, s12, s13, s21, s22, s23)
 and cand not in (s11, s21)  
)  s31, table                                
(select cand S from SudokuSt2 where i = 3 and j = 2
 and cand not in (s31.s)
 and cand not in (s11, s12, s13, s21, s22, s23)
...
...
...
Union All
select Line_8 as "Sudoku Line", Weight from Sudoku_Final 
where  Line_8  > ' '
Union All
select Line_9 as "Sudoku Line", Weight from Sudoku_Final 
where  Line_9  > ' ' ) tt
group by tt."Sudoku Line", Weight 
order by Weight, "Sudoku Line"  <-- end   of pt2  and complete -->

How you understand comments I added just for better understanding and you will not find them in the attachments.

Thanks, Lenny Khiger ADSPA&VP

[lennykhiger]

Remember: You have to change Source in code, only !

All lines shown below produced by Sudoku-Solver.

Today "AM", NY pg.30 Level-4 Sudoku -- 10 seconds:

Sudoku Line

XX5X4X8XX
73XXXXX65
8XXXXX3X2
XXX97XXX6
XXXXXXXXX
1X6X32XXX
3X4XXXXX7
56XXXXX43
XX1X5XXXX

Line 1: | 6 | 1 | 5 | 2 | 4 | 3 | 8 | 7 | 9 |
Line 2: | 7 | 3 | 2 | 8 | 1 | 9 | 4 | 6 | 5 |
Line 3: | 8 | 4 | 9 | 7 | 6 | 5 | 3 | 1 | 2 |
Line 4: | 4 | 5 | 3 | 9 | 7 | 1 | 2 | 8 | 6 |
Line 5: | 2 | 9 | 7 | 4 | 8 | 6 | 5 | 3 | 1 |
Line 6: | 1 | 8 | 6 | 5 | 3 | 2 | 7 | 9 | 4 |
Line 7: | 3 | 2 | 4 | 6 | 9 | 8 | 1 | 5 | 7 |
Line 8: | 5 | 6 | 8 | 1 | 2 | 7 | 9 | 4 | 3 |
Line 9: | 9 | 7 | 1 | 3 | 5 | 4 | 6 | 2 | 8 |

Today "Metro", NY pg.28 (level: hard Sudoku) -- 1 second:

Sudoku Line

6XX3XXXXX
4XX9XXX78
2XXX54XX3
1X6XXX4XX
X34XXX19X
XX9XXX3X6
8XX46XXX5
34XXX2XX1
XXXXX7XX4

Line 1: | 6 | 5 | 7 | 3 | 8 | 1 | 2 | 4 | 9 |
Line 2: | 4 | 1 | 3 | 9 | 2 | 6 | 5 | 7 | 8 |
Line 3: | 2 | 9 | 8 | 7 | 5 | 4 | 6 | 1 | 3 |
Line 4: | 1 | 8 | 6 | 2 | 3 | 9 | 4 | 5 | 7 |
Line 5: | 5 | 3 | 4 | 6 | 7 | 8 | 1 | 9 | 2 |
Line 6: | 7 | 2 | 9 | 1 | 4 | 5 | 3 | 8 | 6 |
Line 7: | 8 | 7 | 1 | 4 | 6 | 3 | 9 | 2 | 5 |
Line 8: | 3 | 4 | 5 | 8 | 9 | 2 | 7 | 6 | 1 |
Line 9: | 9 | 6 | 2 | 5 | 1 | 7 | 8 | 3 | 4 |

Lenny

[lennykhiger]

Originally Posted by advisortrevor

You can try to check the Online Sudoku Checker for the source file tool ....

Legit Work From Home Jobs

I know that.
I don't need to do that kind of checking, because I know: My solver never make mistakes.

I want to involve people to testing my solver to understand what problem they will have and how long it run on different computers and systems.

Lenny