Absolute SUDOKU Solver - Page 4

Lenny77 · #46 (**permalink**) 11-03-09, 12:22

10/03/09 "AM" page 28 --> 5 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '100009000'
  from sysibm.sysdummy1
union all
select 2, '508000903'
  from sysibm.sysdummy1
union all
select 3, '200830000'
  from sysibm.sysdummy1
union all 
select 4, '001070500'
  from sysibm.sysdummy1
union all
select 5, '007204600'
  from sysibm.sysdummy1
union all
select 6, '009080100'
  from sysibm.sysdummy1
union all
select 7, '000093006'
  from sysibm.sysdummy1
union all
select 8, '904000805'
  from sysibm.sysdummy1
union all
select 9, '000700004'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

1XXXX9XXX
5X8XXX9X3
2XX83XXXX
XX1X7X5XX
XX72X46XX
XX9X8X1XX
XXXX93XX6
9X4XXX8X5
XXX7XXXX4

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

Lenny

Lenny77 · #47 (**permalink**) 11-04-09, 13:14

10/04/09 "Metro" NY page 19, HARD --> 3 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '080000000'
  from sysibm.sysdummy1
union all
select 2, '213005000'
  from sysibm.sysdummy1
union all
select 3, '006009102'
  from sysibm.sysdummy1
union all 
select 4, '042090701'
  from sysibm.sysdummy1
union all
select 5, '000812000'
  from sysibm.sysdummy1
union all
select 6, '501040820'
  from sysibm.sysdummy1
union all
select 7, '604700200'
  from sysibm.sysdummy1
union all
select 8, '000900674'
  from sysibm.sysdummy1
union all
select 9, '000000010'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

X8XXXXXXX
213XX5XXX
XX6XX91X2
X42X9X7X1
XXX812XXX
5X1X4X82X
6X47XX2XX
XXX9XX674
XXXXXXX1X

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

Lenny

Lenny77 · #48 (**permalink**) 11-05-09, 13:05

11/05/09 New York Post, page 64 Very Difficult --> 7 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '007052609'
  from sysibm.sysdummy1
union all
select 2, '006000300'
  from sysibm.sysdummy1
union all
select 3, '000800001'
  from sysibm.sysdummy1
union all 
select 4, '400180003'
  from sysibm.sysdummy1
union all
select 5, '000000000'
  from sysibm.sysdummy1
union all
select 6, '700039005'
  from sysibm.sysdummy1
union all
select 7, '800005000'
  from sysibm.sysdummy1
union all
select 8, '004000800'
  from sysibm.sysdummy1
union all
select 9, '503690100'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XX7X526X9
XX6XXX3XX
XXX8XXXX1
4XX18XXX3
XXXXXXXXX
7XXX39XX5
8XXXX5XXX
XX4XXX8XX
5X369X1XX

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

Lenny

Lenny77 · #49 (**permalink**) 11-06-09, 17:07

11/06/09 "Metro" NY, page 29 HARD --> 1 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '020090800'
  from sysibm.sysdummy1
union all
select 2, '600270003'
  from sysibm.sysdummy1
union all
select 3, '000006210'
  from sysibm.sysdummy1
union all 
select 4, '000700008'
  from sysibm.sysdummy1
union all
select 5, '702804109'
  from sysibm.sysdummy1
union all
select 6, '100009000'
  from sysibm.sysdummy1
union all
select 7, '067100000'
  from sysibm.sysdummy1
union all
select 8, '800042005'
  from sysibm.sysdummy1
union all
select 9, '003050080'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

X2XX9X8XX
6XX27XXX3
XXXXX621X
XXX7XXXX8
7X28X41X9
1XXXX9XXX
X671XXXXX
8XXX42XX5
XX3X5XX8X

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

Lenny

Lenny77 · #50 (**permalink**) 11-09-09, 13:48

11/09/09 "Metro" NY page 28 HARD --> 0 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '000070000'
  from sysibm.sysdummy1
