/ OpenStep 4.0 (User) / OS_user_4.0.iso / usr / informix / msg / dbupd.iem

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| fe 68 00 30 ac bc 00 31 | 00 00 03 bd ac bd 00 19 |.h.0...1|........|
|00000010| 00 00 03 a3 ac be 00 1b | 00 00 03 87 ac bf 00 18 |........|........|
|00000020| 00 00 03 6e ac c0 00 18 | 00 00 03 55 ac c1 00 1e |...n....|...U....|
|00000030| 00 00 03 36 ac c2 00 0f | 00 00 03 26 ac c3 00 2f |...6....|...&.../|
|00000040| 00 00 02 f6 ac c4 00 1a | 00 00 02 db ac c5 00 24 |........|.......$|
|00000050| 00 00 02 b6 ac c6 00 2b | 00 00 02 8a ac c7 00 2c |.......+|.......,|
|00000060| 00 00 02 5d ac c8 00 2c | 00 00 02 30 ac c9 00 2c |...]...,|...0...,|
|00000070| 00 00 02 03 ac ca 00 2a | 00 00 01 d8 ac cb 00 29 |.......*|.......)|
|00000080| 00 00 01 ae ac cc 00 29 | 00 00 01 84 53 34 00 27 |.......)|....S4.'|
|00000090| 00 00 03 ef 53 35 00 24 | 00 00 04 17 53 36 00 16 |....S5.$|....S6..|
|000000a0| 00 00 04 3c 53 37 00 1e | 00 00 04 53 53 38 00 29 |...<S7..|...SS8.)|
|000000b0| 00 00 04 72 53 39 00 1f | 00 00 04 9c 53 3a 00 2b |...rS9..|....S:.+|
|000000c0| 00 00 04 bc 53 3b 00 0e | 00 00 04 e8 53 3c 00 0e |....S;..|....S<..|
|000000d0| 00 00 04 f7 53 3d 00 39 | 00 00 05 06 53 3e 00 2a |....S=.9|....S>.*|
|000000e0| 00 00 05 40 53 3f 00 2a | 00 00 05 6b 53 40 00 35 |...@S?.*|...kS@.5|
|000000f0| 00 00 05 96 53 41 00 38 | 00 00 05 cc 53 42 00 2f |....SA.8|....SB./|
|00000100| 00 00 06 05 53 43 00 38 | 00 00 06 35 53 44 00 36 |....SC.8|...5SD.6|
|00000110| 00 00 06 6e 53 45 00 30 | 00 00 06 a5 53 46 00 0c |...nSE.0|....SF..|
|00000120| 00 00 06 d6 53 47 00 19 | 00 00 06 e3 53 48 00 20 |....SG..|....SH. |
|00000130| 00 00 06 fd 53 49 00 36 | 00 00 07 1e 53 4a 00 38 |....SI.6|....SJ.8|
|00000140| 00 00 07 55 53 4b 00 37 | 00 00 07 8e 53 4c 00 44 |...USK.7|....SL.D|
|00000150| 00 00 07 c6 53 4d 00 19 | 00 00 08 0b 53 4e 00 40 |....SM..|....SN.@|
|00000160| 00 00 08 25 53 4f 00 18 | 00 00 08 66 53 50 00 28 |...%SO..|...fSP.(|
|00000170| 00 00 08 7f 53 51 00 1b | 00 00 08 a8 53 52 00 05 |....SQ..|....SR..|
|00000180| 00 00 08 c4 54 68 65 20 | 64 61 74 61 62 61 73 65 |....The |database|
|00000190| 20 64 69 72 65 63 74 6f | 72 79 20 25 73 20 64 6f | directo|ry %s do|
|000001a0| 65 73 20 6e 6f 74 20 65 | 78 69 73 74 0a 00 44 61 |es not e|xist..Da|
|000001b0| 74 61 62 61 73 65 20 25 | 73 20 69 73 20 61 6c 72 |tabase %|s is alr|
|000001c0| 65 61 64 79 20 69 6e 20 | 53 51 4c 20 32 2e 30 20 |eady in |SQL 2.0 |
|000001d0| 66 6f 72 6d 61 74 0a 00 | 49 53 4f 50 45 4e 20 72 |format..|ISOPEN r|
|000001e0| 65 74 75 72 6e 73 20 69 | 73 65 72 72 6e 6f 20 25 |eturns i|serrno %|
|000001f0| 64 20 66 6f 72 20 66 69 | 6c 65 6e 61 6d 65 20 25 |d for fi|lename %|
|00000200| 73 0a 00 49 53 43 4c 4f | 53 45 20 72 65 74 75 72 |s..ISCLO|SE retur|
|00000210| 6e 73 20 69 73 65 72 72 | 6e 6f 20 25 64 20 66 6f |ns iserr|no %d fo|
|00000220| 72 20 66 69 6c 65 20 64 | 65 73 63 20 25 64 0a 00 |r file d|esc %d..|
|00000230| 49 53 53 54 41 52 54 20 | 72 65 74 75 72 6e 73 20 |ISSTART |returns |
|00000240| 69 73 65 72 72 6e 6f 20 | 25 64 20 66 6f 72 20 66 |iserrno |%d for f|
|00000250| 69 6c 65 20 64 65 73 63 | 20 25 64 0a 00 49 53 57 |ile desc| %d..ISW|
|00000260| 52 49 54 45 20 72 65 74 | 75 72 6e 73 20 69 73 65 |RITE ret|urns ise|
|00000270| 72 72 6e 6f 20 25 64 20 | 66 6f 72 20 66 69 6c 65 |rrno %d |for file|
|00000280| 20 64 65 73 63 20 25 64 | 0a 00 49 53 52 45 41 44 | desc %d|..ISREAD|
|00000290| 20 72 65 74 75 72 6e 73 | 20 69 73 65 72 72 6e 6f | returns| iserrno|
|000002a0| 20 25 64 20 66 6f 72 20 | 66 69 6c 65 20 64 65 73 | %d for |file des|
|000002b0| 63 20 25 64 0a 00 4c 69 | 6e 6b 69 6e 67 20 6f 66 |c %d..Li|nking of|
|000002c0| 20 66 69 6c 65 20 25 73 | 20 74 6f 20 66 69 6c 65 | file %s| to file|
|000002d0| 20 25 73 20 66 61 69 6c | 73 0a 00 49 53 45 52 52 | %s fail|s..ISERR|
|000002e0| 4e 4f 20 2d 3e 20 25 64 | 20 45 52 52 4e 4f 20 2d |NO -> %d| ERRNO -|
|000002f0| 3e 20 25 64 0a 00 45 72 | 72 6f 72 20 6f 63 63 75 |> %d..Er|ror occu|
|00000300| 72 73 20 64 75 72 69 6e | 67 20 63 6f 6e 76 65 72 |rs durin|g conver|
|00000310| 73 69 6f 6e 20 6f 66 20 | 61 6e 20 69 73 61 6d 20 |sion of |an isam |
|00000320| 66 69 6c 65 0a 00 50 72 | 6f 67 72 61 6d 20 41 62 |file..Pr|ogram Ab|
|00000330| 6f 72 74 2e 0a 00 49 53 | 49 4e 44 45 58 49 4e 46 |ort...IS|INDEXINF|
|00000340| 4f 20 6f 6e 20 25 73 20 | 72 65 74 75 72 6e 73 20 |O on %s |returns |
|00000350| 25 64 0a 0a 00 4d 45 4d | 4f 52 59 20 41 4c 4c 4f |%d...MEM|ORY ALLO|
|00000360| 43 41 54 49 4f 4e 20 45 | 52 52 4f 52 0a 00 49 53 |CATION E|RROR..IS|
|00000370| 52 45 41 44 20 6f 6e 20 | 25 73 20 72 65 74 75 72 |READ on |%s retur|
|00000380| 6e 73 20 25 64 0a 00 49 | 53 52 45 57 43 55 52 52 |ns %d..I|SREWCURR|
|00000390| 20 6f 6e 20 25 73 20 72 | 65 74 75 72 6e 73 20 25 | on %s r|eturns %|
|000003a0| 64 0a 00 49 53 43 4c 4f | 53 45 20 6f 6e 20 25 73 |d..ISCLO|SE on %s|
|000003b0| 20 72 65 74 75 72 6e 73 | 20 25 64 0a 00 43 6f 75 | returns| %d..Cou|
|000003c0| 6c 64 20 6e 6f 74 20 72 | 75 6e 20 65 78 65 63 20 |ld not r|un exec |
|000003d0| 64 65 63 63 6f 6e 20 74 | 6f 20 75 70 64 61 74 65 |deccon t|o update|
|000003e0| 20 64 65 63 69 6d 61 6c | 20 64 61 74 61 0a 00 44 | decimal| data..D|
|000003f0| 42 55 50 44 41 54 45 20 | 53 51 4c 31 2e 31 30 20 |BUPDATE |SQL1.10 |
|00000400| 74 6f 20 53 51 4c 32 2e | 30 30 20 54 72 61 6e 73 |to SQL2.|00 Trans|
|00000410| 6c 61 74 6f 72 0a 00 53 | 74 61 72 74 69 6e 67 20 |lator..S|tarting |
|00000420| 74 69 6d 65 20 6f 66 20 | 63 6f 6e 76 65 72 73 69 |time of |conversi|
|00000430| 6f 6e 20 69 73 3a 20 20 | 25 73 0a 00 43 52 45 41 |on is:  |%s..CREA|
|00000440| 54 49 4e 47 20 4e 45 57 | 20 44 41 54 41 42 41 53 |TING NEW| DATABAS|
|00000450| 45 0a 00 55 50 44 41 54 | 49 4e 47 20 53 59 53 54 |E..UPDAT|ING SYST|
|00000460| 45 4d 20 43 41 54 41 4c | 4f 47 53 20 44 41 54 41 |EM CATAL|OGS DATA|
|00000470| 0a 00 55 50 44 41 54 49 | 4e 47 20 43 4f 4c 4c 45 |..UPDATI|NG COLLE|
|00000480| 4e 47 54 48 20 46 4f 52 | 20 44 45 43 49 4d 41 4c |NGTH FOR| DECIMAL|
|00000490| 20 41 4e 44 20 4d 4f 4e | 45 59 0a 00 55 50 44 41 | AND MON|EY..UPDA|
|000004a0| 54 49 4e 47 20 4e 45 47 | 41 54 49 56 45 20 44 45 |TING NEG|ATIVE DE|
|000004b0| 43 49 4d 41 4c 20 44 41 | 54 41 0a 00 45 4e 44 2c |CIMAL DA|TA..END,|
|000004c0| 20 6e 65 67 61 74 69 76 | 65 20 64 65 63 69 6d 61 | negativ|e decima|
|000004d0| 6c 20 64 61 74 61 20 61 | 72 65 20 6e 6f 77 20 75 |l data a|re now u|
|000004e0| 70 64 61 74 65 64 0a 00 | 50 72 6f 67 72 61 6d 20 |pdated..|Program |
|000004f0| 6f 76 65 72 2e 0a 00 53 | 51 4c 43 4f 44 45 20 2d |over...S|QLCODE -|
|00000500| 3e 20 25 64 0a 00 46 6f | 72 6b 69 6e 67 20 22 64 |> %d..Fo|rking "d|
|00000510| 65 63 63 6f 6e 22 20 70 | 72 6f 67 72 61 6d 20 74 |eccon" p|rogram t|
|00000520| 6f 20 75 70 64 61 74 65 | 20 6e 65 67 61 74 69 76 |o update| negativ|
|00000530| 65 20 64 65 63 69 6d 61 | 6c 20 64 61 74 61 0a 00 |e decima|l data..|
|00000540| 53 54 41 52 54 2c 20 63 | 6f 6d 70 6c 65 74 69 6f |START, c|ompletio|
|00000550| 6e 20 6d 65 73 73 61 67 | 65 20 77 69 6c 6c 20 66 |n messag|e will f|
|00000560| 6f 6c 6c 6f 77 20 2e 2e | 2e 0a 00 55 73 61 67 65 |ollow ..|...Usage|
|00000570| 3a 20 64 62 75 70 64 61 | 74 65 20 5b 2d 62 6e 5d |: dbupda|te [-bn]|
|00000580| 20 6f 6c 64 64 62 6e 61 | 6d 65 20 6e 65 77 64 62 | olddbna|me newdb|
|00000590| 6e 61 6d 65 0a 00 09 5b | 6e 6f 20 6f 70 74 69 6f |name...[|no optio|
|000005a0| 6e 5d 20 2d 09 63 6f 6e | 76 65 72 74 20 62 6c 61 |n] -.con|vert bla|
|000005b0| 6e 6b 20 63 68 61 72 61 | 63 74 65 72 20 64 61 74 |nk chara|cter dat|
|000005c0| 61 20 74 6f 20 6e 75 6c | 6c 2c 0a 00 09 20 20 20 |a to nul|l,...   |
|000005d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 70 72 6f |        |     pro|
|000005e0| 6d 70 74 20 75 73 65 72 | 20 6f 6e 20 6e 75 6d 65 |mpt user| on nume|
|000005f0| 72 69 63 20 63 6f 6c 75 | 6d 6e 73 20 77 68 65 74 |ric colu|mns whet|
|00000600| 68 65 72 0a 00 09 20 20 | 20 20 20 20 20 20 20 20 |her...  |        |
|00000610| 20 20 20 20 20 20 74 6f | 20 63 6f 6e 76 65 72 74 |      to| convert|
|00000620| 20 7a 65 72 6f 20 64 61 | 74 61 20 74 6f 20 6e 75 | zero da|ta to nu|
|00000630| 6c 6c 2e 0a 00 09 20 20 | 20 20 2d 62 20 20 20 20 |ll....  |  -b    |
|00000640| 20 20 2d 20 20 20 64 6f | 20 6e 6f 74 20 63 6f 6e |  -   do| not con|
|00000650| 76 65 72 74 20 62 6c 61 | 6e 6b 20 63 68 61 72 61 |vert bla|nk chara|
|00000660| 63 74 65 72 20 64 61 74 | 61 20 74 6f 0a 00 09 20 |cter dat|a to... |
|00000670| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 6e |        |       n|
|00000680| 75 6c 6c 2c 20 70 72 6f | 6d 70 74 20 75 73 65 72 |ull, pro|mpt user|
|00000690| 20 6f 6e 20 6e 75 6d 65 | 72 69 63 20 63 6f 6c 75 | on nume|ric colu|
|000006a0| 6d 6e 73 0a 00 09 20 20 | 20 20 2d 6e 20 20 20 20 |mns...  |  -n    |
|000006b0| 20 20 2d 20 20 20 64 65 | 66 69 6e 65 20 61 6c 6c |  -   de|fine all|
|000006c0| 20 63 6f 6c 75 6d 6e 73 | 20 61 73 20 4e 4f 54 20 | columns| as NOT |
|000006d0| 4e 55 4c 4c 0a 00 49 53 | 41 4d 20 46 49 4c 45 3a |NULL..IS|AM FILE:|
|000006e0| 20 0a 00 4f 46 46 53 45 | 54 20 4f 46 20 44 45 43 | ..OFFSE|T OF DEC|
|000006f0| 49 4d 41 4c 20 44 41 54 | 41 3a 20 0a 00 55 73 61 |IMAL DAT|A: ..Usa|
|00000700| 67 65 20 3a 20 64 65 63 | 63 6f 6e 20 5b 20 2d 69 |ge : dec|con [ -i|
|00000710| 20 7c 20 64 62 6e 61 6d | 65 20 5d 20 0a 00 09 64 | | dbnam|e ] ...d|
|00000720| 65 63 63 6f 6e 20 2d 69 | 20 20 20 2d 20 20 20 20 |eccon -i|   -    |
|00000730| 72 75 6e 73 20 69 6e 74 | 65 72 61 63 74 69 76 65 |runs int|eractive|
|00000740| 6c 79 20 77 69 74 68 20 | 75 73 65 72 20 67 69 76 |ly with |user giv|
|00000750| 69 6e 67 0a 00 09 20 20 | 20 20 20 20 20 20 20 20 |ing...  |        |
|00000760| 20 20 20 20 20 20 20 74 | 68 65 20 6e 65 63 65 73 |       t|he neces|
|00000770| 73 61 72 79 20 6f 66 66 | 73 65 74 73 20 69 6e 74 |sary off|sets int|
|00000780| 6f 20 69 73 61 6d 20 66 | 69 6c 65 73 0a 00 09 64 |o isam f|iles...d|
|00000790| 65 63 63 6f 6e 20 64 62 | 6e 61 6d 65 20 2d 20 20 |eccon db|name -  |
|000007a0| 73 65 61 72 63 68 65 73 | 20 74 68 72 6f 75 67 68 |searches| through|
|000007b0| 20 73 79 73 74 65 6d 20 | 63 61 74 61 6c 6f 67 73 | system |catalogs|
|000007c0| 20 61 6e 64 0a 00 20 20 | 20 20 20 20 20 20 20 20 | and..  |        |
|000007d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 66 |        |       f|
|000007e0| 69 6e 64 20 74 68 65 20 | 6e 65 63 65 73 73 61 72 |ind the |necessar|
|000007f0| 79 20 6f 66 66 73 65 74 | 73 20 69 6e 74 6f 20 69 |y offset|s into i|
|00000800| 73 61 6d 20 66 69 6c 65 | 73 0a 00 4f 46 46 53 45 |sam file|s..OFFSE|
|00000810| 54 20 6e 75 6d 62 65 72 | 20 25 64 20 20 2d 3e 20 |T number| %d  -> |
|00000820| 25 6c 64 0a 00 44 6f 20 | 79 6f 75 20 77 61 6e 74 |%ld..Do |you want|
|00000830| 20 61 6c 6c 20 7a 65 72 | 6f 65 73 20 69 6e 20 74 | all zer|oes in t|
|00000840| 68 69 73 20 66 69 65 6c | 64 20 63 6f 6e 76 65 72 |his fiel|d conver|
|00000850| 74 65 64 20 74 6f 20 6e | 75 6c 6c 73 3f 20 28 79 |ted to n|ulls? (y|
|00000860| 2f 6e 29 20 0a 00 46 6f | 72 20 63 6f 6c 75 6d 6e |/n) ..Fo|r column|
|00000870| 20 25 73 2c 20 74 61 62 | 6c 65 20 25 73 0a 00 50 | %s, tab|le %s..P|
|00000880| 6c 65 61 73 65 20 65 6e | 74 65 72 20 74 68 65 20 |lease en|ter the |
|00000890| 64 61 74 65 20 79 6f 75 | 20 77 69 73 68 20 74 68 |date you| wish th|
|000008a0| 65 20 6e 75 6c 6c 0a 00 | 64 61 74 65 73 20 74 6f |e null..|dates to|
|000008b0| 20 62 65 20 63 6f 6e 76 | 65 72 74 65 64 20 74 6f | be conv|erted to|
|000008c0| 3a 20 0a 00 59 79 4e 6e | 0a 00                   |: ..YyNn|..      |
+--------+-------------------------+-------------------------+--------+--------+