/ Liren Large Software Subsidy 5 / 05.iso / a / a061 / 1.img

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 4f 0f 01 01 01 01 01 01 | 00 00 00 00 00 00 00 00 |O.......|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 8e 02 | fd eb 3c 90 4d 53 44 4f |........|..<.MSDO|
|000000b0| 53 35 2e 30 00 02 01 01 | 00 02 e0 00 60 09 f9 07 |S5.0....|....`...|
|000000c0| 00 0f 00 02 fd 00 0b 29 | 01 16 1d 3b 53 51 4c 45 |.......)|...;SQLE|
|000000d0| 56 41 4c 34 32 20 20 46 | 41 54 31 32 fd 20 03 fa |VAL42  F|AT12. ..|
|000000e0| 33 c0 8e d0 bc 00 7c 16 | 07 bb 78 00 36 c5 37 1e |3.....|.|..x.6.7.|
|000000f0| 56 16 53 bf 3e 7c b9 0b | 00 fc f3 a4 06 1f c6 45 |V.S.>|..|.......E|
|00000100| fe 0f 8b 0e 18 7c 88 4d | f9 89 47 02 c7 07 3e 7c |.....|.M|..G...>||
|00000110| fb cd 13 72 79 33 c0 39 | 06 13 7c 74 08 8b 0e 13 |...ry3.9|..|t....|
|00000120| 7c 89 0e 20 7c a0 10 7c | f7 26 16 7c 03 06 1c 7c ||.. |..||.&.|...||
|00000130| 13 16 1e 7c 03 06 0e 7c | 83 d2 00 a3 50 7c 89 16 |...|...||....P|..|
|00000140| 52 7c a3 49 7c 89 16 4b | 7c b8 20 00 f7 26 11 7c |R|.I|..K||. ..&.||
|00000150| 8b 1e 0b 7c 03 c3 48 f7 | f3 01 06 49 7c 83 16 4b |...|..H.|...I|..K|
|00000160| 7c 00 bb 00 05 8b 16 52 | 7c a1 50 7c e8 92 00 72 ||......R||.P|...r|
|00000170| 1d b0 01 e8 ac 00 72 16 | 8b fb b9 0b 00 be e6 7d |......r.|.......}|
|00000180| f3 a6 75 0a 8d 7f 20 b9 | 0b 00 f3 a6 74 18 be 9e |..u... .|....t...|
|00000190| 7d e8 5f 00 33 c0 cd 16 | 5e 1f 8f 04 8f 44 02 cd |}._.3...|^....D..|
|000001a0| 19 fd 58 03 eb e8 8b 47 | 1a 48 48 8a 1e 0d 7c 32 |..X....G|.HH...|2|
|000001b0| ff f7 e3 03 06 49 7c 13 | 16 4b 7c bb 00 07 b9 03 |.....I|.|.K|.....|
|000001c0| 00 50 52 51 e8 3a 00 72 | d8 b0 01 e8 54 00 59 5a |.PRQ.:.r|....T.YZ|
|000001d0| 58 72 bb 05 01 00 83 d2 | 00 03 1e 0b 7c e2 e2 8a |Xr......|....|...|
|000001e0| 2e 15 7c 8a 16 24 7c 8b | 1e 49 7c a1 4b 7c ea 00 |..|..$|.|.I|.K|..|
|000001f0| 00 70 00 ac 0a c0 74 29 | b4 0e bb 07 00 cd 10 eb |.p....t)|........|
|00000200| f2 3b 16 18 7c 73 19 f7 | 36 18 7c fe c2 88 16 4f |.;..|s..|6.|....O|
|00000210| 7c 33 d2 f7 36 1a 7c 88 | 16 25 7c a3 4d 7c f8 c3 ||3..6.|.|.%|.M|..|
|00000220| f9 c3 b4 02 8b 16 4d 7c | b1 06 d2 e6 0a 36 4f 7c |......M||.....6O||
|00000230| 8b ca 86 e9 8a 16 24 7c | 8a 36 25 7c cd 13 c3 0d |......$||.6%|....|
|00000240| 0a 4e 6f 6e 2d 53 79 73 | 74 65 6d 20 64 69 73 6b |.Non-Sys|tem disk|
|00000250| 20 6f 72 20 64 69 73 6b | 20 65 72 72 6f 72 0d 0a | or disk| error..|
|00000260| 52 65 70 6c 61 63 65 20 | 61 6e 64 20 70 72 65 73 |Replace |and pres|
|00000270| 73 20 61 6e 79 20 6b 65 | 79 20 77 68 65 6e 20 72 |s any ke|y when r|
|00000280| 65 61 64 79 0d 0a 00 49 | 4f fd 20 06 53 59 53 4d |eady...I|O. .SYSM|
|00000290| 53 44 4f 53 fd 20 03 53 | 59 53 00 00 55 aa f9 ff |SDOS. .S|YS..U...|
|000002a0| ff 12 f0 fd ff 08 af 00 | fd ff 0c 2a 40 01 ff 6f |........|...*@..o|
|000002b0| 01 17 80 01 19 a0 01 1b | f0 fd ff 26 6f 03 ff 0f |........|...&o...|
|000002c0| fd 00 ff fd 00 ff fd 00 | ff fd 00 ff fd 00 ff fd |........|........|
|000002d0| 00 ff fd 00 ff fd 00 ff | fd 00 ff fd 00 ff fd 00 |........|........|
|000002e0| ff fd 00 ff fd 00 ff fd | 00 ba f9 ff ff 12 f0 fd |........|........|
|000002f0| ff 08 af 00 fd ff 0c 2a | 40 01 ff 6f 01 17 80 01 |.......*|@..o....|
|00000300| 19 a0 01 1b f0 fd ff 26 | 6f 03 ff 0f fd 00 ff fd |.......&|o.......|
|00000310| 00 ff fd 00 ff fd 00 ff | fd 00 ff fd 00 ff fd 00 |........|........|
|00000320| ff fd 00 ff fd 00 ff fd | 00 ff fd 00 ff fd 00 ff |........|........|
|00000330| fd 00 ff fd 00 ba 29 02 | ff 53 51 4c 45 56 41 4c |......).|.SQLEVAL|
|00000340| 34 32 20 20 28 ff 00 0a | 27 77 4c 1c ff 00 06 43 |42  (...|'wL....C|
|00000350| 4c 49 45 4e 54 31 ff 20 | 04 10 ff 00 0a 5d 77 4c |LIENT1. |.....]wL|
|00000360| 1c 02 ff 00 05 43 4c 49 | 45 4e 54 32 ff 20 04 10 |.....CLI|ENT2. ..|
|00000370| ff 00 0a 6e 77 4c 1c 30 | ff 00 05 52 45 41 44 4d |...nwL.0|...READM|
|00000380| 45 ff 20 06 ff 00 0a 01 | 00 55 18 35 00 04 03 ff |E. .....|.U.5....|
|00000390| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|000003a0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000003b0| ff 00 ff ff 00 ff ff 00 | ff ff 00 ff ff 00 ff ff |........|........|
|000003c0| 00 ff ff 00 ff ff 00 ff | ff 00 ff ff 00 ff ff 00 |........|........|
|000003d0| ff ff 00 ff ff 00 ff ff | 00 ff ff 00 ff ff 00 ff |........|........|
|000003e0| ff 00 9d 2e ff 20 0a 10 | ff 00 0a 5d 77 4c 1c 02 |..... ..|...]wL..|
|000003f0| ff 00 05 2e 2e ff 20 09 | 10 ff 00 0a 5d 77 4c 1c |...... .|....]wL.|
|00000400| ff 00 06 41 43 54 30 31 | 41 20 20 51 52 59 20 ff |...ACT01|A  QRY .|
|00000410| 00 0a 01 00 55 18 03 00 | 3d ff 00 03 41 43 54 30 |....U...|=...ACT0|
|00000420| 31 42 20 20 51 52 59 20 | ff 00 0a 01 00 55 18 04 |1B  QRY |.....U..|
|00000430| 00 5a ff 00 03 41 43 54 | 30 32 ff 20 03 51 52 59 |.Z...ACT|02. .QRY|
|00000440| 20 ff 00 0a 01 00 55 18 | 05 00 2a ff 00 03 41 43 | .....U.|..*...AC|
|00000450| 54 30 33 ff 20 03 51 52 | 59 20 ff 00 0a 01 00 55 |T03. .QR|Y .....U|
|00000460| 18 06 00 7b ff 00 03 41 | 43 54 30 34 41 20 20 51 |...{...A|CT04A  Q|
|00000470| 52 59 20 ff 00 0a 01 00 | 55 18 07 00 5e ff 00 03 |RY .....|U...^...|
|00000480| 41 43 54 30 34 42 20 20 | 51 52 59 20 ff 00 0a 01 |ACT04B  |QRY ....|
|00000490| 00 55 18 08 00 22 ff 00 | 03 41 43 54 30 35 41 20 |.U..."..|.ACT05A |
|000004a0| 20 51 52 59 20 ff 00 0a | 01 00 55 18 09 00 64 02 | QRY ...|..U...d.|
|000004b0| 00 00 41 43 54 30 35 42 | 20 20 51 52 59 20 ff 00 |..ACT05B|  QRY ..|
|000004c0| 0a 01 00 55 18 0b 00 35 | ff 00 03 41 43 54 30 35 |...U...5|...ACT05|
|000004d0| 43 20 20 51 52 59 20 ff | 00 0a 01 00 55 18 0c 00 |C  QRY .|....U...|
|000004e0| 74 ff 00 03 41 43 54 30 | 36 41 20 20 51 52 59 20 |t...ACT0|6A  QRY |
|000004f0| ff 00 0a 01 00 55 18 0d | 00 b7 ff 00 03 41 43 54 |.....U..|.....ACT|
|00000500| 30 37 41 20 20 51 52 59 | 20 ff 00 0a 01 00 55 18 |07A  QRY| .....U.|
|00000510| 0e 00 77 ff 00 03 41 43 | 54 30 38 41 20 20 51 52 |..w...AC|T08A  QR|
|00000520| 59 20 ff 00 0a 01 00 55 | 18 0f 00 14 01 00 00 41 |Y .....U|.......A|
|00000530| 43 54 30 39 41 20 20 51 | 52 59 20 ff 00 0a 01 00 |CT09A  Q|RY .....|
|00000540| 55 18 10 00 4c 01 00 00 | 41 43 54 30 39 42 20 20 |U...L...|ACT09B  |
|00000550| 51 52 59 20 ff 00 0a 01 | 00 55 18 11 00 24 ff 00 |QRY ....|.U...$..|
|00000560| 03 e2 0d db 73 65 6c 65 | 63 74 20 70 75 62 5f 69 |....sele|ct pub_i|
|00000570| 64 2c 20 74 79 70 65 2c | 20 74 69 74 6c 65 5f 69 |d, type,| title_i|
|00000580| 64 0d 0a 66 72 6f 6d 20 | 74 69 74 6c 65 73 0d 0a |d..from |titles..|
|00000590| 6f 72 64 65 72 20 62 79 | 20 70 75 62 5f 69 64 0d |order by| pub_id.|
|000005a0| 0a 27 32 32 31 20 43 68 | 61 70 6d 61 6e 20 42 6c |.'221 Ch|apman Bl|
|000005b0| 76 64 2c 20 53 75 69 74 | 65 20 41 27 0d 0a db 20 |vd, Suit|e A'... |
|000005c0| 04 77 68 65 72 65 20 73 | 74 6f 72 5f 61 64 64 72 |.where s|tor_addr|
|000005d0| 65 73 73 20 3d 20 27 32 | 32 31 20 43 68 61 70 6d |ess = '2|21 Chapm|
|000005e0| 61 6e 20 42 6c 76 64 27 | 0d 0a db 20 04 77 61 69 |an Blvd'|... .wai|
|000005f0| 74 66 6f 72 20 64 65 6c | 61 79 20 27 30 30 3a 30 |tfor del|ay '00:0|
|00000600| 30 3a 30 35 27 0d 0a db | 20 04 75 70 64 61 74 65 |0:05'...| .update|
|00000610| 20 74 69 74 6c 65 73 0d | 0a db 20 04 73 65 74 20 | titles.|.. .set |
|00000620| 61 64 76 61 6e 63 65 20 | 3d 20 24 35 db 30 03 0d |advance |= $5.0..|
|00000630| 0a db 20 04 77 68 65 72 | 65 20 74 69 74 6c 65 20 |.. .wher|e title |
|00000640| 3d 20 27 53 65 63 72 65 | 74 73 20 6f 66 20 53 69 |= 'Secre|ts of Si|
|00000650| 6c 69 63 6f 6e 20 56 61 | 6c 6c 65 79 27 0d 0a 63 |licon Va|lley'..c|
|00000660| 6f 6d 6d 69 74 20 74 72 | 61 6e 73 61 63 74 69 6f |ommit tr|ansactio|
|00000670| 6e 0d 0a db 00 ec 73 65 | 6c 65 63 74 20 70 75 62 |n.....se|lect pub|
|00000680| 5f 6e 61 6d 65 2c 20 74 | 69 74 6c 65 0d 0a 66 72 |_name, t|itle..fr|
|00000690| 6f 6d 20 70 75 62 6c 69 | 73 68 65 72 73 2c 20 74 |om publi|shers, t|
|000006a0| 69 74 6c 65 73 0d 0a 77 | 68 65 72 65 20 70 75 62 |itles..w|here pub|
|000006b0| 6c 69 73 68 65 72 73 2e | 70 75 62 5f 69 64 20 3d |lishers.|pub_id =|
|000006c0| 20 74 69 74 6c 65 73 2e | 70 75 62 5f 69 64 0d 0a | titles.|pub_id..|
|000006d0| db 00 ff db 00 a7 63 72 | 65 61 74 65 20 69 6e 64 |......cr|eate ind|
|000006e0| 65 78 20 61 75 5f 69 64 | 5f 69 6e 64 0d 0a 6f 6e |ex au_id|_ind..on|
|000006f0| 20 61 75 74 68 6f 72 73 | 20 28 61 75 5f 69 64 29 | authors| (au_id)|
|00000700| 64 72 75 6c 65 2e 22 20 | 20 54 68 65 20 63 6f 72 |drule." | The cor|
|00000710| 72 65 63 74 20 6e 61 6d | 65 0d 0a 69 73 20 22 70 |rect nam|e..is "p|
|00000720| 75 62 5f 69 64 72 75 6c | 65 2e 22 0d 0a 0d 0a 70 |ub_idrul|e."....p|
|00000730| 2e 20 38 32 2c 20 41 63 | 74 69 76 69 74 79 20 32 |. 82, Ac|tivity 2|
|00000740| 30 2c 20 53 74 65 70 20 | 31 3a 20 20 54 68 65 20 |0, Step |1:  The |
|00000750| 63 3a 5c 73 71 6c 5c 69 | 6e 73 74 61 6c 6c 20 64 |c:\sql\i|nstall d|
|00000760| 69 72 65 63 74 6f 72 79 | 20 0d 0a 63 6f 6e 74 61 |irectory| ..conta|
|00000770| 69 6e 73 20 74 68 65 20 | 69 6e 73 74 61 6c 6c 61 |ins the |installa|
|00000780| 74 69 6f 6e 20 73 63 72 | 69 70 74 20 74 6f 20 72 |tion scr|ipt to r|
|00000790| 65 63 72 65 61 74 65 20 | 74 68 65 20 50 55 42 53 |ecreate |the PUBS|
|000007a0| 0d 0a 64 61 74 61 62 61 | 73 65 2e 20 20 49 74 20 |..databa|se.  It |
|000007b0| 64 6f 65 73 20 6e 6f 74 | 20 63 6f 6e 74 61 69 6e |does not| contain|
|000007c0| 20 74 68 65 20 69 73 71 | 6c 20 75 74 69 6c 69 74 | the isq|l utilit|
|000007d0| 79 2e 0d 0a 0d 0a 2a 2f | 0d 0a 63 69 6c 69 74 79 |y.....*/|..cility|
|000007e0| 20 28 53 41 46 29 20 66 | 6f 72 20 74 68 69 73 20 | (SAF) f|or this |
|000007f0| 61 63 74 69 76 69 74 79 | 2e 20 2a 2f 0d 0a 0d 0a |activity|. */....|
|00000800| 73 65 6c 65 63 74 20 74 | 79 70 65 2c 20 74 69 74 |select t|ype, tit|
|00000810| 6c 65 20 0d 0a 66 72 6f | 6d 20 74 69 74 6c 65 73 |le ..fro|m titles|
|00000820| 0d 0a 77 68 65 72 65 20 | 74 79 70 65 20 3d 20 27 |..where |type = '|
|00000830| 6d 6f 64 5f 63 6f 6f 6b | 27 0d 0a 67 6f 0d 0a 0d |mod_cook|'..go...|
|00000840| 0a 62 65 67 69 6e 20 74 | 72 61 6e 73 61 63 74 69 |.begin t|ransacti|
|00000850| 6f 6e 0d 0a db 20 04 75 | 70 64 61 74 65 20 74 69 |on... .u|pdate ti|
|00000860| 74 6c 65 73 0d 0a db 20 | 04 73 65 74 20 74 79 70 |tles... |.set typ|
|00000870| 65 20 3d 20 27 70 6f 70 | 5f 70 73 79 63 68 27 0d |e = 'pop|_psych'.|
|00000880| 0a db 20 04 77 68 65 72 | 65 20 74 79 70 65 20 3d |.. .wher|e type =|
|00000890| 20 27 70 73 79 63 68 6f | 6c 6f 67 79 27 0d 0a 63 | 'psycho|logy'..c|
|000008a0| 6f 6d 6d 69 74 20 74 72 | 61 6e 73 61 63 74 69 6f |ommit tr|ansactio|
|000008b0| 6e 0d 0a 0d 0a db 00 1e | 73 65 6c 65 63 74 20 73 |n.......|select s|
|000008c0| 79 73 63 6f 6c 75 6d 6e | 73 2e 6e 61 6d 65 0d 0a |yscolumn|s.name..|
|000008d0| 66 72 6f 6d 20 73 79 73 | 63 6f 6c 75 6d 6e 73 2c |from sys|columns,|
|000008e0| 20 73 79 73 6f 62 6a 65 | 63 74 73 0d 0a 77 68 65 | sysobje|cts..whe|
|000008f0| 72 65 20 73 79 73 63 6f | 6c 75 6d 6e 73 2e 69 64 |re sysco|lumns.id|
|00000900| 20 3d 20 73 79 73 6f 62 | 6a 65 63 74 73 2e 69 64 | = sysob|jects.id|
|00000910| 0d 0a 61 6e 64 20 73 79 | 73 6f 62 6a 65 63 74 73 |..and sy|sobjects|
|00000920| 2e 6e 61 6d 65 20 3d 20 | 27 61 75 74 68 6f 72 73 |.name = |'authors|
|00000930| 27 0d 0a 00 f6 fa 00 00 | 4d 4f 53 2d 44 4f 53 2d |'.......|MOS-DOS-|
|00000940| 36 30 20 28 db 00 0a 8d | ad 21 db 00 07 44 4f 53 |60 (....|.!...DOS|
|00000950| db 20 08 10 db 00 0a b7 | ad 21 00 02 db 00 05 57 |. ......|.!.....W|
|00000960| 49 4e 41 32 30 20 20 33 | 38 36 20 db 00 0a 80 32 |INA20  3|86 ....2|
|00000970| 3e 1b 70 01 85 24 00 00 | 43 43 44 4f 53 db 20 06 |>.p..$..|CCDOS. .|
|00000980| 10 db 00 0a 77 0b 47 1c | d6 05 db 00 04 43 58 44 |....w.G.|.....CXD|
|00000990| 4f 53 db 20 06 10 db 00 | 0a 7d 0b 2b 1c 36 06 db |OS. ....|.}.+.6..|
|000009a0| 00 04 54 41 50 45 db 20 | 07 10 db 00 0a 01 af 21 |..TAPE. |.......!|
|000009b0| 00 d8 05 db 00 04 5a 52 | 4d db 20 08 10 db 00 0a |......ZR|M. .....|
|000009c0| 8c 0b 2b 1c de 05 db 00 | 04 42 31 31 38 4d 4c db |..+.....|.B118ML.|
|000009d0| 20 05 10 db 00 0a ce 0b | 42 1c 1c 6b db 00 04 57 | .......|B..k...W|
|000009e0| 49 4e 44 4f 57 53 db 20 | 04 10 db 00 0a 2d b1 22 |INDOWS. |.....-."|
|000009f0| 00 17 01 db 00 04 4d 49 | 53 43 54 45 58 54 db 20 |......MI|SCTEXT. |
|00000a00| 03 10 db 00 0a 6b 06 2c | 1c eb 05 db 00 04 42 41 |.....k.,|......BA|
|00000a10| 44 43 52 43 20 20 45 58 | 45 20 db 00 0a 94 85 94 |DCRC  EX|E ......|
|00000a20| 19 bb 07 3f 03 00 00 49 | 4e 53 54 41 4c 4c 20 42 |...?...I|NSTALL B|
|00000a30| 41 54 db 00 0b fb 13 37 | 1b a2 06 3e 0f 00 00 62 |AT.....7|...>...b|
|00000a40| 65 67 69 6e 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |egin tra|nsaction|
|00000a50| 0d 0a db 20 04 75 70 64 | 61 74 65 20 74 69 74 6c |... .upd|ate titl|
|00000a60| 65 73 0d 0a db 20 04 73 | 65 74 20 74 79 70 65 20 |es... .s|et type |
|00000a70| 3d 20 27 63 6f 6d 6d 65 | 72 63 65 27 0d 0a db 20 |= 'comme|rce'... |
|00000a80| 04 77 68 65 72 65 20 74 | 79 70 65 20 3d 20 27 62 |.where t|ype = 'b|
|00000a90| 75 73 69 6e 65 73 73 27 | 0d 0a 30 06 31 06 ff ff |usiness'|..0.1...|
|00000aa0| 33 06 34 06 db ff 0a 3a | 06 3b 06 3c 06 ff ff 3e |3.4....:|.;.<...>|
|00000ab0| 06 3f 06 40 06 41 06 42 | 06 43 06 44 06 45 06 46 |.?.@.A.B|.C.D.E.F|
|00000ac0| 06 47 06 48 06 49 06 4a | 06 4b 06 ff ff 4d 06 4e |.G.H.I.J|.K...M.N|
|00000ad0| 06 4f 06 ff ff 51 06 ff | ff 53 06 54 06 55 06 56 |.O...Q..|.S.T.U.V|
|00000ae0| 06 57 06 ff ff 59 06 5a | 06 5b 06 5c 06 5d 06 5e |.W...Y.Z|.[.\.].^|
|00000af0| 06 5f 06 60 06 61 06 62 | 06 63 06 64 06 65 06 ff |._.`.a.b|.c.d.e..|
|00000b00| ff 67 06 db ff 04 6b 06 | 81 06 6c 06 6d 06 db ff |.g....k.|..l.m...|
|00000b10| 08 72 06 73 06 74 06 ff | ff 76 06 77 06 78 06 7f |.r.s.t..|.v.w.x..|
|00000b20| 06 db ff 0c a3 06 ff ff | 83 06 ff ff 85 06 ff ff |........|........|
|00000b30| 86 06 87 06 88 06 89 06 | 8b 06 ff ff 8d 06 ff ff |........|........|
|00000b40| 8e 06 8f 06 90 06 ff ff | 92 06 94 06 21 12 95 06 |........|....!...|
|00000b50| 96 06 97 06 98 06 99 06 | 9a 06 9b 06 9d 06 ff ff |........|........|
|00000b60| 9e 06 9f 06 a0 06 6b 07 | 67 07 ff ff a4 06 a5 06 |......k.|g.......|
|00000b70| ff ff a7 06 a8 06 a9 06 | aa 06 ab 06 ac 06 ad 06 |........|........|
|00000b80| ae 06 ff ff b0 06 b1 06 | b2 06 b3 06 b4 06 b5 06 |........|........|
|00000b90| b6 06 ff ff b8 06 b9 06 | ba 06 bb 06 bc 06 bd 06 |........|........|
|00000ba0| be 06 ff ff c0 06 c1 06 | c2 06 c3 06 c4 06 c5 06 |........|........|
|00000bb0| c6 06 ff ff c8 06 c9 06 | ca 06 db ff 04 cd 06 ce |........|........|
|00000bc0| 06 cf 06 ff ff d1 06 d3 | 06 ff ff d4 06 d5 06 d6 |........|........|
|00000bd0| 06 dc 06 d8 06 ff ff da | 06 db ff 04 dd 06 de 06 |........|........|
|00000be0| df 06 e0 06 e1 06 e2 06 | e3 06 e4 06 e5 06 e6 06 |........|........|
|00000bf0| e7 06 e8 06 e9 06 ea 06 | eb 06 ec 06 ed 06 ee 06 |........|........|
|00000c00| ef 06 f0 06 f1 06 f2 06 | f3 06 f4 06 f5 06 f6 06 |........|........|
|00000c10| f7 06 f8 06 f9 06 fa 06 | fb 06 fc 06 fd 06 fe 06 |........|........|
|00000c20| ff 06 00 07 73 65 6c 65 | 63 74 20 74 79 70 65 2c |....sele|ct type,|
|00000c30| 20 74 69 74 6c 65 20 0d | 0a 66 72 6f 6d 20 74 69 | title .|.from ti|
|00000c40| 74 6c 65 73 0d 0a 6d 20 | 74 69 74 6c 65 73 0d 0a |tles..m |titles..|
|00000c50| 6f 72 64 65 72 20 62 79 | 20 70 75 62 5f 69 64 0d |order by| pub_id.|
|00000c60| 0a db 00 ff db 00 c4 62 | 65 67 69 6e 20 74 72 61 |.......b|egin tra|
|00000c70| 6e 73 61 63 74 69 6f 6e | 0d 0a db 20 04 75 70 64 |nsaction|... .upd|
|00000c80| 61 74 65 20 74 69 74 6c | 65 73 0d 0a db 20 04 73 |ate titl|es... .s|
|00000c90| 65 74 20 74 79 70 65 20 | 3d 20 27 63 6f 6d 70 75 |et type |= 'compu|
|00000ca0| 74 65 72 73 27 0d 0a db | 20 04 77 68 65 72 65 20 |ters'...| .where |
|00000cb0| 74 79 70 65 20 3d 20 27 | 70 6f 70 75 6c 61 72 5f |type = '|popular_|
|00000cc0| 63 6f 6d 70 27 0d 0a 63 | 6f 6d 6d 69 74 20 74 72 |comp'..c|ommit tr|
|00000cd0| 61 6e 73 61 63 74 69 6f | 6e 0d 0a 0d 0a 2f 2a 54 |ansactio|n..../*T|
|00000ce0| 68 65 20 66 69 72 73 74 | 20 74 72 61 6e 73 61 63 |he first| transac|
|00000cf0| 74 69 6f 6e 20 68 61 73 | 20 62 65 65 6e 20 63 6f |tion has| been co|
|00000d00| 6d 6d 69 74 74 65 64 20 | 74 6f 20 74 68 65 20 64 |mmitted |to the d|
|00000d10| 61 74 61 62 61 73 65 2a | 2f 0d 0a 0d 0a 62 65 67 |atabase*|/....beg|
|00000d20| 69 6e 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 0d 0a |in trans|action..|
|00000d30| db 20 04 75 70 64 61 74 | 65 20 74 69 74 6c 65 73 |. .updat|e titles|
|00000d40| 0d 0a db 20 04 73 65 74 | 20 61 64 76 61 6e 63 65 |... .set| advance|
|00000d50| 20 3d 20 24 33 db 30 03 | 0d 0a db 20 04 77 68 65 | = $3.0.|... .whe|
|00000d60| 72 65 20 74 69 74 6c 65 | 5f 69 64 20 3d 20 27 50 |re title|_id = 'P|
|00000d70| 53 db 37 04 27 0d 0a db | 20 04 77 61 69 74 66 6f |S.7.'...| .waitfo|
|00000d80| 72 20 64 65 6c 61 79 20 | 27 30 30 3a 30 31 27 0d |r delay |'00:01'.|
|00000d90| 0a 0d 0a 2f 2a 50 61 75 | 73 69 6e 67 20 66 6f 72 |.../*Pau|sing for|
|00000da0| 20 6f 6e 65 20 6d 69 6e | 75 74 65 20 69 6e 20 74 | one min|ute in t|
|00000db0| 68 65 20 6d 69 64 64 6c | 65 20 6f 66 20 74 68 65 |he middl|e of the|
|00000dc0| 20 73 65 63 6f 6e 64 20 | 0d 0a 2a 2a 74 72 61 6e | second |..**tran|
|00000dd0| 73 61 63 74 69 6f 6e 20 | 74 6f 20 67 69 76 65 20 |saction |to give |
|00000de0| 79 6f 75 20 61 6e 20 6f | 70 70 6f 72 74 75 6e 69 |you an o|pportuni|
|00000df0| 74 79 20 74 6f 20 72 65 | 62 6f 6f 74 20 62 6f 74 |ty to re|boot bot|
|00000e00| 68 20 0d 0a 2a 2a 73 79 | 73 74 65 6d 73 2e 20 54 |h ..**sy|stems. T|
|00000e10| 68 69 73 20 74 72 61 6e | 73 61 63 74 69 6f 6e 20 |his tran|saction |
|00000e20| 77 69 6c 6c 20 6e 6f 74 | 20 62 65 20 72 65 66 6c |will not| be refl|
|00000e30| 65 63 74 65 64 20 69 6e | 20 74 68 65 20 0d 0a 2a |ected in| the ..*|
|00000e40| 2a 64 61 74 61 62 61 73 | 65 20 62 65 63 61 75 73 |*databas|e becaus|
|00000e50| 65 20 69 74 20 64 69 64 | 20 6e 6f 74 20 72 65 61 |e it did| not rea|
|00000e60| 63 68 20 74 68 65 20 63 | 6f 6d 6d 69 74 20 73 74 |ch the c|ommit st|
|00000e70| 61 74 65 6d 65 6e 74 2e | 2a 2f 0d 0a 0d 0a 63 6f |atement.|*/....co|
|00000e80| 6d 6d 69 74 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |mmit tra|nsaction|
|00000e90| 0d 0a db 20 2f 0d 0a db | 00 ff db 00 9d 73 65 6c |... /...|.....sel|
|00000ea0| 65 63 74 20 74 69 74 6c | 65 5f 69 64 2c 20 74 79 |ect titl|e_id, ty|
|00000eb0| 70 65 2c 20 74 69 74 6c | 65 2c 20 61 64 76 61 6e |pe, titl|e, advan|
|00000ec0| 63 65 20 0d 0a 66 72 6f | 6d 20 74 69 74 6c 65 73 |ce ..fro|m titles|
|00000ed0| 0d 0a db 00 ff db 00 cc | 62 65 67 69 6e 20 74 72 |........|begin tr|
|00000ee0| 61 6e 73 61 63 74 69 6f | 6e 0d 0a db 20 04 75 70 |ansactio|n... .up|
|00000ef0| 64 61 74 65 20 74 69 74 | 6c 65 73 0d 0a db 20 04 |date tit|les... .|
|00000f00| 73 65 74 20 61 64 76 61 | 6e 63 65 20 3d 20 24 33 |set adva|nce = $3|
|00000f10| db 30 03 0d 0a db 20 04 | 77 68 65 72 65 20 74 69 |.0.... .|where ti|
|00000f20| 74 6c 65 5f 69 64 20 3d | 20 27 50 53 db 37 04 27 |tle_id =| 'PS.7.'|
|00000f30| 0d 0a 63 6f 6d 6d 69 74 | 20 74 72 61 6e 73 61 63 |..commit| transac|
|00000f40| 74 69 6f 6e 0d 0a 0d 0a | 68 6f 72 73 27 0d 0a db |tion....|hors'...|
|00000f50| 00 ff db 00 86 62 65 67 | 69 6e 20 74 72 61 6e 73 |.....beg|in trans|
|00000f60| 61 63 74 69 6f 6e 0d 0a | db 20 04 75 70 64 61 74 |action..|. .updat|
|00000f70| 65 20 73 74 6f 72 65 73 | 0d 0a db 20 04 73 65 74 |e stores|... .set|
|00000f80| 20 73 74 6f 72 5f 61 64 | 64 72 65 73 73 20 3d 20 | stor_ad|dress = |
|00000f90| 27 32 32 31 20 43 68 61 | 70 6d 61 6e 20 42 6c 76 |'221 Cha|pman Blv|
|00000fa0| 64 27 2c 20 63 69 74 79 | 20 3d 20 27 4f 72 61 6e |d', city| = 'Oran|
|00000fb0| 67 65 27 0d 0a db 20 04 | 77 68 65 72 65 20 73 74 |ge'... .|where st|
|00000fc0| 6f 72 5f 6e 61 6d 65 20 | 3d 20 27 42 61 72 6e 75 |or_name |= 'Barnu|
|00000fd0| 6d 27 27 73 27 0d 0a db | 20 04 77 61 69 74 66 6f |m''s'...| .waitfo|
|00000fe0| 72 20 64 65 6c 61 79 20 | 27 30 30 3a 30 30 3a 32 |r delay |'00:00:2|
|00000ff0| 30 27 0d 0a 63 6f 6d 6d | 69 74 20 74 72 61 6e 73 |0'..comm|it trans|
|00001000| 61 63 74 69 6f 6e 0d 0a | db 00 ff db 00 4a 62 65 |action..|.....Jbe|
|00001010| 67 69 6e 20 74 72 61 6e | 73 61 63 74 69 6f 6e 0d |gin tran|saction.|
|00001020| 0a db 20 04 73 65 6c 65 | 63 74 20 74 79 70 65 2c |.. .sele|ct type,|
|00001030| 20 74 69 74 6c 65 0d 0a | db 20 04 66 72 6f 6d 20 | title..|. .from |
|00001040| 74 69 74 6c 65 73 20 68 | 6f 6c 64 6c 6f 63 6b 0d |titles h|oldlock.|
|00001050| 0a db 20 04 77 61 69 74 | 66 6f 72 20 64 65 6c 61 |.. .wait|for dela|
|00001060| 79 20 27 30 30 3a 30 30 | 3a 32 30 27 0d 0a 63 6f |y '00:00|:20'..co|
|00001070| 6d 6d 69 74 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |mmit tra|nsaction|
|00001080| 0d 0a db 00 ff db 00 8a | 62 65 67 69 6e 20 74 72 |........|begin tr|
|00001090| 61 6e 73 61 63 74 69 6f | 6e 0d 0a db 20 04 75 70 |ansactio|n... .up|
|000010a0| 64 61 74 65 20 74 69 74 | 6c 65 73 0d 0a db 20 04 |date tit|les... .|
|000010b0| 73 65 74 20 61 64 76 61 | 6e 63 65 20 3d 20 24 35 |set adva|nce = $5|
|000010c0| db 30 03 0d 0a db 20 04 | 77 68 65 72 65 20 74 69 |.0.... .|where ti|
|000010d0| 74 6c 65 20 3d 20 27 53 | 65 63 72 65 74 73 20 6f |tle = 'S|ecrets o|
|000010e0| 66 20 53 69 6c 69 63 6f | 6e 20 56 61 6c 6c 65 79 |f Silico|n Valley|
|000010f0| 27 0d 0a db 20 04 77 61 | 69 74 66 6f 72 20 64 65 |'... .wa|itfor de|
|00001100| 6c 61 79 20 27 30 30 3a | 30 30 3a 32 30 27 0d 0a |lay '00:|00:20'..|
|00001110| db 20 04 75 70 64 61 74 | 65 20 73 74 6f 72 65 73 |. .updat|e stores|
|00001120| 0d 0a db 20 04 73 65 74 | 20 73 74 6f 72 5f 61 64 |... .set| stor_ad|
|00001130| 64 72 65 73 73 20 3d 20 | 27 32 32 31 20 43 68 61 |dress = |'221 Cha|
|00001140| 70 6d 61 6e 20 42 6c 76 | 64 2c 20 53 75 69 74 65 |pman Blv|d, Suite|
|00001150| 20 41 27 0d 0a db 20 04 | 77 68 65 72 65 20 73 74 | A'... .|where st|
|00001160| 6f 72 5f 61 64 64 72 65 | 73 73 20 3d 20 27 32 32 |or_addre|ss = '22|
|00001170| 31 20 43 68 61 70 6d 61 | 6e 20 42 6c 76 64 27 0d |1 Chapma|n Blvd'.|
|00001180| 0a 63 6f 6d 6d 69 74 20 | 74 72 61 6e 73 61 63 74 |.commit |transact|
|00001190| 69 6f 6e 0d 0a db 00 ec | 63 72 65 61 74 65 20 70 |ion.....|create p|
|000011a0| 72 6f 63 20 70 75 62 5f | 69 6e 66 6f 20 0d 0a db |roc pub_|info ...|
|000011b0| 20 04 40 70 75 62 6e 61 | 6d 65 20 76 61 72 63 68 | .@pubna|me varch|
|000011c0| 61 72 28 34 30 29 20 3d | 20 27 41 6c 67 6f 64 61 |ar(40) =| 'Algoda|
|000011d0| 74 61 20 49 6e 66 6f 73 | 79 73 74 65 6d 73 27 20 |ta Infos|ystems' |
|000011e0| 0d 0a db 20 04 61 73 0d | 0a db 20 08 73 65 6c 65 |... .as.|.. .sele|
|000011f0| 63 74 20 61 75 5f 6c 6e | 61 6d 65 2c 20 61 75 5f |ct au_ln|ame, au_|
|00001200| 66 6e 61 6d 65 2c 20 70 | 75 62 5f 6e 61 6d 65 0d |fname, p|ub_name.|
|00001210| 0a db 20 08 66 72 6f 6d | 20 61 75 74 68 6f 72 73 |.. .from| authors|
|00001220| 20 61 2c 20 70 75 62 6c | 69 73 68 65 72 73 20 70 | a, publ|ishers p|
|00001230| 2c 20 74 69 74 6c 65 73 | 20 74 2c 20 74 69 74 6c |, titles| t, titl|
|00001240| 65 61 75 74 68 6f 72 20 | 74 61 0d 0a db 20 08 77 |eauthor |ta... .w|
|00001250| 68 65 72 65 20 40 70 75 | 62 6e 61 6d 65 20 3d 20 |here @pu|bname = |
|00001260| 70 2e 70 75 62 5f 6e 61 | 6d 65 0d 0a db 20 08 61 |p.pub_na|me... .a|
|00001270| 6e 64 20 61 2e 61 75 5f | 69 64 20 3d 20 74 61 2e |nd a.au_|id = ta.|
|00001280| 61 75 5f 69 64 0d 0a db | 20 08 61 6e 64 20 74 2e |au_id...| .and t.|
|00001290| 74 69 74 6c 65 5f 69 64 | 20 3d 20 74 61 2e 74 69 |title_id| = ta.ti|
|000012a0| 74 6c 65 5f 69 64 0d 0a | db 20 08 61 6e 64 20 74 |tle_id..|. .and t|
|000012b0| 2e 70 75 62 5f 69 64 20 | 3d 20 70 2e 70 75 62 5f |.pub_id |= p.pub_|
|000012c0| 69 64 0d 0a db 00 b4 65 | 78 65 63 20 70 75 62 5f |id.....e|xec pub_|
|000012d0| 69 6e 66 6f 20 27 42 69 | 6e 6e 65 74 20 26 20 48 |info 'Bi|nnet & H|
|000012e0| 61 72 64 6c 65 79 27 0d | 0a 0d 0a 0d 0a db 20 04 |ardley'.|...... .|
|000012f0| 73 65 74 20 61 64 76 61 | 6e 63 65 20 3d 20 24 33 |set adva|nce = $3|
|00001300| db 30 03 0d 0a db 20 04 | 77 68 65 72 65 20 74 69 |.0.... .|where ti|
|00001310| 74 6c 65 5f 69 64 20 3d | 20 27 50 53 db 37 04 27 |tle_id =| 'PS.7.'|
|00001320| 0d 0a 63 6f 6d 6d 69 74 | 20 74 72 61 6e 73 61 63 |..commit| transac|
|00001330| 74 69 6f 6e 0d 0a 0d 0a | 68 6f 72 73 27 0d 0a db |tion....|hors'...|
|00001340| 00 ff db 00 86 45 12 ff | 41 43 54 31 30 41 20 20 |.....E..|ACT10A  |
|00001350| 51 52 59 20 ff 00 0a 01 | 00 55 18 13 00 94 02 00 |QRY ....|.U......|
|00001360| 00 41 43 54 31 30 42 20 | 20 51 52 59 20 ff 00 0a |.ACT10B | QRY ...|
|00001370| 01 00 55 18 15 00 6b 0d | 00 00 41 43 54 31 31 41 |..U...k.|..ACT11A|
|00001380| 20 20 51 52 59 20 ff 00 | 0a 01 00 55 18 1c 00 38 |  QRY ..|...U...8|
|00001390| ff 00 03 41 43 54 31 31 | 42 20 20 51 52 59 20 ff |...ACT11|B  QRY .|
|000013a0| 00 0a 01 00 55 18 1d 00 | 31 ff 00 03 41 43 54 31 |....U...|1...ACT1|
|000013b0| 31 43 20 20 51 52 59 20 | ff 00 0a 01 00 55 18 1e |1C  QRY |.....U..|
|000013c0| 00 b4 ff 00 03 41 43 54 | 31 31 44 20 20 51 52 59 |.....ACT|11D  QRY|
|000013d0| 20 ff 00 0a 01 00 55 18 | 1f 00 33 ff 00 03 41 43 | .....U.|..3...AC|
|000013e0| 54 31 32 ff 20 03 51 52 | 59 20 ff 00 0a 01 00 55 |T12. .QR|Y .....U|
|000013f0| 18 20 00 48 ff 00 03 41 | 43 54 31 33 41 20 20 51 |. .H...A|CT13A  Q|
|00001400| 52 59 20 ff 00 0a 01 00 | 55 18 21 00 2c ff 00 03 |RY .....|U.!.,...|
|00001410| 41 43 54 31 33 42 20 20 | 51 52 59 20 ff 00 0a 01 |ACT13B  |QRY ....|
|00001420| 00 55 18 22 00 86 ff 00 | 03 41 43 54 31 33 43 20 |.U."....|.ACT13C |
|00001430| 20 51 52 59 20 ff 00 0a | 01 00 55 18 23 00 58 ff | QRY ...|..U.#.X.|
|00001440| 00 03 41 43 54 31 33 44 | 20 20 51 52 59 20 ff 00 |..ACT13D|  QRY ..|
|00001450| 0a 01 00 55 18 24 00 22 | ff 00 03 41 43 54 31 33 |...U.$."|...ACT13|
|00001460| 45 20 20 51 52 59 20 ff | 00 0a 01 00 55 18 25 00 |E  QRY .|....U.%.|
|00001470| 72 ff 00 03 41 43 54 31 | 33 46 20 20 51 52 59 20 |r...ACT1|3F  QRY |
|00001480| ff 00 0a 01 00 55 18 26 | 00 17 ff 00 03 41 43 54 |.....U.&|.....ACT|
|00001490| 31 33 47 20 20 51 52 59 | 20 ff 00 0a 01 00 55 18 |13G  QRY| .....U.|
|000014a0| 27 00 6b ff 00 03 41 43 | 54 31 34 41 20 20 51 52 |'.k...AC|T14A  QR|
|000014b0| 59 20 ff 00 0a 01 00 55 | 18 28 00 f5 ff 00 03 41 |Y .....U|.(.....A|
|000014c0| 43 54 31 34 42 20 20 51 | 52 59 20 ff 00 0a 01 00 |CT14B  Q|RY .....|
|000014d0| 55 18 29 00 2f ff 00 03 | 63 72 65 61 74 65 20 74 |U.)./...|create t|
|000014e0| 61 62 6c 65 20 68 69 65 | 72 61 72 63 68 79 20 28 |able hie|rarchy (|
|000014f0| 70 61 72 65 6e 74 20 63 | 68 61 72 28 32 30 29 2c |parent c|har(20),|
|00001500| 20 63 68 69 6c 64 20 63 | 68 61 72 28 32 30 29 29 | child c|har(20))|
|00001510| 0d 0a 0d 0a 69 6e 73 65 | 72 74 20 69 6e 74 6f 20 |....inse|rt into |
|00001520| 68 69 65 72 61 72 63 68 | 79 0d 0a 76 61 6c 75 65 |hierarch|y..value|
|00001530| 73 20 28 27 45 75 72 6f | 70 65 27 2c 20 27 46 72 |s ('Euro|pe', 'Fr|
|00001540| 61 6e 63 65 27 29 0d 0a | 0d 0a 69 6e 73 65 72 74 |ance')..|..insert|
|00001550| 20 69 6e 74 6f 20 68 69 | 65 72 61 72 63 68 79 0d | into hi|erarchy.|
|00001560| 0a 76 61 6c 75 65 73 20 | 28 27 46 72 61 6e 63 65 |.values |('France|
|00001570| 27 2c 20 27 50 61 72 69 | 73 27 29 0d 0a 0d 0a 69 |', 'Pari|s')....i|
|00001580| 6e 73 65 72 74 20 69 6e | 74 6f 20 68 69 65 72 61 |nsert in|to hiera|
|00001590| 72 63 68 79 0d 0a 76 61 | 6c 75 65 73 20 28 27 55 |rchy..va|lues ('U|
|000015a0| 6e 69 74 65 64 20 53 74 | 61 74 65 73 27 2c 20 27 |nited St|ates', '|
|000015b0| 4e 65 77 20 59 6f 72 6b | 27 29 0d 0a 0d 0a 69 6e |New York|')....in|
|000015c0| 73 65 72 74 20 69 6e 74 | 6f 20 68 69 65 72 61 72 |sert int|o hierar|
|000015d0| 63 68 79 0d 0a 76 61 6c | 75 65 73 20 28 27 4e 65 |chy..val|ues ('Ne|
|000015e0| 77 20 59 6f 72 6b 27 2c | 20 27 4e 65 77 20 59 6f |w York',| 'New Yo|
|000015f0| 72 6b 20 43 69 74 79 27 | 29 0d 0a 0d 0a 69 6e 73 |rk City'|)....ins|
|00001600| 65 72 74 20 69 6e 74 6f | 20 68 69 65 72 61 72 63 |ert into| hierarc|
|00001610| 68 79 0d 0a 76 61 6c 75 | 65 73 20 28 27 4e 65 77 |hy..valu|es ('New|
|00001620| 20 59 6f 72 6b 20 43 69 | 74 79 27 2c 20 27 4d 61 | York Ci|ty', 'Ma|
|00001630| 6e 68 61 74 74 61 6e 27 | 29 0d 0a 0d 0a 69 6e 73 |nhattan'|)....ins|
|00001640| 65 72 74 20 69 6e 74 6f | 20 68 69 65 72 61 72 63 |ert into| hierarc|
|00001650| 68 79 0d 0a 76 61 6c 75 | 65 73 20 28 27 4e 6f 72 |hy..valu|es ('Nor|
|00001660| 74 68 20 41 6d 65 72 69 | 63 61 27 2c 20 27 55 6e |th Ameri|ca', 'Un|
|00001670| 69 74 65 64 20 53 74 61 | 74 65 73 27 29 0d 0a 0d |ited Sta|tes')...|
|00001680| 0a 69 6e 73 65 72 74 20 | 69 6e 74 6f 20 68 69 65 |.insert |into hie|
|00001690| 72 61 72 63 68 79 0d 0a | 76 61 6c 75 65 73 20 28 |rarchy..|values (|
|000016a0| 27 55 6e 69 74 65 64 20 | 53 74 61 74 65 73 27 2c |'United |States',|
|000016b0| 20 27 57 61 73 68 69 6e | 67 74 6f 6e 27 29 0d 0a | 'Washin|gton')..|
|000016c0| 0d 0a 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 68 69 |..insert| into hi|
|000016d0| 65 72 61 72 63 68 79 0d | 0a 76 61 6c 75 65 73 20 |erarchy.|.values |
|000016e0| 28 27 57 61 73 68 69 6e | 67 74 6f 6e 27 2c 20 27 |('Washin|gton', '|
|000016f0| 52 65 64 6d 6f 6e 64 27 | 29 0d 0a 0d 0a 69 6e 73 |Redmond'|)....ins|
|00001700| 65 72 74 20 69 6e 74 6f | 20 68 69 65 72 61 72 63 |ert into| hierarc|
|00001710| 68 79 0d 0a 76 61 6c 75 | 65 73 20 28 27 57 6f 72 |hy..valu|es ('Wor|
|00001720| 6c 64 27 2c 20 27 45 75 | 72 6f 70 65 27 29 0d 0a |ld', 'Eu|rope')..|
|00001730| 0d 0a 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 68 69 |..insert| into hi|
|00001740| 65 72 61 72 63 68 79 0d | 0a 76 61 6c 75 65 73 20 |erarchy.|.values |
|00001750| 28 27 57 6f 72 6c 64 27 | 2c 20 27 4e 6f 72 74 68 |('World'|, 'North|
|00001760| 20 41 6d 65 72 69 63 61 | 27 29 0d 0a ff 00 ff ff | America|')......|
|00001770| 00 6d 2f 2a 20 20 54 68 | 65 20 70 72 6f 63 65 64 |.m/*  Th|e proced|
|00001780| 75 72 65 20 63 72 65 61 | 74 65 64 20 62 79 20 74 |ure crea|ted by t|
|00001790| 68 69 73 20 71 75 65 72 | 79 20 77 69 6c 6c 20 22 |his quer|y will "|
|000017a0| 65 78 70 6c 6f 64 65 22 | 20 61 20 42 69 6c 6c 20 |explode"| a Bill |
|000017b0| 6f 66 20 4d 61 74 65 72 | 69 61 6c 73 0d 0a 74 6f |of Mater|ials..to|
|000017c0| 20 61 6e 20 61 72 62 69 | 74 72 61 72 79 20 64 65 | an arbi|trary de|
|000017d0| 70 74 68 2e 20 49 74 20 | 75 73 65 73 20 61 20 22 |pth. It |uses a "|
|000017e0| 73 74 61 63 6b 22 20 69 | 6e 20 74 68 65 20 66 6f |stack" i|n the fo|
|000017f0| 72 6d 20 6f 66 20 61 20 | 74 65 6d 70 6f 72 61 72 |rm of a |temporar|
|00001800| 79 20 74 61 62 6c 65 2c | 0d 0a 73 69 6d 69 6c 61 |y table,|..simila|
|00001810| 72 20 74 6f 20 73 74 61 | 63 6b 73 20 69 6e 20 6f |r to sta|cks in o|
|00001820| 74 68 65 72 20 70 72 6f | 67 72 61 6d 6d 69 6e 67 |ther pro|gramming|
|00001830| 20 6c 61 6e 67 75 61 67 | 65 73 2e 20 20 54 68 65 | languag|es.  The|
|00001840| 20 63 75 72 72 65 6e 74 | 20 70 61 72 65 6e 74 20 | current| parent |
|00001850| 69 73 0d 0a 70 6c 61 63 | 65 64 20 6f 6e 20 74 68 |is..plac|ed on th|
|00001860| 65 20 73 74 61 63 6b 2c | 20 74 68 65 20 63 68 69 |e stack,| the chi|
|00001870| 6c 64 72 65 6e 20 6f 66 | 20 74 68 61 74 20 70 61 |ldren of| that pa|
|00001880| 72 65 6e 74 20 61 72 65 | 20 66 6f 75 6e 64 20 61 |rent are| found a|
|00001890| 6e 64 20 61 64 64 65 64 | 20 74 6f 20 74 68 65 0d |nd added| to the.|
|000018a0| 0a 73 74 61 63 6b 2c 20 | 61 6e 64 20 74 68 65 20 |.stack, |and the |
|000018b0| 70 61 72 65 6e 74 20 69 | 73 20 64 65 6c 65 74 65 |parent i|s delete|
|000018c0| 64 2e 20 54 68 65 20 70 | 72 6f 63 65 64 75 72 65 |d. The p|rocedure|
|000018d0| 20 74 68 65 6e 20 74 72 | 69 65 73 20 74 6f 20 66 | then tr|ies to f|
|000018e0| 69 6e 64 20 74 68 65 20 | 6e 65 78 74 0d 0a 6c 65 |ind the |next..le|
|000018f0| 76 65 6c 20 6f 66 20 63 | 68 69 6c 64 72 65 6e 20 |vel of c|hildren |
|00001900| 64 6f 77 6e 20 66 6f 72 | 20 65 76 65 72 79 20 65 |down for| every e|
|00001910| 6e 74 72 79 20 69 6e 20 | 74 68 65 20 73 74 61 63 |ntry in |the stac|
|00001920| 6b 2e 20 54 68 69 73 20 | 63 6f 6e 74 69 6e 75 65 |k. This |continue|
|00001930| 73 20 75 6e 74 69 6c 0d | 0a 74 68 65 72 65 20 61 |s until.|.there a|
|00001940| 72 65 20 6e 6f 20 6d 6f | 72 65 20 6c 6f 77 65 72 |re no mo|re lower|
|00001950| 20 6c 65 76 65 6c 73 20 | 6f 66 20 63 68 69 6c 64 | levels |of child|
|00001960| 72 65 6e 2e 0d 0a 0d 0a | 54 68 65 20 6f 75 74 70 |ren.....|The outp|
|00001970| 75 74 20 6f 66 20 74 68 | 69 73 20 70 72 6f 63 65 |ut of th|is proce|
|00001980| 64 75 72 65 20 69 73 20 | 73 69 6d 70 6c 79 20 61 |dure is |simply a|
|00001990| 20 70 72 69 6e 74 6f 75 | 74 20 6f 66 20 74 68 65 | printou|t of the|
|000019a0| 20 70 61 72 65 6e 74 73 | 20 66 6f 6c 6c 6f 77 65 | parents| followe|
|000019b0| 64 0d 0a 62 79 20 61 6c | 6c 20 6f 66 20 74 68 65 |d..by al|l of the|
|000019c0| 69 72 20 63 68 69 6c 64 | 72 65 6e 2c 20 77 69 74 |ir child|ren, wit|
|000019d0| 68 20 65 61 63 68 20 6c | 65 76 65 6c 20 6f 66 20 |h each l|evel of |
|000019e0| 63 68 69 6c 64 20 69 6e | 64 65 6e 74 65 64 2e 20 |child in|dented. |
|000019f0| 2a 2f 0d 0a 0d 0a 0d 0a | 0d 0a 63 72 65 61 74 65 |*/......|..create|
|00001a00| 20 70 72 6f 63 65 64 75 | 72 65 20 42 4f 4d 20 28 | procedu|re BOM (|
|00001a10| 40 63 75 72 72 65 6e 74 | 20 63 68 61 72 28 34 30 |@current| char(40|
|00001a20| 29 29 20 0d 0a 61 73 0d | 0a 73 65 74 20 6e 6f 63 |)) ..as.|.set noc|
|00001a30| 6f 75 6e 74 20 6f 6e ff | 20 15 2f 2a 20 54 75 72 |ount on.| ./* Tur|
|00001a40| 6e 20 6f 66 66 20 70 72 | 69 6e 74 6f 75 74 20 6f |n off pr|intout o|
|00001a50| 66 20 72 6f 77 73 20 70 | 72 6f 63 65 73 73 65 64 |f rows p|rocessed|
|00001a60| 20 2a 2f 0d 0a 0d 0a 64 | 65 63 6c 61 72 65 20 40 | */....d|eclare @|
|00001a70| 6c 65 76 65 6c 20 69 6e | 74 2c ff 20 10 2f 2a 20 |level in|t,. ./* |
|00001a80| 43 72 65 61 74 65 20 74 | 77 6f 20 74 65 6d 70 6f |Create t|wo tempo|
|00001a90| 72 61 72 79 20 76 61 72 | 69 61 62 6c 65 73 20 2a |rary var|iables *|
|00001aa0| 2f 0d 0a ff 20 08 40 6d | 73 67 ff 20 03 63 68 61 |/... .@m|sg. .cha|
|00001ab0| 72 28 34 30 29 0d 0a 0d | 0a 63 72 65 61 74 65 20 |r(40)...|.create |
|00001ac0| 74 61 62 6c 65 20 23 73 | 74 61 63 6b 20 28 63 68 |table #s|tack (ch|
|00001ad0| 69 6c 64 20 63 68 61 72 | 28 32 30 29 2c 20 6c 65 |ild char|(20), le|
|00001ae0| 76 65 6c 20 69 6e 74 29 | ff 20 03 2f 2a 20 43 72 |vel int)|. ./* Cr|
|00001af0| 65 61 74 65 20 74 68 65 | 20 22 73 74 61 63 6b 22 |eate the| "stack"|
|00001b00| 20 2a 2f 0d 0a 0d 0a 69 | 6e 73 65 72 74 20 69 6e | */....i|nsert in|
|00001b10| 74 6f 20 23 73 74 61 63 | 6b 20 76 61 6c 75 65 73 |to #stac|k values|
|00001b20| 20 28 40 63 75 72 72 65 | 6e 74 2c 20 31 29 ff 20 | (@curre|nt, 1). |
|00001b30| 0b 2f 2a 20 54 68 65 20 | 66 69 72 73 74 20 65 6e |./* The |first en|
|00001b40| 74 72 79 20 69 6e 20 74 | 68 65 0d 0a ff 20 32 73 |try in t|he... 2s|
|00001b50| 74 61 63 6b 20 69 73 20 | 74 68 65 20 70 61 72 61 |tack is |the para|
|00001b60| 6d 65 74 65 72 0d 0a ff | 20 32 70 61 73 73 65 64 |meter...| 2passed|
|00001b70| 20 77 68 65 6e 20 70 72 | 6f 63 65 64 75 72 65 20 | when pr|ocedure |
|00001b80| 69 73 0d 0a ff 20 32 63 | 61 6c 6c 65 64 2e 20 54 |is... 2c|alled. T|
|00001b90| 68 69 73 20 69 73 20 6c | 65 76 65 6c 20 31 2e 20 |his is l|evel 1. |
|00001ba0| 2a 2f 0d 0a 0d 0a 73 65 | 6c 65 63 74 20 40 6c 65 |*/....se|lect @le|
|00001bb0| 76 65 6c 20 3d 20 31 ff | 20 12 2f 2a 20 53 65 6c |vel = 1.| ./* Sel|
|00001bc0| 65 63 74 20 69 73 20 75 | 73 65 64 20 74 6f 20 73 |ect is u|sed to s|
|00001bd0| 65 74 20 74 68 65 20 69 | 6e 69 74 69 61 6c 20 76 |et the i|nitial v|
|00001be0| 61 6c 75 65 0d 0a ff 20 | 23 6f 66 20 61 20 76 61 |alue... |#of a va|
|00001bf0| 72 69 61 62 6c 65 20 2a | 2f 0d 0a 0d 0a 77 68 69 |riable *|/....whi|
|00001c00| 6c 65 20 40 6c 65 76 65 | 6c 20 3e 20 30 ff 20 13 |le @leve|l > 0. .|
|00001c10| 2f 2a 20 53 74 6f 70 20 | 74 68 65 20 70 72 6f 63 |/* Stop |the proc|
|00001c20| 65 73 73 20 6f 6e 63 65 | 20 74 68 65 72 65 20 61 |ess once| there a|
|00001c30| 72 65 0d 0a ff 20 23 6e | 6f 20 6d 6f 72 65 20 65 |re... #n|o more e|
|00001c40| 6e 74 72 69 65 73 20 6f | 6e 20 74 68 65 20 73 74 |ntries o|n the st|
|00001c50| 61 63 6b 20 74 6f 20 66 | 69 6e 64 0d 0a ff 20 23 |ack to f|ind... #|
|00001c60| 63 68 69 6c 64 72 65 6e | 20 66 6f 72 2e 20 2a 2f |children| for. */|
|00001c70| 0d 0a 62 65 67 69 6e 0d | 0a 0d 0a ff 20 05 69 66 |..begin.|.... .if|
|00001c80| 20 65 78 69 73 74 73 20 | 28 73 65 6c 65 63 74 20 | exists |(select |
|00001c90| 2a 20 66 72 6f 6d 20 23 | 73 74 61 63 6b 0d 0a ff |* from #|stack...|
|00001ca0| 20 0a 77 68 65 72 65 20 | 6c 65 76 65 6c 20 3d 20 | .where |level = |
|00001cb0| 40 6c 65 76 65 6c 29 ff | 20 09 2f 2a 20 20 41 72 |@level).| ./*  Ar|
|00001cc0| 65 20 74 68 65 72 65 20 | 61 6e 79 20 6d 6f 72 65 |e there |any more|
|00001cd0| 20 70 61 72 65 6e 74 73 | 20 6f 6e 0d 0a ff 20 28 | parents| on... (|
|00001ce0| 74 68 65 20 73 74 61 63 | 6b 20 61 74 20 74 68 65 |the stac|k at the|
|00001cf0| 20 63 75 72 72 65 6e 74 | 20 6c 65 76 65 6c 3f 0d | current| level?.|
|00001d00| 0a ff 20 28 49 66 20 6e | 6f 74 2c 20 6a 75 6d 70 |.. (If n|ot, jump|
|00001d10| 20 74 6f 20 74 68 65 20 | 45 4c 53 45 20 73 74 61 | to the |ELSE sta|
|00001d20| 74 65 6d 65 6e 74 20 2a | 2f 0d 0a 0d 0a ff 20 05 |tement *|/..... .|
|00001d30| 62 65 67 69 6e 0d 0a 0d | 0a ff 20 0a 73 65 6c 65 |begin...|.. .sele|
|00001d40| 63 74 20 40 63 75 72 72 | 65 6e 74 20 3d 20 4d 49 |ct @curr|ent = MI|
|00001d50| 4e 28 63 68 69 6c 64 29 | 0d 0a ff 20 0a 66 72 6f |N(child)|... .fro|
|00001d60| 6d 20 23 73 74 61 63 6b | 0d 0a ff 20 0f 77 68 65 |m #stack|... .whe|
|00001d70| 72 65 20 6c 65 76 65 6c | 20 3d 20 40 6c 65 76 65 |re level| = @leve|
|00001d80| 6c ff 20 05 2f 2a 20 20 | 46 69 6e 64 20 74 68 65 |l. ./*  |Find the|
|00001d90| 20 6f 6e 65 20 6c 6f 77 | 65 73 74 20 70 61 72 65 | one low|est pare|
|00001da0| 6e 74 20 6f 6e 0d 0a ff | 20 28 74 68 65 20 73 74 |nt on...| (the st|
|00001db0| 61 63 6b 20 61 74 20 74 | 68 65 20 63 75 72 72 65 |ack at t|he curre|
|00001dc0| 6e 74 20 6c 65 76 65 6c | 2e 20 20 2a 2f 0d 0a 0d |nt level|.  */...|
|00001dd0| 0a ff 20 0a 73 65 6c 65 | 63 74 20 40 6d 73 67 20 |.. .sele|ct @msg |
|00001de0| 3d 20 53 50 41 43 45 28 | 40 6c 65 76 65 6c 20 2a |= SPACE(|@level *|
|00001df0| 20 34 29 0d 0a ff 20 0f | 2b 20 40 63 75 72 72 65 | 4)... .|+ @curre|
|00001e00| 6e 74 ff 20 0f 2f 2a 20 | 46 69 6c 6c 20 74 68 65 |nt. ./* |Fill the|
|00001e10| 20 6d 73 67 20 73 74 72 | 69 6e 67 0d 0a ff 20 28 | msg str|ing... (|
|00001e20| 77 69 74 68 20 70 61 72 | 65 6e 74 20 6e 61 6d 65 |with par|ent name|
|00001e30| 2c 20 69 6e 64 65 6e 74 | 65 64 20 2a 2f 0d 0a ff |, indent|ed */...|
|00001e40| 20 0a 70 72 69 6e 74 20 | 40 6d 73 67 0d 0a 0d 0a | .print |@msg....|
|00001e50| ff 20 0a 64 65 6c 65 74 | 65 20 66 72 6f 6d 20 23 |. .delet|e from #|
|00001e60| 73 74 61 63 6b 0d 0a ff | 20 0f 77 68 65 72 65 20 |stack...| .where |
|00001e70| 6c 65 76 65 6c 20 3d 20 | 40 6c 65 76 65 6c 0d 0a |level = |@level..|
|00001e80| ff 20 0f 61 6e 64 20 63 | 68 69 6c 64 20 3d 20 40 |. .and c|hild = @|
|00001e90| 63 75 72 72 65 6e 74 ff | 20 05 2f 2a 20 52 65 6d |current.| ./* Rem|
|00001ea0| 6f 76 65 20 74 68 65 20 | 70 61 72 65 6e 74 20 6a |ove the |parent j|
|00001eb0| 75 73 74 20 70 72 69 6e | 74 65 64 0d 0a ff 20 28 |ust prin|ted... (|
|00001ec0| 66 72 6f 6d 20 74 68 65 | 20 73 74 61 63 6b 20 2a |from the| stack *|
|00001ed0| 2f 0d 0a 0d 0a ff 20 0a | 69 6e 73 65 72 74 20 23 |/..... .|insert #|
|00001ee0| 73 74 61 63 6b 0d 0a ff | 20 0f 73 65 6c 65 63 74 |stack...| .select|
|00001ef0| 20 63 68 69 6c 64 2c 20 | 40 6c 65 76 65 6c 20 2b | child, |@level +|
|00001f00| 20 31 0d 0a ff 20 0f 66 | 72 6f 6d 20 68 69 65 72 | 1... .f|rom hier|
|00001f10| 61 72 63 68 79 0d 0a ff | 20 0f 77 68 65 72 65 20 |archy...| .where |
|00001f20| 70 61 72 65 6e 74 20 3d | 20 40 63 75 72 72 65 6e |parent =| @curren|
|00001f30| 74 20 20 2f 2a 20 49 6e | 73 65 72 74 20 6e 65 77 |t  /* In|sert new|
|00001f40| 20 65 6e 74 72 69 65 73 | 20 6f 6e 20 74 68 65 20 | entries| on the |
|00001f50| 73 74 61 63 6b 0d 0a ff | 20 28 77 68 69 63 68 20 |stack...| (which |
|00001f60| 61 72 65 20 74 68 65 20 | 63 68 69 6c 64 72 65 6e |are the |children|
|00001f70| 20 6f 66 20 74 68 65 20 | 70 61 72 65 6e 74 0d 0a | of the |parent..|
|00001f80| ff 20 28 6a 75 73 74 20 | 70 72 69 6e 74 65 64 2e |. (just |printed.|
|00001f90| 20 54 68 65 73 65 20 62 | 65 63 6f 6d 65 20 74 68 | These b|ecome th|
|00001fa0| 65 20 6e 65 77 0d 0a ff | 20 28 70 61 72 65 6e 74 |e new...| (parent|
|00001fb0| 73 2e 20 2a 2f 0d 0a 0d | 0a ff 20 0a 69 66 20 40 |s. */...|.. .if @|
|00001fc0| 40 72 6f 77 63 6f 75 6e | 74 20 3e 20 30 0d 0a ff |@rowcoun|t > 0...|
|00001fd0| 20 0f 73 65 6c 65 63 74 | 20 40 6c 65 76 65 6c 3d | .select| @level=|
|00001fe0| 40 6c 65 76 65 6c 20 2b | 20 31 ff 20 03 2f 2a 20 |@level +| 1. ./* |
|00001ff0| 57 65 72 65 20 74 68 65 | 72 65 20 61 6e 79 20 63 |Were the|re any c|
|00002000| 68 69 6c 64 72 65 6e 20 | 73 65 6c 65 63 74 65 64 |hildren |selected|
|00002010| 0d 0a ff 20 2a 62 79 20 | 74 68 65 20 6c 61 73 74 |... *by |the last|
|00002020| 20 73 74 61 74 65 6d 65 | 6e 74 3f 20 49 66 20 73 | stateme|nt? If s|
|00002030| 6f 2c 0d 0a ff 20 2a 69 | 6e 63 72 65 6d 65 6e 74 |o,... *i|ncrement|
|00002040| 20 74 68 65 20 40 6c 65 | 76 65 6c 20 76 61 72 69 | the @le|vel vari|
|00002050| 61 62 6c 65 0d 0a ff 20 | 2a 62 79 20 31 2e 20 2a |able... |*by 1. *|
|00002060| 2f 0d 0a 0d 0a ff 20 05 | 65 6e 64 0d 0a 0d 0a ff |/..... .|end.....|
|00002070| 20 05 65 6c 73 65 20 73 | 65 6c 65 63 74 20 40 6c | .else s|elect @l|
|00002080| 65 76 65 6c 20 3d 20 40 | 6c 65 76 65 6c 20 2d 20 |evel = @|level - |
|00002090| 31 ff 20 05 2f 2a 20 57 | 68 65 6e 20 74 68 65 72 |1. ./* W|hen ther|
|000020a0| 65 20 61 72 65 20 6e 6f | 20 6d 6f 72 65 20 70 61 |e are no| more pa|
|000020b0| 72 65 6e 74 73 0d 0a ff | 20 29 6f 6e 20 74 68 65 |rents...| )on the|
|000020c0| 20 73 74 61 63 6b 20 61 | 74 20 74 68 65 20 63 75 | stack a|t the cu|
|000020d0| 72 72 65 6e 74 20 6c 65 | 76 65 6c 2c 0d 0a ff 20 |rrent le|vel,... |
|000020e0| 29 6c 6f 6f 6b 20 62 61 | 63 6b 20 75 70 20 6f 6e |)look ba|ck up on|
|000020f0| 65 20 6c 65 76 65 6c 2e | 20 2a 2f 0d 0a 0d 0a 65 |e level.| */....e|
|00002100| 6e 64 0d 0a ff 00 95 63 | 72 65 61 74 65 20 64 65 |nd.....c|reate de|
|00002110| 66 61 75 6c 74 20 61 75 | 74 68 66 6e 6d 64 66 6c |fault au|thfnmdfl|
|00002120| 74 0d 0a 61 73 20 27 46 | 69 72 73 74 20 4e 61 6d |t..as 'F|irst Nam|
|00002130| 65 20 4e 65 65 64 65 64 | 27 0d 0a 0d 0a 0d 0a 61 |e Needed|'......a|
|00002140| 74 61 20 49 6e 66 6f 73 | 79 73 74 65 6d 73 27 20 |ta Infos|ystems' |
|00002150| 0d 0a ff 20 04 61 73 0d | 0a ff 20 08 73 65 6c 65 |... .as.|.. .sele|
|00002160| 63 74 20 61 75 5f 6c 6e | 61 6d 65 2c 20 61 75 5f |ct au_ln|ame, au_|
|00002170| 66 6e 61 6d 65 2c 20 70 | 75 62 5f 6e 61 6d 65 0d |fname, p|ub_name.|
|00002180| 0a ff 20 08 66 72 6f 6d | 20 61 75 74 68 6f 72 73 |.. .from| authors|
|00002190| 20 61 2c 20 70 75 62 6c | 69 73 68 65 72 73 20 70 | a, publ|ishers p|
|000021a0| 2c 20 74 69 74 6c 65 73 | 20 74 2c 20 74 69 74 6c |, titles| t, titl|
|000021b0| 65 61 75 74 68 6f 72 20 | 74 61 0d 0a ff 20 08 77 |eauthor |ta... .w|
|000021c0| 68 65 72 65 20 40 70 75 | 62 6e 61 6d 65 20 3d 20 |here @pu|bname = |
|000021d0| 70 2e 70 75 62 5f 6e 61 | 6d 65 0d 0a ff 20 08 61 |p.pub_na|me... .a|
|000021e0| 6e 64 20 61 2e 61 75 5f | 69 64 20 3d 20 74 61 2e |nd a.au_|id = ta.|
|000021f0| 61 75 5f 69 64 0d 0a ff | 20 08 61 6e 64 20 74 2e |au_id...| .and t.|
|00002200| 74 69 74 6c 65 5f 69 64 | 20 3d 20 74 61 2e 74 69 |title_id| = ta.ti|
|00002210| 74 6c 65 5f 69 64 0d 0a | ff 20 08 61 6e 64 20 74 |tle_id..|. .and t|
|00002220| 2e 70 75 62 5f 69 64 20 | 3d 20 70 2e 70 75 62 5f |.pub_id |= p.pub_|
|00002230| 69 64 0d 0a ff 00 b4 73 | 70 5f 62 69 6e 64 65 66 |id.....s|p_bindef|
|00002240| 61 75 6c 74 20 61 75 74 | 68 66 6e 6d 64 66 6c 74 |ault aut|hfnmdflt|
|00002250| 2c 20 27 61 75 74 68 6f | 72 73 2e 61 75 5f 66 6e |, 'autho|rs.au_fn|
|00002260| 61 6d 65 27 0d 0a 0d 0a | 61 6e 63 65 20 3d 20 24 |ame'....|ance = $|
|00002270| 33 ff 30 03 0d 0a ff 20 | 04 77 68 65 72 65 20 74 |3.0.... |.where t|
|00002280| 69 74 6c 65 5f 69 64 20 | 3d 20 27 50 53 ff 37 04 |itle_id |= 'PS.7.|
|00002290| 27 0d 0a 63 6f 6d 6d 69 | 74 20 74 72 61 6e 73 61 |'..commi|t transa|
|000022a0| 63 74 69 6f 6e 0d 0a 0d | 0a ff 00 ff ff 00 8d 69 |ction...|.......i|
|000022b0| 6e 73 65 72 74 20 69 6e | 74 6f 20 61 75 74 68 6f |nsert in|to autho|
|000022c0| 72 73 20 28 61 75 5f 69 | 64 2c 20 61 75 5f 6c 6e |rs (au_i|d, au_ln|
|000022d0| 61 6d 65 2c 20 70 68 6f | 6e 65 2c 20 61 64 64 72 |ame, pho|ne, addr|
|000022e0| 65 73 73 2c 20 63 69 74 | 79 2c 20 73 74 61 74 65 |ess, cit|y, state|
|000022f0| 2c 0d 0a 7a 69 70 2c 20 | 63 6f 6e 74 72 61 63 74 |,..zip, |contract|
|00002300| 29 0d 0a 76 61 6c 75 65 | 73 20 28 27 ff 35 03 2d |)..value|s ('.5.-|
|00002310| 35 35 2d ff 35 04 27 2c | 20 27 4d 69 74 63 68 65 |55-.5.',| 'Mitche|
|00002320| 6c 6c 27 2c 20 27 32 30 | 36 20 33 34 35 2d ff 35 |ll', '20|6 345-.5|
|00002330| 04 27 2c 20 27 32 38 34 | 32 20 4e 57 20 39 39 27 |.', '284|2 NW 99'|
|00002340| 2c 0d 0a 27 53 65 61 74 | 74 6c 65 27 2c 20 27 57 |,..'Seat|tle', 'W|
|00002350| 41 27 2c 20 27 39 38 ff | 31 03 27 2c 20 30 29 0d |A', '98.|1.', 0).|
|00002360| 0a ff 00 ff ff 00 4d 73 | 65 6c 65 63 74 20 2a 0d |......Ms|elect *.|
|00002370| 0a 66 72 6f 6d 20 61 75 | 74 68 6f 72 73 0d 0a 77 |.from au|thors..w|
|00002380| 68 65 72 65 20 61 75 5f | 6c 6e 61 6d 65 20 3d 20 |here au_|lname = |
|00002390| 27 4d 69 74 63 68 65 6c | 6c 27 40 6c 65 76 65 6c |'Mitchel|l'@level|
|000023a0| 20 76 61 72 69 61 62 6c | 65 0d 0a ff 20 2a 62 79 | variabl|e... *by|
|000023b0| 20 31 2e 20 2a 2f 0d 0a | 0d 0a ff 20 05 65 6e 64 | 1. */..|... .end|
|000023c0| 0d 0a 0d 0a ff 20 05 65 | 6c 73 65 20 73 65 6c 65 |..... .e|lse sele|
|000023d0| 63 74 20 40 6c 65 76 65 | 6c 20 3d 20 40 6c 65 76 |ct @leve|l = @lev|
|000023e0| 65 6c 20 2d 20 31 ff 20 | 05 2f 2a 20 57 68 65 6e |el - 1. |./* When|
|000023f0| 20 74 68 65 72 65 20 61 | 72 65 20 6e 6f 20 6d 6f | there a|re no mo|
|00002400| 72 65 20 70 61 72 65 6e | 74 73 0d 0a ff 20 29 6f |re paren|ts... )o|
|00002410| 6e 20 74 68 65 20 73 74 | 61 63 6b 20 61 74 20 74 |n the st|ack at t|
|00002420| 68 65 20 63 75 72 72 65 | 6e 74 20 6c 65 76 65 6c |he curre|nt level|
|00002430| 2c 0d 0a ff 20 29 6c 6f | 6f 6b 20 62 61 63 6b 20 |,... )lo|ok back |
|00002440| 75 70 20 6f 6e 65 20 6c | 65 76 65 6c 2e 20 2a 2f |up one l|evel. */|
|00002450| 0d 0a 0d 0a 65 6e 64 0d | 0a ff 00 95 69 6e 73 65 |....end.|....inse|
|00002460| 72 74 20 69 6e 74 6f 20 | 70 75 62 6c 69 73 68 65 |rt into |publishe|
|00002470| 72 73 0d 0a 76 61 6c 75 | 65 73 20 28 27 32 30 30 |rs..valu|es ('200|
|00002480| 31 27 2c 20 27 4a 61 72 | 64 69 6e 20 49 6e 63 2e |1', 'Jar|din Inc.|
|00002490| 27 2c 20 27 43 61 6d 64 | 65 6e 27 2c 20 27 4e 4a |', 'Camd|en', 'NJ|
|000024a0| 27 29 0d 0a 20 0d 0a ff | 20 04 61 73 0d 0a ff 20 |').. ...| .as... |
|000024b0| 08 73 65 6c 65 63 74 20 | 61 75 5f 6c 6e 61 6d 65 |.select |au_lname|
|000024c0| 2c 20 61 75 5f 66 6e 61 | 6d 65 2c 20 70 75 62 5f |, au_fna|me, pub_|
|000024d0| 6e 61 6d 65 0d 0a ff 20 | 08 66 72 6f 6d 20 61 75 |name... |.from au|
|000024e0| 74 68 6f 72 73 20 61 2c | 20 70 75 62 6c 69 73 68 |thors a,| publish|
|000024f0| 65 72 73 20 70 2c 20 74 | 69 74 6c 65 73 20 74 2c |ers p, t|itles t,|
|00002500| 20 74 69 74 6c 65 61 75 | 74 68 6f 72 20 74 61 0d | titleau|thor ta.|
|00002510| 0a ff 20 08 77 68 65 72 | 65 20 40 70 75 62 6e 61 |.. .wher|e @pubna|
|00002520| 6d 65 20 3d 20 70 2e 70 | 75 62 5f 6e 61 6d 65 0d |me = p.p|ub_name.|
|00002530| 0a ff 20 08 61 6e 64 20 | 61 2e 61 75 5f 69 64 20 |.. .and |a.au_id |
|00002540| 3d 20 74 61 2e 61 75 5f | 69 64 0d 0a ff 20 08 61 |= ta.au_|id... .a|
|00002550| 6e 64 20 74 2e 74 69 74 | 6c 65 5f 69 64 20 3d 20 |nd t.tit|le_id = |
|00002560| 74 61 2e 74 69 74 6c 65 | 5f 69 64 0d 0a ff 20 08 |ta.title|_id... .|
|00002570| 61 6e 64 20 74 2e 70 75 | 62 5f 69 64 20 3d 20 70 |and t.pu|b_id = p|
|00002580| 2e 70 75 62 5f 69 64 0d | 0a ff 00 b4 50 0a ff 73 |.pub_id.|....P..s|
|00002590| 70 5f 61 64 64 74 79 70 | 65 20 7a 69 70 31 30 2c |p_addtyp|e zip10,|
|000025a0| 20 27 63 68 61 72 28 31 | 30 29 27 2c 20 27 6e 6f | 'char(1|0)', 'no|
|000025b0| 74 20 6e 75 6c 6c 27 0d | 0a 0d 0a 27 0d 0a 0d 0a |t null'.|...'....|
|000025c0| ff 00 05 f0 86 35 14 03 | ff 00 05 43 4c 49 45 4e |.....5..|...CLIEN|
|000025d0| 54 32 ff 20 04 10 ff 00 | 0a f2 86 35 14 04 ff 00 |T2. ....|...5....|
|000025e0| ff ff 00 a6 63 72 65 61 | 74 65 20 74 61 62 6c 65 |....crea|te table|
|000025f0| 20 70 72 69 6e 74 65 72 | 73 0d 0a 28 70 72 69 6e | printer|s..(prin|
|00002600| 74 5f 69 64 20 63 68 61 | 72 28 34 29 2c 0d 0a 70 |t_id cha|r(4),..p|
|00002610| 72 6e 74 5f 6e 61 6d 65 | 20 76 61 72 63 68 61 72 |rnt_name| varchar|
|00002620| 28 34 30 29 2c 0d 0a 61 | 64 64 72 65 73 73 20 76 |(40),..a|ddress v|
|00002630| 61 72 63 68 61 72 28 34 | 30 29 2c 0d 0a 63 69 74 |archar(4|0),..cit|
|00002640| 79 20 76 61 72 63 68 61 | 72 28 32 30 29 2c 0d 0a |y varcha|r(20),..|
|00002650| 73 74 61 74 65 20 63 68 | 61 72 28 32 29 2c 0d 0a |state ch|ar(2),..|
|00002660| 7a 69 70 20 7a 69 70 31 | 30 29 20 27 32 38 34 32 |zip zip1|0) '2842|
|00002670| 20 4e 57 20 39 39 27 2c | 0d 0a 27 53 65 61 74 74 | NW 99',|..'Seatt|
|00002680| 6c 65 27 2c 20 27 57 41 | 27 2c 20 27 39 38 ff 31 |le', 'WA|', '98.1|
|00002690| 03 27 2c 20 30 29 0d 0a | 00 00 1f 28 a2 16 a4 04 |.', 0)..|...(....|
|000026a0| ee 41 00 00 4b 45 59 42 | 4f 41 52 44 53 59 53 20 |.A..KEYB|OARDSYS |
|000026b0| ff 00 0b 28 c5 16 ac 04 | 89 87 00 00 4e 4c 53 46 |...(....|....NLSF|
|000026c0| 55 4e 43 20 45 58 45 20 | ff 00 0a 1f 28 c5 16 bd |UNC EXE |....(...|
|000026d0| 04 57 20 00 00 44 49 53 | 50 4c 41 59 20 53 59 53 |.W ..DIS|PLAY SYS|
|000026e0| 20 ff 00 0b 28 c5 16 c1 | 04 b0 3d 00 00 45 47 41 | ...(...|..=..EGA|
|000026f0| ff 20 05 43 50 49 20 ff | 00 0b 28 c5 16 c9 04 f9 |. .CPI .|..(.....|
|00002700| e5 00 00 44 49 53 4b 50 | 41 52 4b 43 4f 4d 20 ff |...DISKP|ARKCOM .|
|00002710| 00 0a 1f 60 5c 11 5f 00 | f7 0f 00 00 48 49 4d 45 |...`\._.|....HIME|
|00002720| 4d ff 20 03 53 59 53 20 | ff 00 0b 28 c5 16 e6 04 |M. .SYS |...(....|
|00002730| 20 2d 00 00 4d 4f 44 45 | ff 20 04 43 4f 4d 20 ff | -..MODE|. .COM .|
|00002740| 00 0a 1f 28 c5 16 ec 04 | b5 60 00 00 53 45 54 56 |...(....|.`..SETV|
|00002750| 45 52 20 20 45 58 45 20 | ff 00 0a 1f 28 c5 16 f8 |ER  EXE |....(...|
|00002760| 04 b7 33 00 00 41 4e 53 | 49 ff 20 04 53 59 53 20 |..3..ANS|I. .SYS |
|00002770| ff 00 0b 28 c5 16 03 05 | 45 23 00 00 44 45 42 55 |...(....|E#..DEBU|
|00002780| 47 ff 20 03 45 58 45 20 | ff 00 0a 1f 28 c5 16 08 |G. .EXE |....(...|
|00002790| 05 67 55 00 00 63 72 65 | 61 74 65 20 72 75 6c 65 |.gU..cre|ate rule|
|000027a0| 20 7a 69 70 31 30 72 75 | 6c 65 0d 0a 61 73 20 40 | zip10ru|le..as @|
|000027b0| 7a 69 70 31 30 20 6c 69 | 6b 65 20 27 5b 30 2d 39 |zip10 li|ke '[0-9|
|000027c0| 5d 5b 30 2d 39 5d 5b 30 | 2d 39 5d 5b 30 2d 39 5d |][0-9][0|-9][0-9]|
|000027d0| 5b 30 2d 39 5d 2d 5b 30 | 2d 39 5d 5b 30 2d 39 5d |[0-9]-[0|-9][0-9]|
|000027e0| 5b 30 2d 39 5d 5b 30 2d | 39 5d 27 0d 0a ff 20 16 |[0-9][0-|9]'... .|
|000027f0| 62 79 20 31 2e 20 2a 2f | 0d 0a 0d 0a ff 20 05 65 |by 1. */|..... .e|
|00002800| 6e 64 0d 0a 0d 0a ff 20 | 05 65 6c 73 65 20 73 65 |nd..... |.else se|
|00002810| 6c 65 63 74 20 40 6c 65 | 76 65 6c 20 3d 20 40 6c |lect @le|vel = @l|
|00002820| 65 76 65 6c 20 2d 20 31 | ff 20 05 2f 2a 20 57 68 |evel - 1|. ./* Wh|
|00002830| 65 6e 20 74 68 65 72 65 | 20 61 72 65 20 6e 6f 20 |en there| are no |
|00002840| 6d 6f 72 65 20 70 61 72 | 65 6e 74 73 0d 0a ff 20 |more par|ents... |
|00002850| 29 6f 6e 20 74 68 65 20 | 73 74 61 63 6b 20 61 74 |)on the |stack at|
|00002860| 20 74 68 65 20 63 75 72 | 72 65 6e 74 20 6c 65 76 | the cur|rent lev|
|00002870| 65 6c 2c 0d 0a ff 20 29 | 6c 6f 6f 6b 20 62 61 63 |el,... )|look bac|
|00002880| 6b 20 75 70 20 6f 6e 65 | 20 6c 65 76 65 6c 2e 20 |k up one| level. |
|00002890| 2a 2f 0d 0a 0d 0a 65 6e | 64 0d 0a ff 00 95 73 70 |*/....en|d.....sp|
|000028a0| 5f 62 69 6e 64 72 75 6c | 65 20 7a 69 70 31 30 72 |_bindrul|e zip10r|
|000028b0| 75 6c 65 2c 20 27 7a 69 | 70 31 30 27 0d 0a 0d 0a |ule, 'zi|p10'....|
|000028c0| 30 30 31 27 2c 20 27 4a | 61 72 64 69 6e 20 49 6e |001', 'J|ardin In|
|000028d0| 63 2e 27 2c 20 27 43 61 | 6d 64 65 6e 27 2c 20 27 |c.', 'Ca|mden', '|
|000028e0| 4e 4a 27 29 0d 0a ff 20 | 03 10 ff 00 0a f2 86 35 |NJ')... |.......5|
|000028f0| 14 04 ff 00 ff ff 00 a6 | 69 6e 73 65 72 74 20 69 |........|insert i|
|00002900| 6e 74 6f 20 70 72 69 6e | 74 65 72 73 0d 0a 76 61 |nto prin|ters..va|
|00002910| 6c 75 65 73 20 28 27 50 | 52 30 31 27 2c 20 27 4e |lues ('P|R01', 'N|
|00002920| 6f 72 74 68 77 65 73 74 | 20 50 72 69 6e 74 65 72 |orthwest| Printer|
|00002930| 73 27 2c 20 27 31 30 30 | 31 20 31 73 74 20 41 76 |s', '100|1 1st Av|
|00002940| 65 20 53 6f 75 74 68 27 | 2c 0d 0a 27 54 61 63 6f |e South'|,..'Taco|
|00002950| 6d 61 27 2c 20 27 57 41 | 27 2c 20 27 39 37 36 35 |ma', 'WA|', '9765|
|00002960| 34 2d 32 33 34 35 27 29 | 0d 0a ff 00 ff ff 00 8f |4-2345')|........|
|00002970| 73 65 6c 65 63 74 20 2a | 0d 0a 66 72 6f 6d 20 70 |select *|..from p|
|00002980| 72 69 6e 74 65 72 73 28 | 70 72 69 6e 74 5f 69 64 |rinters(|print_id|
|00002990| 20 63 68 61 72 28 34 29 | 2c 0d 0a 70 72 6e 74 5f | char(4)|,..prnt_|
|000029a0| 6e 61 6d 65 20 76 61 72 | 63 68 61 72 28 34 30 29 |name var|char(40)|
|000029b0| 2c 0d 0a 61 64 64 72 65 | 73 73 20 76 61 72 63 68 |,..addre|ss varch|
|000029c0| 61 72 28 34 30 29 2c 0d | 0a 63 69 74 79 20 76 61 |ar(40),.|.city va|
|000029d0| 72 63 68 61 72 28 32 30 | 29 2c 0d 0a 73 74 61 74 |rchar(20|),..stat|
|000029e0| 65 20 63 68 61 72 28 32 | 29 2c 0d 0a 7a 69 70 20 |e char(2|),..zip |
|000029f0| 7a 69 70 31 30 29 20 27 | 32 38 34 32 20 4e 57 20 |zip10) '|2842 NW |
|00002a00| 39 39 27 2c 0d 0a 27 53 | 65 61 74 74 6c 65 27 2c |99',..'S|eattle',|
|00002a10| 20 27 57 41 27 2c 20 27 | 39 38 ff 31 03 27 2c 20 | 'WA', '|98.1.', |
|00002a20| 30 29 0d 0a ff 00 ff ff | 00 4d 69 6e 73 65 72 74 |0)......|.Minsert|
|00002a30| 20 69 6e 74 6f 20 70 72 | 69 6e 74 65 72 73 0d 0a | into pr|inters..|
|00002a40| 76 61 6c 75 65 73 20 28 | 27 50 52 30 32 27 2c 20 |values (|'PR02', |
|00002a50| 27 50 72 69 6e 74 69 6e | 67 20 4d 61 73 74 65 72 |'Printin|g Master|
|00002a60| 27 2c 20 27 32 33 35 20 | 34 74 68 20 53 74 72 65 |', '235 |4th Stre|
|00002a70| 65 74 27 2c 0d 0a 27 43 | 68 69 63 61 67 6f 27 2c |et',..'C|hicago',|
|00002a80| 20 27 49 4c 27 2c 20 27 | 36 30 35 30 33 32 38 37 | 'IL', '|60503287|
|00002a90| 36 27 29 0d 0a ff 00 ff | ff 00 96 63 72 65 61 74 |6').....|...creat|
|00002aa0| 65 20 74 72 69 67 67 65 | 72 20 64 65 6c 61 75 74 |e trigge|r delaut|
|00002ab0| 68 6f 72 0d 0a 6f 6e 20 | 61 75 74 68 6f 72 73 0d |hor..on |authors.|
|00002ac0| 0a 66 6f 72 20 64 65 6c | 65 74 65 0d 0a 61 73 0d |.for del|ete..as.|
|00002ad0| 0a 69 66 20 28 73 65 6c | 65 63 74 20 63 6f 75 6e |.if (sel|ect coun|
|00002ae0| 74 28 2a 29 20 66 72 6f | 6d 20 64 65 6c 65 74 65 |t(*) fro|m delete|
|00002af0| 64 2c 20 74 69 74 6c 65 | 61 75 74 68 6f 72 0d 0a |d, title|author..|
|00002b00| 77 68 65 72 65 20 74 69 | 74 6c 65 61 75 74 68 6f |where ti|tleautho|
|00002b10| 72 2e 61 75 5f 69 64 20 | 3d 20 64 65 6c 65 74 65 |r.au_id |= delete|
|00002b20| 64 2e 61 75 5f 69 64 29 | 20 3e 20 30 0d 0a ff 20 |d.au_id)| > 0... |
|00002b30| 03 62 65 67 69 6e 20 0d | 0a ff 20 03 72 6f 6c 6c |.begin .|.. .roll|
|00002b40| 62 61 63 6b 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |back tra|nsaction|
|00002b50| 0d 0a ff 20 03 70 72 69 | 6e 74 20 27 59 6f 75 20 |... .pri|nt 'You |
|00002b60| 63 61 6e 27 27 74 20 64 | 65 6c 65 74 65 20 61 6e |can''t d|elete an|
|00002b70| 20 61 75 74 68 6f 72 20 | 77 69 74 68 20 61 20 74 | author |with a t|
|00002b80| 69 74 6c 65 2e 27 0d 0a | ff 20 03 65 6e 64 0d 0a |itle.'..|. .end..|
|00002b90| ff 00 ff ff 00 0c 64 65 | 6c 65 74 65 20 61 75 74 |......de|lete aut|
|00002ba0| 68 6f 72 73 0d 0a 77 68 | 65 72 65 20 61 75 5f 69 |hors..wh|ere au_i|
|00002bb0| 64 20 3d 20 27 34 30 39 | 2d 35 36 2d 37 30 30 38 |d = '409|-56-7008|
|00002bc0| 27 0d 0a 0d 0a 74 20 50 | 72 69 6e 74 65 72 73 27 |'....t P|rinters'|
|00002bd0| 2c 20 27 31 30 30 31 20 | 31 73 74 20 41 76 65 20 |, '1001 |1st Ave |
|00002be0| 53 6f 75 74 68 27 2c 0d | 0a 27 54 61 63 6f 6d 61 |South',.|.'Tacoma|
|00002bf0| 27 2c 20 27 57 41 27 2c | 20 27 39 37 36 35 34 2d |', 'WA',| '97654-|
|00002c00| 32 33 34 35 27 29 0d 0a | ff 00 ff ff 00 8f 41 43 |2345')..|......AC|
|00002c10| 54 31 37 42 20 20 51 52 | 59 20 ff 00 0a 01 00 55 |T17B  QR|Y .....U|
|00002c20| 18 2b 00 36 ff 00 03 41 | 43 54 31 38 41 20 20 51 |.+.6...A|CT18A  Q|
|00002c30| 52 59 20 ff 00 0a 01 00 | 55 18 2c 00 48 ff 00 03 |RY .....|U.,.H...|
|00002c40| 41 43 54 31 38 42 20 20 | 51 52 59 20 ff 00 0a 01 |ACT18B  |QRY ....|
|00002c50| 00 55 18 2d 00 1d ff 00 | 03 41 43 54 31 39 41 20 |.U.-....|.ACT19A |
|00002c60| 20 51 52 59 20 ff 00 0a | 01 00 55 18 2e 00 4a ff | QRY ...|..U...J.|
|00002c70| 00 03 41 43 54 31 39 42 | 20 20 51 52 59 20 ff 00 |..ACT19B|  QRY ..|
|00002c80| 0a 01 00 55 18 2f 00 32 | ff 00 ff ff 00 64 75 73 |...U./.2|.....dus|
|00002c90| 65 20 70 75 62 73 0d 0a | 67 6f 0d 0a 0d 0a 67 72 |e pubs..|go....gr|
|00002ca0| 61 6e 74 20 75 70 64 61 | 74 65 0d 0a 6f 6e 20 73 |ant upda|te..on s|
|00002cb0| 74 6f 72 65 73 0d 0a 74 | 6f 20 74 65 73 74 69 64 |tores..t|o testid|
|00002cc0| 0d 0a 0d 0a 27 2c 20 27 | 32 33 35 20 34 74 68 20 |....', '|235 4th |
|00002cd0| 53 74 72 65 65 74 27 2c | 0d 0a 27 43 68 69 63 61 |Street',|..'Chica|
|00002ce0| 67 6f 27 2c 20 27 49 4c | 27 2c 20 27 36 30 35 30 |go', 'IL|', '6050|
|00002cf0| 33 32 38 37 36 27 29 0d | 0a ff 00 ff ff 00 96 63 |32876').|.......c|
|00002d00| 72 65 61 74 65 20 76 69 | 65 77 20 63 61 61 75 74 |reate vi|ew caaut|
|00002d10| 68 76 69 65 77 0d 0a 61 | 73 0d 0a 73 65 6c 65 63 |hview..a|s..selec|
|00002d20| 74 20 2a 0d 0a 66 72 6f | 6d 20 61 75 74 68 6f 72 |t *..fro|m author|
|00002d30| 73 0d 0a 77 68 65 72 65 | 20 73 74 61 74 65 20 3d |s..where| state =|
|00002d40| 20 27 43 41 27 0d 0a 29 | 20 66 72 6f 6d 20 64 65 | 'CA'..)| from de|
|00002d50| 6c 65 74 65 64 2c 20 74 | 69 74 6c 65 61 75 74 68 |leted, t|itleauth|
|00002d60| 6f 72 0d 0a 77 68 65 72 | 65 20 74 69 74 6c 65 61 |or..wher|e titlea|
|00002d70| 75 74 68 6f 72 2e 61 75 | 5f 69 64 20 3d 20 64 65 |uthor.au|_id = de|
|00002d80| 6c 65 74 65 64 2e 61 75 | 5f 69 64 29 20 3e 20 30 |leted.au|_id) > 0|
|00002d90| 0d 0a ff 20 03 62 65 67 | 69 6e 20 0d 0a ff 20 03 |... .beg|in ... .|
|00002da0| 72 6f 6c 6c 62 61 63 6b | 20 74 72 61 6e 73 61 63 |rollback| transac|
|00002db0| 74 69 6f 6e 0d 0a ff 20 | 03 70 72 69 6e 74 20 27 |tion... |.print '|
|00002dc0| 59 6f 75 20 63 61 6e 27 | 27 74 20 64 65 6c 65 74 |You can'|'t delet|
|00002dd0| 65 20 61 6e 20 61 75 74 | 68 6f 72 20 77 69 74 68 |e an aut|hor with|
|00002de0| 20 61 20 74 69 74 6c 65 | 2e 27 0d 0a ff 20 03 65 | a title|.'... .e|
|00002df0| 6e 64 0d 0a ff 00 ff ff | 00 0c 73 65 6c 65 63 74 |nd......|..select|
|00002e00| 20 2a 0d 0a 66 72 6f 6d | 20 63 61 61 75 74 68 76 | *..from| caauthv|
|00002e10| 69 65 77 0d 0a 0d 0a 20 | 27 34 30 39 2d 35 36 2d |iew.... |'409-56-|
|00002e20| 37 30 30 38 27 0d 0a 0d | 0a 74 20 50 72 69 6e 74 |7008'...|.t Print|
|00002e30| 65 72 73 27 2c 20 27 31 | 30 30 31 20 31 73 74 20 |ers', '1|001 1st |
|00002e40| 41 76 65 20 53 6f 75 74 | 68 27 2c 0d 0a 27 54 61 |Ave Sout|h',..'Ta|
|00002e50| 63 6f 6d 61 27 2c 20 27 | 57 41 27 2c 20 27 39 37 |coma', '|WA', '97|
|00002e60| 36 35 34 2d 32 33 34 35 | 27 29 0d 0a ff 00 ff ff |654-2345|')......|
|00002e70| 00 8f 69 6e 73 65 72 74 | 20 69 6e 74 6f 20 64 69 |..insert| into di|
|00002e80| 73 63 6f 75 6e 74 73 0d | 0a 76 61 6c 75 65 73 20 |scounts.|.values |
|00002e90| 28 27 56 6f 6c 75 6d 65 | 20 44 69 73 63 6f 75 6e |('Volume| Discoun|
|00002ea0| 74 27 2c 20 27 36 33 38 | 30 27 2c 20 35 30 2c 20 |t', '638|0', 50, |
|00002eb0| 31 ff 30 03 2c 20 35 2e | 37 29 0d 0a 0d 0a 27 43 |1.0., 5.|7)....'C|
|00002ec0| 68 69 63 61 67 6f 27 2c | 20 27 49 4c 27 2c 20 27 |hicago',| 'IL', '|
|00002ed0| 36 30 35 30 33 32 38 37 | 36 27 29 0d 0a ff 00 ff |60503287|6').....|
|00002ee0| ff 00 96 73 65 6c 65 63 | 74 20 2a 0d 0a 66 72 6f |...selec|t *..fro|
|00002ef0| 6d 20 64 69 73 63 6f 75 | 6e 74 73 0d 0a 77 68 65 |m discou|nts..whe|
|00002f00| 72 65 20 73 74 6f 72 5f | 69 64 20 3d 20 27 36 33 |re stor_|id = '63|
|00002f10| 38 30 27 0d 0a 0d 0a 77 | 68 65 72 65 20 73 74 61 |80'....w|here sta|
|00002f20| 74 65 20 3d 20 27 43 41 | 27 0d 0a 29 20 66 72 6f |te = 'CA|'..) fro|
|00002f30| 6d 20 64 65 6c 65 74 65 | 64 2c 20 74 69 74 6c 65 |m delete|d, title|
|00002f40| 61 75 74 68 6f 72 0d 0a | 77 68 65 72 65 20 74 69 |author..|where ti|
|00002f50| 74 6c 65 61 75 74 68 6f | 72 2e 61 75 5f 69 64 20 |tleautho|r.au_id |
|00002f60| 3d 20 64 65 6c 65 74 65 | 64 2e 61 75 5f 69 64 29 |= delete|d.au_id)|
|00002f70| 20 3e 20 30 0d 0a ff 20 | 03 62 65 67 69 6e 20 0d | > 0... |.begin .|
|00002f80| 0a ff 20 03 72 6f 6c 6c | 62 61 63 6b 20 74 72 61 |.. .roll|back tra|
|00002f90| 6e 73 61 63 74 69 6f 6e | 0d 0a ff 20 03 70 72 69 |nsaction|... .pri|
|00002fa0| 6e 74 20 27 59 6f 75 20 | 63 61 6e 27 27 74 20 64 |nt 'You |can''t d|
|00002fb0| 65 6c 65 74 65 20 61 6e | 20 61 75 74 68 6f 72 20 |elete an| author |
|00002fc0| 77 69 74 68 20 61 20 74 | 69 74 6c 65 2e 27 0d 0a |with a t|itle.'..|
|00002fd0| ff 20 03 65 6e 64 0d 0a | ff 00 ff ff 00 0c ab 0a |. .end..|........|
|00002fe0| ff 2e ff 20 0a 10 ff 00 | 0a 6e 77 4c 1c 30 ff 00 |... ....|.nwL.0..|
|00002ff0| 05 2e 2e ff 20 09 10 ff | 00 0a 6e 77 4c 1c ff 00 |.... ...|..nwL...|
|00003000| 06 41 43 54 30 36 42 20 | 20 51 52 59 20 ff 00 0a |.ACT06B | QRY ...|
|00003010| 01 00 55 18 31 00 4c ff | 00 03 41 43 54 30 37 42 |..U.1.L.|..ACT07B|
|00003020| 20 20 51 52 59 20 ff 00 | 0a 01 00 55 18 32 00 e2 |  QRY ..|...U.2..|
|00003030| 01 00 00 41 43 54 30 38 | 42 20 20 51 52 59 20 ff |...ACT08|B  QRY .|
|00003040| 00 0a 01 00 55 18 33 00 | 14 01 00 00 41 43 54 31 |....U.3.|....ACT1|
|00003050| 37 41 20 20 51 52 59 20 | ff 00 0a 01 00 55 18 34 |7A  QRY |.....U.4|
|00003060| 00 51 ff 00 ff ff 00 44 | 73 65 6c 65 63 74 20 73 |.Q.....D|select s|
|00003070| 74 6f 72 5f 6e 61 6d 65 | 2c 20 73 74 6f 72 5f 61 |tor_name|, stor_a|
|00003080| 64 64 72 65 73 73 0d 0a | 66 72 6f 6d 20 73 74 6f |ddress..|from sto|
|00003090| 72 65 73 0d 0a 77 68 65 | 72 65 20 73 74 6f 72 5f |res..whe|re stor_|
|000030a0| 6e 61 6d 65 20 3d 20 27 | 42 61 72 6e 75 6d 27 27 |name = '|Barnum''|
|000030b0| 73 27 0d 0a ff 00 0a 01 | 00 55 18 1c 00 38 ff 00 |s'......|.U...8..|
|000030c0| 03 41 43 54 31 31 42 20 | 20 51 52 59 20 ff 00 0a |.ACT11B | QRY ...|
|000030d0| 01 00 55 18 1d 00 31 ff | 00 03 41 43 54 31 31 43 |..U...1.|..ACT11C|
|000030e0| 20 20 51 52 59 20 ff 00 | 0a 01 00 55 18 1e 00 b4 |  QRY ..|...U....|
|000030f0| ff 00 03 41 43 54 31 31 | 44 20 20 51 52 59 20 ff |...ACT11|D  QRY .|
|00003100| 00 0a 01 00 55 18 1f 00 | 33 ff 00 03 41 43 54 31 |....U...|3...ACT1|
|00003110| 32 ff 20 03 51 52 59 20 | ff 00 0a 01 00 55 18 20 |2. .QRY |.....U. |
|00003120| 00 48 ff 00 03 41 43 54 | 31 33 41 20 20 51 52 59 |.H...ACT|13A  QRY|
|00003130| 20 ff 00 0a 01 00 55 18 | 21 00 2c ff 00 03 41 43 | .....U.|!.,...AC|
|00003140| 54 31 33 42 20 20 51 52 | 59 20 ff 00 0a 01 00 55 |T13B  QR|Y .....U|
|00003150| 18 22 00 86 ff 00 03 41 | 43 54 31 33 43 20 20 51 |.".....A|CT13C  Q|
|00003160| 52 59 20 ff 00 0a 01 00 | 55 18 23 00 58 ff 00 03 |RY .....|U.#.X...|
|00003170| 41 43 54 31 33 44 20 20 | 51 52 59 20 ff 00 0a 01 |ACT13D  |QRY ....|
|00003180| 00 55 18 24 00 22 ff 00 | 03 41 43 54 31 33 45 20 |.U.$."..|.ACT13E |
|00003190| 20 51 52 59 20 ff 00 0a | 01 00 55 18 25 00 72 ff | QRY ...|..U.%.r.|
|000031a0| 00 03 41 43 54 31 33 46 | 20 20 51 52 59 20 ff 00 |..ACT13F|  QRY ..|
|000031b0| 0a 01 00 55 18 26 00 17 | ff 00 03 41 43 54 31 33 |...U.&..|...ACT13|
|000031c0| 47 20 20 51 52 59 20 ff | 00 0a 01 00 55 18 27 00 |G  QRY .|....U.'.|
|000031d0| 6b ff 00 03 41 43 54 31 | 34 41 20 20 51 52 59 20 |k...ACT1|4A  QRY |
|000031e0| ff 00 0a 01 00 55 18 28 | 00 f5 ff 00 03 41 43 54 |.....U.(|.....ACT|
|000031f0| 31 34 42 20 20 51 52 59 | 20 ff 00 0a 01 00 55 18 |14B  QRY| .....U.|
|00003200| 29 00 2f ff 00 03 2f 2a | 20 4e 4f 54 45 3a 20 20 |)./.../*| NOTE:  |
|00003210| 53 51 4c 20 41 64 6d 69 | 6e 69 73 74 72 61 74 6f |SQL Admi|nistrato|
|00003220| 72 20 77 69 6c 6c 20 6e | 6f 74 20 73 68 6f 77 20 |r will n|ot show |
|00003230| 74 68 65 20 72 65 73 75 | 6c 74 73 20 6f 66 20 74 |the resu|lts of t|
|00003240| 68 65 0d 0a 2a 20 53 45 | 4c 45 43 54 20 73 74 61 |he..* SE|LECT sta|
|00003250| 74 65 6d 65 6e 74 20 62 | 65 6c 6f 77 20 75 6e 74 |tement b|elow unt|
|00003260| 69 6c 20 74 68 65 20 55 | 50 44 41 54 45 20 74 72 |il the U|PDATE tr|
|00003270| 61 6e 73 61 63 74 69 6f | 6e 20 69 73 20 0d 0a 2a |ansactio|n is ..*|
|00003280| 20 66 69 6e 69 73 68 65 | 64 2e 20 20 54 6f 20 73 | finishe|d.  To s|
|00003290| 65 65 20 74 68 65 20 72 | 65 73 75 6c 74 73 20 6f |ee the r|esults o|
|000032a0| 66 20 74 68 65 20 53 45 | 4c 45 43 54 20 73 74 61 |f the SE|LECT sta|
|000032b0| 74 65 6d 65 6e 74 20 61 | 73 0d 0a 2a 20 73 6f 6f |tement a|s..* soo|
|000032c0| 6e 20 61 73 20 74 68 65 | 79 20 68 61 76 65 20 72 |n as the|y have r|
|000032d0| 65 74 75 72 6e 65 64 20 | 74 6f 20 74 68 65 20 63 |eturned |to the c|
|000032e0| 6c 69 65 6e 74 2c 20 75 | 73 65 20 74 68 65 20 53 |lient, u|se the S|
|000032f0| 79 73 74 65 6d 0d 0a 2a | 20 41 64 6d 69 6e 69 73 |ystem..*| Adminis|
|00003300| 74 72 61 74 69 6f 6e 20 | 46 61 63 69 6c 69 74 79 |tration |Facility|
|00003310| 20 28 53 41 46 29 20 66 | 6f 72 20 74 68 69 73 20 | (SAF) f|or this |
|00003320| 61 63 74 69 76 69 74 79 | 2e 20 2a 2f 0d 0a 0d 0a |activity|. */....|
|00003330| 73 65 6c 65 63 74 20 74 | 79 70 65 2c 20 74 69 74 |select t|ype, tit|
|00003340| 6c 65 20 0d 0a 66 72 6f | 6d 20 74 69 74 6c 65 73 |le ..fro|m titles|
|00003350| 0d 0a 77 68 65 72 65 20 | 74 79 70 65 20 3d 20 27 |..where |type = '|
|00003360| 6d 6f 64 5f 63 6f 6f 6b | 27 0d 0a 67 6f 0d 0a 0d |mod_cook|'..go...|
|00003370| 0a 62 65 67 69 6e 20 74 | 72 61 6e 73 61 63 74 69 |.begin t|ransacti|
|00003380| 6f 6e 0d 0a ff 20 04 75 | 70 64 61 74 65 20 74 69 |on... .u|pdate ti|
|00003390| 74 6c 65 73 0d 0a ff 20 | 04 73 65 74 20 74 79 70 |tles... |.set typ|
|000033a0| 65 20 3d 20 27 70 6f 70 | 5f 70 73 79 63 68 27 0d |e = 'pop|_psych'.|
|000033b0| 0a ff 20 04 77 68 65 72 | 65 20 74 79 70 65 20 3d |.. .wher|e type =|
|000033c0| 20 27 70 73 79 63 68 6f | 6c 6f 67 79 27 0d 0a 63 | 'psycho|logy'..c|
|000033d0| 6f 6d 6d 69 74 20 74 72 | 61 6e 73 61 63 74 69 6f |ommit tr|ansactio|
|000033e0| 6e 0d 0a 0d 0a ff 00 1e | 62 65 67 69 6e 20 74 72 |n.......|begin tr|
|000033f0| 61 6e 73 61 63 74 69 6f | 6e 0d 0a ff 20 04 75 70 |ansactio|n... .up|
|00003400| 64 61 74 65 20 73 74 6f | 72 65 73 0d 0a ff 20 04 |date sto|res... .|
|00003410| 73 65 74 20 73 74 6f 72 | 5f 61 64 64 72 65 73 73 |set stor|_address|
|00003420| 20 3d 20 27 32 32 31 20 | 43 68 61 70 6d 61 6e 20 | = '221 |Chapman |
|00003430| 42 6c 76 64 2c 20 53 75 | 69 74 65 20 41 27 0d 0a |Blvd, Su|ite A'..|
|00003440| ff 20 04 77 68 65 72 65 | 20 73 74 6f 72 5f 61 64 |. .where| stor_ad|
|00003450| 64 72 65 73 73 20 3d 20 | 27 32 32 31 20 43 68 61 |dress = |'221 Cha|
|00003460| 70 6d 61 6e 20 42 6c 76 | 64 27 0d 0a ff 20 04 77 |pman Blv|d'... .w|
|00003470| 61 69 74 66 6f 72 20 64 | 65 6c 61 79 20 27 30 30 |aitfor d|elay '00|
|00003480| 3a 30 30 3a 30 35 27 0d | 0a ff 20 04 75 70 64 61 |:00:05'.|.. .upda|
|00003490| 74 65 20 74 69 74 6c 65 | 73 0d 0a ff 20 04 73 65 |te title|s... .se|
|000034a0| 74 20 61 64 76 61 6e 63 | 65 20 3d 20 24 35 ff 30 |t advanc|e = $5.0|
|000034b0| 03 0d 0a ff 20 04 77 68 | 65 72 65 20 74 69 74 6c |.... .wh|ere titl|
|000034c0| 65 20 3d 20 27 53 65 63 | 72 65 74 73 20 6f 66 20 |e = 'Sec|rets of |
|000034d0| 53 69 6c 69 63 6f 6e 20 | 56 61 6c 6c 65 79 27 0d |Silicon |Valley'.|
|000034e0| 0a 63 6f 6d 6d 69 74 20 | 74 72 61 6e 73 61 63 74 |.commit |transact|
|000034f0| 69 6f 6e 0d 0a ff 00 ec | 75 70 64 61 74 65 20 73 |ion.....|update s|
|00003500| 74 6f 72 65 73 0d 0a 73 | 65 74 20 73 74 6f 72 5f |tores..s|et stor_|
|00003510| 61 64 64 72 65 73 73 20 | 3d 20 27 35 35 38 20 50 |address |= '558 P|
|00003520| 61 73 61 64 65 6e 61 20 | 41 76 65 2e 27 0d 0a 77 |asadena |Ave.'..w|
|00003530| 68 65 72 65 20 73 74 6f | 72 5f 69 64 20 3d 20 27 |here sto|r_id = '|
|00003540| 37 30 36 36 27 0d 0a 0d | 0a ff 00 05 80 32 3e 1b |7066'...|.....2>.|
|00003550| 16 00 5b d5 00 00 44 42 | 4c 53 50 41 43 45 42 49 |..[...DB|LSPACEBI|
|00003560| 4e 07 ff 00 0a 80 32 3e | 1b 24 00 f6 fa 00 00 4d |N.....2>|.$.....M|
|00003570| 4f 53 2d 44 4f 53 2d 36 | 30 20 28 ff 00 0a 8d ad |OS-DOS-6|0 (.....|
|00003580| 21 ff 00 07 44 4f 53 ff | 20 08 10 ff 00 0a b7 ad |!...DOS.| .......|
|00003590| 21 00 02 ff 00 05 57 49 | 4e 41 32 30 20 20 33 38 |!.....WI|NA20  38|
|000035a0| 36 20 ff 00 0a 80 32 3e | 1b 70 01 85 24 00 00 43 |6 ....2>|.p..$..C|
|000035b0| 43 44 4f 53 ff 20 06 10 | ff 00 0a 77 0b 47 1c d6 |CDOS. ..|...w.G..|
|000035c0| 05 ff 00 04 43 58 44 4f | 53 ff 20 06 10 ff 00 0a |....CXDO|S. .....|
|000035d0| 7d 0b 2b 1c 36 06 ff 00 | 04 54 41 50 45 ff 20 07 |}.+.6...|.TAPE. .|
|000035e0| 10 ff 00 0a 01 af 21 00 | d8 05 ff 00 04 5a 52 4d |......!.|.....ZRM|
|000035f0| ff 20 08 10 ff 00 0a 8c | 0b 2b 1c de 05 ff 00 04 |. ......|.+......|
|00003600| 42 31 31 38 4d 4c ff 20 | 05 10 ff 00 0a ce 0b 42 |B118ML. |.......B|
|00003610| 1c 1c 6b ff 00 04 57 49 | 4e 44 4f 57 53 ff 20 04 |..k...WI|NDOWS. .|
|00003620| 10 ff 00 0a 2d b1 22 00 | 17 01 ff 00 04 4d 49 53 |....-.".|.....MIS|
|00003630| 43 54 45 58 54 ff 20 03 | 10 ff 00 0a 6b 06 2c 1c |CTEXT. .|....k.,.|
|00003640| eb 05 ff 00 04 42 41 44 | 43 52 43 20 20 45 58 45 |.....BAD|CRC  EXE|
|00003650| 20 ff 00 0a 94 85 94 19 | bb 07 3f 03 00 00 49 4e | .......|..?...IN|
|00003660| 53 54 41 4c 4c 20 42 41 | 54 ff 00 0b fb 13 37 1b |STALL BA|T.....7.|
|00003670| a2 06 3e 0f 00 00 2f 2a | 20 50 6c 65 61 73 65 20 |..>.../*| Please |
|00003680| 6e 6f 74 65 20 74 68 65 | 20 66 6f 6c 6c 6f 77 69 |note the| followi|
|00003690| 6e 67 20 63 6f 72 72 65 | 63 74 69 6f 6e 73 20 61 |ng corre|ctions a|
|000036a0| 6e 64 20 61 64 64 69 74 | 69 6f 6e 73 0d 0a 74 6f |nd addit|ions..to|
|000036b0| 20 74 68 65 20 4d 69 63 | 72 6f 73 6f 66 74 20 53 | the Mic|rosoft S|
|000036c0| 51 4c 20 53 65 72 76 65 | 72 20 45 76 61 6c 75 61 |QL Serve|r Evalua|
|000036d0| 74 69 6f 6e 20 47 75 69 | 64 65 3a 0d 0a 0d 0a 70 |tion Gui|de:....p|
|000036e0| 2e 20 31 31 2c 20 74 6f | 70 3a 20 20 41 66 74 65 |. 11, to|p:  Afte|
|000036f0| 72 20 6f 70 65 6e 69 6e | 67 20 61 20 71 75 65 72 |r openin|g a quer|
|00003700| 79 20 66 69 6c 65 20 74 | 68 61 74 20 69 73 20 6c |y file t|hat is l|
|00003710| 61 72 67 65 72 0d 0a 74 | 68 61 6e 20 77 69 6c 6c |arger..t|han will|
|00003720| 20 66 69 74 20 69 6e 20 | 74 68 65 20 51 75 65 72 | fit in |the Quer|
|00003730| 79 20 77 69 6e 64 6f 77 | 2c 20 79 6f 75 20 63 61 |y window|, you ca|
|00003740| 6e 20 75 73 65 0d 0a 43 | 74 72 6c 2d 48 4f 4d 45 |n use..C|trl-HOME|
|00003750| 20 74 6f 20 70 6f 73 69 | 74 69 6f 6e 20 74 68 65 | to posi|tion the|
|00003760| 20 77 69 6e 64 6f 77 20 | 61 74 20 74 68 65 20 74 | window |at the t|
|00003770| 6f 70 20 6f 66 20 74 68 | 65 20 66 69 6c 65 2e 0d |op of th|e file..|
|00003780| 0a 0d 0a 70 2e 20 34 39 | 2c 20 41 63 74 69 76 69 |...p. 49|, Activi|
|00003790| 74 79 20 37 2c 20 53 74 | 65 70 20 32 3a 20 20 54 |ty 7, St|ep 2:  T|
|000037a0| 6f 20 73 65 65 20 74 68 | 65 20 72 65 75 6c 74 73 |o see th|e reults|
|000037b0| 20 6f 66 20 74 68 69 73 | 20 61 63 74 69 76 69 74 | of this| activit|
|000037c0| 79 0d 0a 61 73 20 64 65 | 73 63 72 69 62 65 64 20 |y..as de|scribed |
|000037d0| 69 6e 20 74 68 65 20 22 | 44 69 73 63 75 73 73 69 |in the "|Discussi|
|000037e0| 6f 6e 22 20 73 65 63 74 | 69 6f 6e 2c 20 70 6c 65 |on" sect|ion, ple|
|000037f0| 61 73 65 20 72 75 6e 0d | 0a 74 68 69 73 20 71 75 |ase run.|.this qu|
|00003800| 65 72 79 20 28 41 43 54 | 30 37 42 2e 51 52 59 29 |ery (ACT|07B.QRY)|
|00003810| 20 75 6e 64 65 72 20 74 | 68 65 20 53 79 73 74 65 | under t|he Syste|
|00003820| 6d 20 41 64 6d 69 6e 69 | 73 74 72 61 74 69 6f 6e |m Admini|stration|
|00003830| 20 0d 0a 46 61 63 69 6c | 69 74 79 20 28 53 41 46 | ..Facil|ity (SAF|
|00003840| 29 2e 0d 0a 0d 0a 70 2e | 20 36 32 2c 20 74 6f 70 |).....p.| 62, top|
|00003850| 3a 20 20 54 68 65 20 73 | 79 6e 74 61 78 20 66 6f |:  The s|yntax fo|
|00003860| 72 20 74 68 65 20 63 72 | 65 61 74 65 20 72 75 6c |r the cr|eate rul|
|00003870| 65 20 73 74 65 70 20 6c | 69 73 74 73 20 74 68 65 |e step l|ists the|
|00003880| 0d 0a 72 75 6c 65 20 6e | 61 6d 65 20 69 6e 63 6f |..rule n|ame inco|
|00003890| 72 72 65 63 74 6c 79 20 | 61 73 20 22 70 75 62 69 |rrectly |as "pubi|
|000038a0| 64 72 75 6c 65 2e 22 20 | 20 54 68 65 20 63 6f 72 |drule." | The cor|
|000038b0| 72 65 63 74 20 6e 61 6d | 65 0d 0a 69 73 20 22 70 |rect nam|e..is "p|
|000038c0| 75 62 5f 69 64 72 75 6c | 65 2e 22 0d 0a 0d 0a 70 |ub_idrul|e."....p|
|000038d0| 2e 20 38 32 2c 20 41 63 | 74 69 76 69 74 79 20 32 |. 82, Ac|tivity 2|
|000038e0| 30 2c 20 53 74 65 70 20 | 31 3a 20 20 54 68 65 20 |0, Step |1:  The |
|000038f0| 63 3a 5c 73 71 6c 5c 69 | 6e 73 74 61 6c 6c 20 64 |c:\sql\i|nstall d|
|00003900| 69 72 65 63 74 6f 72 79 | 20 0d 0a 63 6f 6e 74 61 |irectory| ..conta|
|00003910| 69 6e 73 20 74 68 65 20 | 69 6e 73 74 61 6c 6c 61 |ins the |installa|
|00003920| 74 69 6f 6e 20 73 63 72 | 69 70 74 20 74 6f 20 72 |tion scr|ipt to r|
|00003930| 65 63 72 65 61 74 65 20 | 74 68 65 20 50 55 42 53 |ecreate |the PUBS|
|00003940| 0d 0a 64 61 74 61 62 61 | 73 65 2e 20 20 49 74 20 |..databa|se.  It |
|00003950| 64 6f 65 73 20 6e 6f 74 | 20 63 6f 6e 74 61 69 6e |does not| contain|
|00003960| 20 74 68 65 20 69 73 71 | 6c 20 75 74 69 6c 69 74 | the isq|l utilit|
|00003970| 79 2e 0d 0a 0d 0a 2a 2f | 0d 0a 63 69 6c 69 74 79 |y.....*/|..cility|
|00003980| 20 28 53 41 46 29 20 66 | 6f 72 20 74 68 69 73 20 | (SAF) f|or this |
|00003990| 61 63 74 69 76 69 74 79 | 2e 20 2a 2f 0d 0a 0d 0a |activity|. */....|
|000039a0| 73 65 6c 65 63 74 20 74 | 79 70 65 2c 20 74 69 74 |select t|ype, tit|
|000039b0| 6c 65 20 0d 0a 66 72 6f | 6d 20 74 69 74 6c 65 73 |le ..fro|m titles|
|000039c0| 0d 0a 77 68 65 72 65 20 | 74 79 70 65 20 3d 20 27 |..where |type = '|
|000039d0| 6d 6f 64 5f 63 6f 6f 6b | 27 0d 0a 67 6f 0d 0a 0d |mod_cook|'..go...|
|000039e0| 0a 62 65 67 69 6e 20 74 | 72 61 6e 73 61 63 74 69 |.begin t|ransacti|
|000039f0| 6f 6e 0d 0a ff 20 04 75 | 70 64 61 74 65 20 74 69 |on... .u|pdate ti|
|00003a00| 74 6c 65 73 0d 0a ff 20 | 04 73 65 74 20 74 79 70 |tles... |.set typ|
|00003a10| 65 20 3d 20 27 70 6f 70 | 5f 70 73 79 63 68 27 0d |e = 'pop|_psych'.|
|00003a20| 0a ff 20 04 77 68 65 72 | 65 20 74 79 70 65 20 3d |.. .wher|e type =|
|00003a30| 20 27 70 73 79 63 68 6f | 6c 6f 67 79 27 0d 0a 63 | 'psycho|logy'..c|
|00003a40| 6f 6d 6d 69 74 20 74 72 | 61 6e 73 61 63 74 69 6f |ommit tr|ansactio|
|00003a50| 6e 0d 0a 0d 0a ff 00 1e | ff f6 ff ff f6 ff ff f6 |n.......|........|
|00003a60| ff ff f6 ff ff f6 ff ff | f6 ff ff f6 ff ff f6 ff |........|........|
|00003a70| ff f6 ff ff f6 ff ff f6 | ff ff f6 ff ff f6 ff ff |........|........|
|00003a80| f6 ff ff f6 ff ff f6 ff | ff f6 10                |........|...     |
+--------+-------------------------+-------------------------+--------+--------+