union all
select 2, '401008070'
  from sysibm.sysdummy1
union all
select 3, '500403290'
  from sysibm.sysdummy1
union all 
select 4, '009007120'
  from sysibm.sysdummy1
union all
select 5, '200000009'
  from sysibm.sysdummy1
union all
select 6, '063200500'
  from sysibm.sysdummy1
union all
select 7, '084706002'
  from sysibm.sysdummy1
union all
select 8, '090300608'
  from sysibm.sysdummy1
union all
select 9, '000080000'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XXXX7XXXX
4X1XX8X7X
5XX4X329X
XX9XX712X
2XXXXXXX9
X632XX5XX
X847X6XX2
X9X3XX6X8
XXXX8XXXX

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

================================

11/09/09 "AM" NY page 20 --> 0 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '907000204'
  from sysibm.sysdummy1
union all
select 2, '000093000'
  from sysibm.sysdummy1
union all
select 3, '046100000'
  from sysibm.sysdummy1
union all 
select 4, '000902007'
  from sysibm.sysdummy1
union all
select 5, '503000102'
  from sysibm.sysdummy1
union all
select 6, '200701000'
  from sysibm.sysdummy1
union all
select 7, '000000620'
  from sysibm.sysdummy1
union all
select 8, '000280000'
  from sysibm.sysdummy1
union all
select 9, '601000309'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

9X7XXX2X4
XXXX93XXX
X461XXXXX
XXX9X2XX7
5X3XXX1X2
2XX7X1XXX
XXXXXX62X
XXX28XXXX
6X1XXX3X9

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

P.S. Because of many people ask me to make ASS statement shorter I did it
and you can find it in an attachment

Lenny

Lenny77 · #51 (**permalink**) 11-11-09, 12:05

Veteran's Day Sudoku, "AM" page 14 Level-3 --> 7 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '506198000'
  from sysibm.sysdummy1
union all
select 2, '408000300'
  from sysibm.sysdummy1
union all
select 3, '000500600'
  from sysibm.sysdummy1
union all 
select 4, '060040000'
  from sysibm.sysdummy1
union all
select 5, '900000002'
  from sysibm.sysdummy1
union all
select 6, '000020070'
  from sysibm.sysdummy1
union all
select 7, '001002000'
  from sysibm.sysdummy1
union all
select 8, '004000706'
  from sysibm.sysdummy1
union all
select 9, '000780209'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

5X6198XXX
4X8XXX3XX
XXX5XX6XX
X6XX4XXXX
9XXXXXXX2
XXXX2XX7X
XX1XX2XXX
XX4XXX7X6
XXX78X2X9

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

Lenny

Lenny77 · #52 (**permalink**) 11-13-09, 11:36

11/13/09 "Metro" NY page 25 HARD --> 1 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '031004000'
  from sysibm.sysdummy1
union all
select 2, '900016000'
  from sysibm.sysdummy1
union all
select 3, '006730000'
  from sysibm.sysdummy1
union all 
select 4, '300090205'
  from sysibm.sysdummy1
union all
select 5, '084000730'
  from sysibm.sysdummy1
union all
select 6, '209070001'
  from sysibm.sysdummy1
union all
select 7, '000057900'
  from sysibm.sysdummy1
union all
select 8, '000360004'
  from sysibm.sysdummy1
union all
select 9, '000800310'
  from sysibm.sysdummy1
)

Result:

Quote:

Sudoku Line

X31XX4XXX
9XXX16XXX
XX673XXXX
3XXX9X2X5
X84XXX73X
2X9X7XXX1
XXXX579XX
XXX36XXX4
XXX8XX31X

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

Lenny

Lenny77 · #53 (**permalink**) 11-16-09, 11:54

11/16/09 "AM" NY Hard page 24 --> 2 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '000309070'
  from sysibm.sysdummy1
union all
select 2, '810600900'
  from sysibm.sysdummy1
union all
select 3, '000000080'
  from sysibm.sysdummy1
union all 
select 4, '092000600'
  from sysibm.sysdummy1
union all
select 5, '060050090'
  from sysibm.sysdummy1
union all
select 6, '007000450'
  from sysibm.sysdummy1
union all
select 7, '020000000'
  from sysibm.sysdummy1
union all
select 8, '005804062'
  from sysibm.sysdummy1
union all
select 9, '080501000'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

XXX3X9X7X
81X6XX9XX
XXXXXXX8X
X92XXX6XX
X6XX5XX9X
XX7XXX45X
X2XXXXXXX
XX58X4X62
X8X5X1XXX

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

11/16/09 "Metro" NY page 23 "Very Hard" --> 9 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '100058000'
  from sysibm.sysdummy1
union all
select 2, '006700003'
  from sysibm.sysdummy1
union all
select 3, '709020140'
  from sysibm.sysdummy1
union all 
select 4, '014003070'
  from sysibm.sysdummy1
union all
select 5, '000000000'
  from sysibm.sysdummy1
union all
select 6, '090100460'
  from sysibm.sysdummy1
union all
select 7, '075010302'
  from sysibm.sysdummy1
union all
select 8, '200005600'
  from sysibm.sysdummy1
union all
select 9, '000230004'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

1XXX58XXX
XX67XXXX3
7X9X2X14X
X14XX3X7X
XXXXXXXXX
X9X1XX46X
X75X1X3X2
2XXXX56XX
XXX23XXX4

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

Lenny

Lenny77 · #54 (**permalink**) 11-17-09, 12:31

11/17/09 "Metro" page 24 HARD --> 1 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '041705098'
  from sysibm.sysdummy1
union all
select 2, '050308000'
  from sysibm.sysdummy1
union all
select 3, '000040000'
  from sysibm.sysdummy1
union all 
select 4, '205000031'
  from sysibm.sysdummy1
union all
select 5, '900000005'
  from sysibm.sysdummy1
union all
select 6, '170000802'
  from sysibm.sysdummy1
union all
select 7, '000030000'
  from sysibm.sysdummy1
union all
select 8, '000107020'
  from sysibm.sysdummy1
union all
select 9, '410602750'
  from sysibm.sysdummy1
)

Code:

Sudoku Line

X417X5X98
X5X3X8XXX
XXXX4XXXX
2X5XXXX31
9XXXXXXX5
17XXXX8X2
XXXX3XXXX
XXX1X7X2X
41X6X275X

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

Lenny

Lenny77 · #55 (**permalink**) 11-18-09, 13:36

11/18/09 "Metro" NY page 16 HARD --> 1 sec <--

Code:

Source (line, sudoku_str) as 
(
select 1, '017360009'
  from sysibm.sysdummy1
union all
select 2, '500027801'
  from sysibm.sysdummy1
union all
select 3, '009000000'
  from sysibm.sysdummy1
union all 
select 4, '058200000'
  from sysibm.sysdummy1
union all
select 5, '060000020'
  from sysibm.sysdummy1
union all
select 6, '000004170'
  from sysibm.sysdummy1
union all
select 7, '000000900'
  from sysibm.sysdummy1
union all
select 8, '105740002'
  from sysibm.sysdummy1
union all
select 9, '900036710'
  from sysibm.sysdummy1
)

Quote:

Sudoku Line

X1736XXX9
5XXX278X1
XX9XXXXXX
X582XXXXX
X6XXXXX2X
XXXXX417X
XXXXXX9XX
1X574XXX2
9XXX3671X

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

Lenny

Lenny77 · #56 (**permalink**) 11-19-09, 14:11

11/18/09: From 3 Newspapers (Very Hard, but very FAST):

Code:

Source (line, sudoku_str) as 
(
select 1, '082050000'
  from sysibm.sysdummy1
union all
select 2, '030047096'
  from sysibm.sysdummy1
union all
select 3, '000100002'
  from sysibm.sysdummy1
union all 
select 4, '090000300'
  from sysibm.sysdummy1
union all
select 5, '520000041'
  from sysibm.sysdummy1
union all
select 6, '003000020'
  from sysibm.sysdummy1
union all
select 7, '300009000'
  from sysibm.sysdummy1
union all
select 8, '450630070'
  from sysibm.sysdummy1
union all
select 9, '000070910'
  from sysibm.sysdummy1
)

Code:

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

Code:

Source (line, sudoku_str) as 
(
select 1, '498000500'
  from sysibm.sysdummy1
union all
select 2, '700086001'
  from sysibm.sysdummy1
union all
select 3, '000000000'
  from sysibm.sysdummy1
union all 
select 4, '009021800'
  from sysibm.sysdummy1
union all
select 5, '000000000'
  from sysibm.sysdummy1
union all
select 6, '005460700'
  from sysibm.sysdummy1
union all
select 7, '000000000'
  from sysibm.sysdummy1
union all
select 8, '600970304'
  from sysibm.sysdummy1
union all
select 9, '500000027'
  from sysibm.sysdummy1
)

Quote:

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

Code:

Source (line, sudoku_str) as 
(
select 1, '200090000'
  from sysibm.sysdummy1
union all
select 2, '080203100'
  from sysibm.sysdummy1
union all
select 3, '301400205'
  from sysibm.sysdummy1
union all 
select 4, '450000800'
  from sysibm.sysdummy1
union all
select 5, '900000004'
  from sysibm.sysdummy1
union all
select 6, '002000053'
  from sysibm.sysdummy1
union all
select 7, '108007602'
  from sysibm.sysdummy1
union all
select 8, '009802070'
  from sysibm.sysdummy1
union all
select 9, '000040008'
  from sysibm.sysdummy1
)

Quote:

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

Lenny

Gnugamel · #57 (**permalink**) 11-19-09, 16:23

Hi
Well i was just here to ask a question, but before posting i stumpled across this thread. This semester i attended to an DB2 course at University, so i am really not very experienced in using the database, but since your idea sounds funny to me i thought:
"well lets try to run and understand the code"
The bad thing is, it seems i am even to stupid to run this query, sobering.

what are the right command line parameters to run this query (why is an normal -tf not enough)
Would be happy for help

Lenny77 · #58 (**permalink**) 11-19-09, 16:46

Quote:

Originally Posted by Gnugamel

Hi
Well i was just here to ask a question, but before posting i stumpled across this thread. This semester i attended to an DB2 course at University, so i am really not very experienced in using the database, but since your idea sounds funny to me i thought:
"well lets try to run and understand the code"
The bad thing is, it seems i am even to stupid to run this query, sobering.

what are the right command line parameters to run this query (why is an normal -tf not enough)
Would be happy for help

OK, I believe, you did not finish your DB2 education, yet !

Thus, you will not pass five years, even, as you will understand everything!

I envy you - at you all ahead !

Lenny

Gnugamel · #59 (**permalink**) 11-19-09, 17:15

Well thats true, but this is just an optional DB2 731 Certifikation course 90mins a week/13weeks which mainly consists of copy paste from lecture notes (really really not very motivating at all, you do not even learn anything besides how to pass a certification). So i wont get a real education in db2 systems at all.
Thats why i asked an why i am here, just trying to motivate myself to really learn (at least) a little bit. But thanks for envying me ;-)
Greetings

Lenny77 · #60 (**permalink**) 11-19-09, 17:40

How to run ASS query:

1. Hilite all query: From start to end (use SELECT ALL)
2. Copy/Paste this query to your DB2 processor
3. Execute this query as any other query you do
4. Get result

Lenny

P.S. You have to update Source part by your values. Where "0"s - unknown (empty) cages in Sudoku puzzle.

Internet Services

Web Development

Digital Marketing

Consumer Tech