home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1995-03-03 | 41.9 MB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 2e 2f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |./......|........|
|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 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 20 20 31 37 37 37 20 | 00 20 20 20 20 20 30 20 |. 1777 |. 0 |
|000000f0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 20 |. 0 |. |
|00000100| 20 20 20 30 20 20 35 37 | 32 35 35 37 36 35 33 37 | 0 57|25576537|
|00000110| 20 20 20 34 31 32 37 00 | 20 00 00 00 00 00 00 00 | 4127.| .......|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 2e 2f 75 73 72 2f 00 00 | 00 00 00 00 00 00 00 00 |./usr/..|........|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 20 20 20 37 35 35 20 | 00 20 20 20 20 20 30 20 |. 755 |. 0 |
|000002f0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 20 |. 0 |. |
|00000300| 20 20 20 30 20 20 35 37 | 32 35 35 37 36 36 31 32 | 0 57|25576612|
|00000310| 20 20 20 34 37 30 35 00 | 20 00 00 00 00 00 00 00 | 4705.| .......|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 2e 2f 75 73 72 2f 73 79 | 62 61 73 65 2f 00 00 00 |./usr/sy|base/...|
|00000410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 20 20 20 37 35 35 20 | 00 20 20 20 20 31 30 20 |. 755 |. 10 |
|000004f0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 20 |. 0 |. |
|00000500| 20 20 20 30 20 20 35 37 | 31 35 34 33 37 36 35 34 | 0 57|15437654|
|00000510| 20 20 20 36 32 31 35 00 | 20 00 00 00 00 00 00 00 | 6215.| .......|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 2e 2f 75 73 72 2f 73 79 | 62 61 73 65 2f 64 6f 63 |./usr/sy|base/doc|
|00000610| 2f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |/.......|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 20 20 20 37 35 35 20 | 00 20 20 20 20 31 30 20 |. 755 |. 10 |
|000006f0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 20 |. 0 |. |
|00000700| 20 20 20 30 20 20 35 35 | 36 33 35 34 35 31 35 34 | 0 55|63545154|
|00000710| 20 20 20 36 37 35 36 00 | 20 00 00 00 00 00 00 00 | 6756.| .......|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 2e 2f 75 73 72 2f 73 79 | 62 61 73 65 2f 64 6f 63 |./usr/sy|base/doc|
|00000810| 2f 73 79 6d 61 6e 2e 6d | 61 6e 00 00 00 00 00 00 |/syman.m|an......|
|00000820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 20 20 20 34 34 34 20 | 00 20 20 20 20 31 30 20 |. 444 |. 10 |
|000008f0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 20 |. 0 |. |
|00000900| 31 32 37 37 20 20 35 33 | 36 35 36 32 35 32 36 36 |1277 53|65625266|
|00000910| 20 20 31 30 36 37 37 00 | 20 00 00 00 00 00 00 00 | 10677.| .......|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 0a 20 20 31 20 20 20 20 | 20 20 20 20 20 20 20 20 |. 1 | |
|00000a10| 20 20 20 20 20 20 20 20 | 20 20 20 56 65 72 73 69 | | Versi|
|00000a20| 6f 6e 20 34 2e 30 20 2d | 2d 20 31 2f 31 35 2f 38 |on 4.0 -|- 1/15/8|
|00000a30| 39 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |9 | |
|00000a40| 20 20 20 20 73 79 6d 61 | 6e 0a 20 20 5f 5f 5f 5f | syma|n. ____|
|00000a50| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000a60| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000a70| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000a80| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000a90| 5f 5f 0a 0a 20 20 4e 41 | 4d 45 3a 20 20 73 79 6d |__.. NA|ME: sym|
|00000aa0| 61 6e 0a 0a 20 20 46 55 | 4e 43 54 49 4f 4e 3a 0a |an.. FU|NCTION:.|
|00000ab0| 20 20 20 20 20 20 20 44 | 69 73 70 6c 61 79 73 20 | D|isplays |
|00000ac0| 6f 6e 2d 6c 69 6e 65 20 | 6d 61 6e 75 61 6c 20 70 |on-line |manual p|
|00000ad0| 61 67 65 73 20 66 6f 72 | 20 74 68 65 20 20 6c 69 |ages for| the li|
|00000ae0| 62 72 61 72 79 20 20 72 | 6f 75 74 69 6e 65 73 2c |brary r|outines,|
|00000af0| 20 20 73 79 73 74 65 6d | 0a 20 20 20 20 20 20 20 | system|. |
|00000b00| 70 72 6f 63 65 64 75 72 | 65 73 2c 20 61 6e 64 20 |procedur|es, and |
|00000b10| 75 74 69 6c 69 74 79 20 | 70 72 6f 67 72 61 6d 73 |utility |programs|
|00000b20| 2e 0a 0a 20 20 53 59 4e | 54 41 58 3a 0a 20 20 20 |... SYN|TAX:. |
|00000b30| 20 20 20 20 73 79 6d 61 | 6e 20 6b 65 79 77 6f 72 | syma|n keywor|
|00000b40| 64 0a 0a 20 20 45 58 41 | 4d 50 4c 45 53 3a 0a 20 |d.. EXA|MPLES:. |
|00000b50| 20 20 20 20 20 20 31 29 | 20 20 73 79 6d 61 6e 20 | 1)| syman |
|00000b60| 62 63 70 0a 0a 0a 0a 0a | 0a 0a 0a 0a 20 20 73 79 |bcp.....|.... sy|
|00000b70| 6d 61 6e 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |man | |
|00000b80| 20 20 20 20 20 20 56 65 | 72 73 69 6f 6e 20 34 2e | Ve|rsion 4.|
|00000b90| 30 20 2d 2d 20 31 2f 31 | 35 2f 38 39 20 20 20 20 |0 -- 1/1|5/89 |
|00000ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000bb0| 20 20 20 32 0a 20 20 5f | 5f 5f 5f 5f 5f 5f 5f 5f | 2. _|________|
|00000bc0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000bd0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000be0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000bf0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 0a 20 20 |________|_____. |
|00000c00| 20 20 20 20 20 32 29 20 | 20 73 79 6d 61 6e 20 70 | 2) | syman p|
|00000c10| 61 73 73 77 6f 72 64 0a | 0a 20 20 43 4f 4d 4d 45 |assword.|. COMME|
|00000c20| 4e 54 53 3a 0a 0a 20 20 | 20 20 20 20 20 6f 20 41 |NTS:.. | o A|
|00000c30| 6c 74 68 6f 75 67 68 20 | 73 79 73 74 65 6d 20 70 |lthough |system p|
|00000c40| 72 6f 63 65 64 75 72 65 | 20 6e 61 6d 65 73 20 61 |rocedure| names a|
|00000c50| 6c 6c 20 62 65 67 69 6e | 20 77 69 74 68 20 73 70 |ll begin| with sp|
|00000c60| 5f 2c 20 79 6f 75 20 64 | 6f 20 20 6e 6f 74 0a 20 |_, you d|o not. |
|00000c70| 20 20 20 20 20 20 20 20 | 75 73 65 20 74 68 69 73 | |use this|
|00000c80| 20 70 72 65 66 69 78 20 | 77 69 74 68 20 74 68 65 | prefix |with the|
|00000c90| 20 73 79 6d 61 6e 20 75 | 74 69 6c 69 74 79 2e 20 | syman u|tility. |
|00000ca0| 20 28 53 65 65 20 65 78 | 61 6d 70 6c 65 20 32 2e | (See ex|ample 2.|
|00000cb0| 29 0a 0a 0a 0a 0a 0a 0a | 0a 0a 0a 0a 0a 0a 0a 6c |).......|.......l|
|00000cc0| 74 74 79 70 65 2e 6d 61 | 6e 00 00 00 00 01 b8 1f |ttype.ma|n.......|
|00000cd0| 00 14 00 0a 64 62 62 69 | 6e 64 2e 6d 61 6e 00 00 |....dbbi|nd.man..|
|00000ce0| 00 01 b8 20 00 18 00 0c | 64 62 62 79 6c 69 73 74 |... ....|dbbylist|
|00000cf0| 2e 6d 61 6e 00 00 00 00 | 00 01 b8 21 00 18 00 0c |.man....|...!....|
|00000d00| 64 62 63 61 6e 63 65 6c | 2e 6d 61 6e 00 00 00 00 |dbcancel|.man....|
|00000d10| 00 01 b8 22 00 18 00 0e | 64 62 63 61 6e 71 75 65 |..."....|dbcanque|
|00000d20| 72 79 2e 6d 61 6e 00 00 | 00 01 b8 23 00 18 00 0c |ry.man..|...#....|
|00000d30| 64 62 63 68 61 6e 67 65 | 2e 6d 61 6e 00 00 00 00 |dbchange|.man....|
|00000d40| 00 01 b8 24 00 14 00 0b | 64 62 63 6c 6f 73 65 2e |...$....|dbclose.|
|00000d50| 6d 61 6e 00 00 01 b8 25 | 00 18 00 0c 64 62 63 6c |man....%|....dbcl|
|00000d60| 72 62 75 66 2e 6d 61 6e | 00 00 00 00 00 01 b8 26 |rbuf.man|.......&|
|00000d70| 00 18 00 0c 64 62 63 6c | 72 6f 70 74 2e 6d 61 6e |....dbcl|ropt.man|
|00000d80| 00 00 00 00 00 01 b8 27 | 00 14 00 09 64 62 63 6d |.......'|....dbcm|
|00000d90| 64 2e 6d 61 6e 00 00 00 | 00 01 b8 28 00 18 00 0c |d.man...|...(....|
|00000da0| 64 62 63 6d 64 72 6f 77 | 2e 6d 61 6e 00 00 00 00 |dbcmdrow|.man....|
|00000db0| 00 01 b8 29 00 18 00 0f | 64 62 63 6f 6c 62 72 6f |...)....|dbcolbro|
|00000dc0| 77 73 65 2e 6d 61 6e 00 | 00 01 b8 2a 00 18 00 0c |wse.man.|...*....|
|00000dd0| 64 62 63 6f 6c 6c 65 6e | 2e 6d 61 6e 00 00 00 00 |dbcollen|.man....|
|00000de0| 00 01 b8 2b 00 18 00 0d | 64 62 63 6f 6c 6e 61 6d |...+....|dbcolnam|
|00000df0| 65 2e 6d 61 6e 00 00 00 | 00 01 b8 2c 00 28 00 0f |e.man...|...,.(..|
|00000e00| 2e 2f 75 73 72 2f 73 79 | 62 61 73 65 2f 64 6f 63 |./usr/sy|base/doc|
|00000e10| 2f 62 63 70 2e 6d 61 6e | 00 00 00 00 00 00 00 00 |/bcp.man|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 20 20 20 34 34 34 20 | 00 20 20 20 20 31 30 20 |. 444 |. 10 |
|00000ef0| 00 20 20 20 20 20 30 20 | 00 20 20 20 20 20 20 35 |. 0 |. 5|
|00000f00| 36 33 31 31 20 20 35 33 | 36 35 36 32 35 32 36 37 |6311 53|65625267|
|00000f10| 20 20 31 30 33 33 34 00 | 20 00 00 00 00 00 00 00 | 10334.| .......|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 0a 20 20 31 20 20 20 20 | 20 20 20 20 20 20 20 20 |. 1 | |
|00001010| 20 20 20 20 20 20 20 20 | 20 20 20 56 65 72 73 69 | | Versi|
|00001020| 6f 6e 20 34 2e 30 20 2d | 2d 20 31 2f 31 35 2f 38 |on 4.0 -|- 1/15/8|
|00001030| 39 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |9 | |
|00001040| 20 20 20 20 20 20 62 63 | 70 0a 20 20 5f 5f 5f 5f | bc|p. ____|
|00001050| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001060| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001070| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001080| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001090| 5f 5f 0a 0a 20 20 4e 41 | 4d 45 3a 20 20 62 63 70 |__.. NA|ME: bcp|
|000010a0| 0a 0a 20 20 46 55 4e 43 | 54 49 4f 4e 3a 0a 20 20 |.. FUNC|TION:. |
|000010b0| 20 20 20 20 20 43 6f 70 | 69 65 73 20 61 20 64 61 | Cop|ies a da|
|000010c0| 74 61 62 61 73 65 20 74 | 61 62 6c 65 20 74 6f 20 |tabase t|able to |
|000010d0| 20 6f 72 20 20 66 72 6f | 6d 20 20 61 20 20 68 6f | or fro|m a ho|
|000010e0| 73 74 20 20 66 69 6c 65 | 20 20 69 6e 20 20 61 20 |st file| in a |
|000010f0| 20 75 73 65 72 2d 0a 20 | 20 20 20 20 20 20 73 70 | user-. | sp|
|00001100| 65 63 69 66 69 65 64 20 | 66 6f 72 6d 61 74 2e 0a |ecified |format..|
|00001110| 0a 20 20 53 59 4e 54 41 | 58 3a 0a 20 20 20 20 20 |. SYNTA|X:. |
|00001120| 20 20 62 63 70 20 5b 5b | 64 61 74 61 62 61 73 65 | bcp [[|database|
|00001130| 5f 6e 61 6d 65 2e 5d 6f | 77 6e 65 72 2e 5d 74 61 |_name.]o|wner.]ta|
|00001140| 62 6c 65 5f 6e 61 6d 65 | 20 7b 69 6e 20 7c 20 6f |ble_name| {in | o|
|00001150| 75 74 7d 20 64 61 74 61 | 66 69 6c 65 0a 20 20 20 |ut} data|file. |
|00001160| 20 20 20 20 5b 2d 6d 20 | 6d 61 78 65 72 72 6f 72 | [-m |maxerror|
|00001170| 73 5d 20 20 5b 2d 66 20 | 66 6f 72 6d 61 74 66 69 |s] [-f |formatfi|
|00001180| 6c 65 5d 20 5b 2d 65 20 | 65 72 72 66 69 6c 65 5d |le] [-e |errfile]|
|00001190| 0a 20 20 20 20 20 20 20 | 5b 2d 46 20 66 69 72 73 |. |[-F firs|
|000011a0| 74 72 6f 77 5d 20 20 5b | 2d 4c 20 6c 61 73 74 72 |trow] [|-L lastr|
|000011b0| 6f 77 5d 20 5b 2d 62 20 | 62 61 74 63 68 73 69 7a |ow] [-b |batchsiz|
|000011c0| 65 5d 0a 20 20 20 20 20 | 20 20 5b 2d 6e 5d 20 5b |e]. | [-n] [|
|000011d0| 2d 63 5d 0a 20 20 20 20 | 20 20 20 5b 2d 74 20 66 |-c]. | [-t f|
|000011e0| 69 65 6c 64 2d 74 65 72 | 6d 69 6e 61 74 6f 72 5d |ield-ter|minator]|
|000011f0| 20 5b 2d 72 20 72 6f 77 | 2d 74 65 72 6d 69 6e 61 | [-r row|-termina|
|00001200| 74 6f 72 5d 0a 0a 0a 0a | 0a 0a 0a 0a 20 20 62 63 |tor]....|.... bc|
|00001210| 70 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |p | |
|00001220| 20 20 20 20 20 20 56 65 | 72 73 69 6f 6e 20 34 2e | Ve|rsion 4.|
|00001230| 30 20 2d 2d 20 31 2f 31 | 35 2f 38 39 20 20 20 20 |0 -- 1/1|5/89 |
|00001240| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001250| 20 20 20 32 0a 20 20 5f | 5f 5f 5f 5f 5f 5f 5f 5f | 2. _|________|
|00001260| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001270| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001280| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001290| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 0a 20 20 |________|_____. |
|000012a0| 20 20 20 20 20 5b 2d 55 | 20 75 73 65 72 6e 61 6d | [-U| usernam|
|000012b0| 65 5d 20 5b 2d 50 20 70 | 61 73 73 77 6f 72 64 5d |e] [-P p|assword]|
|000012c0| 20 5b 2d 49 20 69 6e 74 | 65 72 66 61 63 65 5d 20 | [-I int|erface] |
|000012d0| 5b 2d 53 20 73 65 72 76 | 65 72 5d 20 5b 2d 76 5d |[-S serv|er] [-v]|
|000012e0| 0a 0a 20 20 45 58 41 4d | 50 4c 45 53 3a 0a 20 20 |.. EXAM|PLES:. |
|000012f0| 20 20 20 20 20 49 6e 20 | 74 68 65 20 66 6f 6c 6c | In |the foll|
|00001300| 6f 77 69 6e 67 20 65 78 | 61 6d 70 6c 65 2c 20 62 |owing ex|ample, b|
|00001310| 63 70 20 63 6f 70 69 65 | 73 20 20 64 61 74 61 20 |cp copie|s data |
|00001320| 20 66 72 6f 6d 20 20 74 | 68 65 20 20 70 75 62 6c | from t|he publ|
|00001330| 69 73 68 65 72 73 0a 20 | 20 20 20 20 20 20 74 61 |ishers. | ta|
|00001340| 62 6c 65 20 20 74 6f 20 | 20 61 20 20 66 69 6c 65 |ble to | a file|
|00001350| 20 66 6f 72 20 6c 61 74 | 65 72 20 72 65 6c 6f 61 | for lat|er reloa|
|00001360| 64 69 6e 67 20 69 6e 74 | 6f 20 53 51 4c 20 53 65 |ding int|o SQL Se|
|00001370| 72 76 65 72 2e 20 20 44 | 65 66 61 75 6c 74 73 0a |rver. D|efaults.|
|00001380| 20 20 20 20 20 20 20 77 | 65 72 65 20 61 63 63 65 | w|ere acce|
|00001390| 70 74 65 64 20 66 6f 72 | 20 61 6c 6c 20 70 72 6f |pted for| all pro|
|000013a0| 6d 70 74 73 20 62 79 20 | 70 72 65 73 73 69 6e 67 |mpts by |pressing|
|000013b0| 20 52 45 54 55 52 4e 2e | 0a 0a 20 20 20 20 20 20 | RETURN.|.. |
|000013c0| 20 62 63 70 20 70 75 62 | 73 2e 2e 70 75 62 6c 69 | bcp pub|s..publi|
|000013d0| 73 68 65 72 73 20 6f 75 | 74 20 70 75 62 6c 5f 6f |shers ou|t publ_o|
|000013e0| 75 74 0a 20 20 20 20 20 | 20 20 50 61 73 73 77 6f |ut. | Passwo|
|000013f0| 72 64 3a 0a 0a 20 20 20 | 20 20 20 20 45 6e 74 65 |rd:.. | Ente|
|00001400| 72 20 74 68 65 20 66 69 | 6c 65 20 73 74 6f 72 61 |r the fi|le stora|
|00001410| 67 65 20 74 79 70 65 20 | 6f 66 20 66 69 65 6c 64 |ge type |of field|
|00001420| 20 70 75 62 5f 69 64 20 | 5b 63 68 61 72 5d 3a 0a | pub_id |[char]:.|
|00001430| 20 20 20 20 20 20 20 45 | 6e 74 65 72 20 70 72 65 | E|nter pre|
|00001440| 66 69 78 2d 6c 65 6e 67 | 74 68 20 6f 66 20 66 69 |fix-leng|th of fi|
|00001450| 65 6c 64 20 70 75 62 5f | 69 64 20 5b 30 5d 3a 0a |eld pub_|id [0]:.|
|00001460| 20 20 20 20 20 20 20 45 | 6e 74 65 72 20 6c 65 6e | E|nter len|
|00001470| 67 74 68 20 6f 66 20 66 | 69 65 6c 64 20 70 75 62 |gth of f|ield pub|
|00001480| 5f 69 64 20 5b 34 5d 3a | 0a 20 20 20 20 20 20 20 |_id [4]:|. |
|00001490| 45 6e 74 65 72 20 66 69 | 65 6c 64 20 74 65 72 6d |Enter fi|eld term|
|000014a0| 69 6e 61 74 6f 72 20 5b | 6e 6f 6e 65 5d 3a 0a 0a |inator [|none]:..|
|000014b0| 20 20 20 20 20 20 20 45 | 6e 74 65 72 20 74 68 65 | E|nter the|
|000014c0| 20 66 69 6c 65 20 73 74 | 6f 72 61 67 65 20 74 79 | file st|orage ty|
|000014d0| 70 65 20 6f 66 20 66 69 | 65 6c 64 20 70 75 62 5f |pe of fi|eld pub_|
|000014e0| 6e 61 6d 65 20 5b 63 68 | 61 72 5d 3a 0a 20 20 20 |name [ch|ar]:. |
|000014f0| 20 20 20 20 45 6e 74 65 | 72 20 70 72 65 66 69 78 | Ente|r prefix|
|00001500| 2d 6c 65 6e 67 74 68 20 | 6f 66 20 66 69 65 6c 64 |-length |of field|
|00001510| 20 70 75 62 5f 6e 61 6d | 65 20 5b 31 5d 3a 0a 0a | pub_nam|e [1]:..|
|00001520| 0a 0a 20 20 33 20 20 20 | 20 20 20 20 20 20 20 20 |.. 3 | |
|00001530| 20 20 20 20 20 20 20 20 | 20 20 20 20 56 65 72 73 | | Vers|
|00001540| 69 6f 6e 20 34 2e 30 20 | 2d 2d 20 31 2f 31 35 2f |ion 4.0 |-- 1/15/|
|00001550| 38 39 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |89 | |
|00001560| 20 20 20 20 20 20 20 62 | 63 70 0a 20 20 5f 5f 5f | b|cp. ___|
|00001570| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001580| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001590| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000015a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000015b0| 5f 5f 5f 0a 20 20 20 20 | 20 20 20 45 6e 74 65 72 |___. | Enter|
|000015c0| 20 6c 65 6e 67 74 68 20 | 6f 66 20 66 69 65 6c 64 | length |of field|
|000015d0| 20 70 75 62 5f 6e 61 6d | 65 20 5b 34 30 5d 3a 0a | pub_nam|e [40]:.|
|000015e0| 20 20 20 20 20 20 20 45 | 6e 74 65 72 20 66 69 65 | E|nter fie|
|000015f0| 6c 64 20 74 65 72 6d 69 | 6e 61 74 6f 72 20 5b 6e |ld termi|nator [n|
|00001600| 6f 6e 65 5d 3a 0a 0a 20 | 20 20 20 20 20 20 45 6e |one]:.. | En|
|00001610| 74 65 72 20 74 68 65 20 | 66 69 6c 65 20 73 74 6f |ter the |file sto|
|00001620| 72 61 67 65 20 74 79 70 | 65 20 6f 66 20 66 69 65 |rage typ|e of fie|
|00001630| 6c 64 20 63 69 74 79 20 | 5b 63 68 61 72 5d 3a 0a |ld city |[char]:.|
|00001640| 20 20 20 20 20 20 20 45 | 6e 74 65 72 20 70 72 65 | E|nter pre|
|00001650| 66 69 78 2d 6c 65 6e 67 | 74 68 20 6f 66 20 66 69 |fix-leng|th of fi|
|00001660| 65 6c 64 20 63 69 74 79 | 20 5b 31 5d 3a 0a 20 20 |eld city| [1]:. |
|00001670| 20 20 20 20 20 45 6e 74 | 65 72 20 6c 65 6e 67 74 | Ent|er lengt|
|00001680| 68 20 6f 66 20 66 69 65 | 6c 64 20 63 69 74 79 20 |h of fie|ld city |
|00001690| 5b 32 30 5d 3a 0a 20 20 | 20 20 20 20 20 45 6e 74 |[20]:. | Ent|
|000016a0| 65 72 20 66 69 65 6c 64 | 20 74 65 72 6d 69 6e 61 |er field| termina|
|000016b0| 74 6f 72 20 5b 6e 6f 6e | 65 5d 3a 0a 0a 20 20 20 |tor [non|e]:.. |
|000016c0| 20 20 20 20 45 6e 74 65 | 72 20 74 68 65 20 66 69 | Ente|r the fi|
|000016d0| 6c 65 20 73 74 6f 72 61 | 67 65 20 74 79 70 65 20 |le stora|ge type |
|000016e0| 6f 66 20 66 69 65 6c 64 | 20 73 74 61 74 65 20 5b |of field| state [|
|000016f0| 63 68 61 72 5d 3a 0a 20 | 20 20 20 20 20 20 45 6e |char]:. | En|
|00001700| 74 65 72 20 70 72 65 66 | 69 78 2d 6c 65 6e 67 74 |ter pref|ix-lengt|
|00001710| 68 20 6f 66 20 66 69 65 | 6c 64 20 73 74 61 74 65 |h of fie|ld state|
|00001720| 20 5b 31 5d 3a 0a 20 20 | 20 20 20 20 20 45 6e 74 | [1]:. | Ent|
|00001730| 65 72 20 6c 65 6e 67 74 | 68 20 6f 66 20 66 69 65 |er lengt|h of fie|
|00001740| 6c 64 20 73 74 61 74 65 | 20 5b 32 5d 3a 0a 20 20 |ld state| [2]:. |
|00001750| 20 20 20 20 20 45 6e 74 | 65 72 20 66 69 65 6c 64 | Ent|er field|
|00001760| 20 74 65 72 6d 69 6e 61 | 74 6f 72 20 5b 6e 6f 6e | termina|tor [non|
|00001770| 65 5d 3a 0a 0a 20 20 20 | 20 20 20 20 44 6f 20 79 |e]:.. | Do y|
|00001780| 6f 75 20 77 61 6e 74 20 | 74 6f 20 73 61 76 65 20 |ou want |to save |
|00001790| 74 68 69 73 20 66 6f 72 | 6d 61 74 20 69 6e 66 6f |this for|mat info|
|000017a0| 72 6d 61 74 69 6f 6e 20 | 69 6e 20 61 20 66 69 6c |rmation |in a fil|
|000017b0| 65 3f 20 5b 59 2d 6e 5d | 20 79 0a 20 20 20 20 20 |e? [Y-n]| y. |
|000017c0| 20 20 48 6f 73 74 20 66 | 69 6c 65 6e 61 6d 65 20 | Host f|ilename |
|000017d0| 5b 62 63 70 2e 66 6d 74 | 5d 3a 20 70 75 62 5f 66 |[bcp.fmt|]: pub_f|
|000017e0| 6f 72 6d 0a 0a 20 20 20 | 20 20 20 20 53 74 61 72 |orm.. | Star|
|000017f0| 74 69 6e 67 20 63 6f 70 | 79 2e 2e 2e 0a 0a 0a 0a |ting cop|y.......|
|00001800| 20 20 62 63 70 20 20 20 | 20 20 20 20 20 20 20 20 | bcp | |
|00001810| 20 20 20 20 20 20 20 20 | 20 20 56 65 72 73 69 6f | | Versio|
|00001820| 6e 20 34 2e 30 20 2d 2d | 20 31 2f 31 35 2f 38 39 |n 4.0 --| 1/15/89|
|00001830| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001840| 20 20 20 20 20 20 20 34 | 0a 20 20 5f 5f 5f 5f 5f | 4|. _____|
|00001850| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001860| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001870| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001880| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001890| 5f 0a 0a 20 20 20 20 20 | 20 20 33 20 72 6f 77 73 |_.. | 3 rows|
|000018a0| 20 63 6f 70 69 65 64 2e | 0a 20 20 20 20 20 20 20 | copied.|. |
|000018b0| 43 6c 6f 63 6b 20 54 69 | 6d 65 20 28 6d 73 2e 29 |Clock Ti|me (ms.)|
|000018c0| 3a 20 74 6f 74 61 6c 20 | 3d 20 30 20 20 20 41 76 |: total |= 0 Av|
|000018d0| 67 20 3d 20 30 20 20 28 | 33 2e 30 30 20 72 6f 77 |g = 0 (|3.00 row|
|000018e0| 73 20 70 65 72 20 73 65 | 63 2e 29 0a 0a 20 20 20 |s per se|c.).. |
|000018f0| 20 20 20 20 54 68 65 20 | 72 65 73 75 6c 74 73 20 | The |results |
|00001900| 67 6f 20 69 6e 74 6f 20 | 70 75 62 6c 5f 6f 75 74 |go into |publ_out|
|00001910| 2e 0a 0a 20 20 20 20 20 | 20 20 54 6f 20 63 6f 70 |... | To cop|
|00001920| 79 20 74 68 69 73 20 64 | 61 74 61 20 62 61 63 6b |y this d|ata back|
|00001930| 20 69 6e 74 6f 20 53 51 | 4c 20 53 65 72 76 65 72 | into SQ|L Server|
|00001940| 20 20 75 73 69 6e 67 20 | 20 74 68 65 20 20 73 61 | using | the sa|
|00001950| 76 65 64 20 20 66 6f 72 | 6d 61 74 0a 20 20 20 20 |ved for|mat. |
|00001960| 20 20 20 66 69 6c 65 2c | 20 70 75 62 5f 66 6f 72 | file,| pub_for|
|00001970| 6d 2c 20 79 6f 75 20 77 | 6f 75 6c 64 20 75 73 65 |m, you w|ould use|
|00001980| 20 74 68 65 20 63 6f 6d | 6d 61 6e 64 3a 0a 0a 20 | the com|mand:.. |
|00001990| 20 20 20 20 20 20 62 63 | 70 20 70 75 62 73 2e 2e | bc|p pubs..|
|000019a0| 70 75 62 6c 69 73 68 65 | 72 73 20 69 6e 20 70 75 |publishe|rs in pu|
|000019b0| 62 6c 5f 6f 75 74 20 2d | 66 20 70 75 62 5f 66 6f |bl_out -|f pub_fo|
|000019c0| 72 6d 0a 0a 0a 20 20 50 | 41 52 41 4d 45 54 45 52 |rm... P|ARAMETER|
|000019d0| 53 3a 0a 20 20 20 20 20 | 20 20 64 61 74 61 62 61 |S:. | databa|
|000019e0| 73 65 5f 6e 61 6d 65 20 | 2d 20 20 69 73 20 6f 70 |se_name |- is op|
|000019f0| 74 69 6f 6e 61 6c 20 69 | 66 20 74 68 65 20 74 61 |tional i|f the ta|
|00001a00| 62 6c 65 20 62 65 69 6e | 67 20 63 6f 70 69 65 64 |ble bein|g copied|
|00001a10| 20 69 73 20 69 6e 20 79 | 6f 75 72 0a 20 20 20 20 | is in y|our. |
|00001a20| 20 20 20 20 20 20 20 64 | 65 66 61 75 6c 74 20 20 | d|efault |
|00001a30| 64 61 74 61 62 61 73 65 | 2e 20 20 20 4f 74 68 65 |database|. Othe|
|00001a40| 72 77 69 73 65 2c 20 20 | 79 6f 75 20 20 6d 75 73 |rwise, |you mus|
|00001a50| 74 20 73 70 65 63 69 66 | 79 20 61 20 64 61 74 61 |t specif|y a data|
|00001a60| 62 61 73 65 0a 20 20 20 | 20 20 20 20 20 20 20 20 |base. | |
|00001a70| 6e 61 6d 65 2e 0a 20 20 | 20 20 20 20 20 6f 77 6e |name.. | own|
|00001a80| 65 72 20 2d 20 20 69 73 | 20 6f 70 74 69 6f 6e 61 |er - is| optiona|
|00001a90| 6c 20 6f 6e 6c 79 20 69 | 66 20 79 6f 75 20 6f 77 |l only i|f you ow|
|00001aa0| 6e 20 74 68 65 20 74 61 | 62 6c 65 20 62 65 69 6e |n the ta|ble bein|
|00001ab0| 67 20 63 6f 70 69 65 64 | 2e 20 20 20 49 66 0a 0a |g copied|. If..|
|00001ac0| 0a 0a 20 20 35 20 20 20 | 20 20 20 20 20 20 20 20 |.. 5 | |
|00001ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 56 65 72 73 | | Vers|
|00001ae0| 69 6f 6e 20 34 2e 30 20 | 2d 2d 20 31 2f 31 35 2f |ion 4.0 |-- 1/15/|
|00001af0| 38 39 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |89 | |
|00001b00| 20 20 20 20 20 20 20 62 | 63 70 0a 20 20 5f 5f 5f | b|cp. ___|
|00001b10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001b20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001b30| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001b40| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001b50| 5f 5f 5f 0a 20 20 20 20 | 20 20 20 20 20 20 20 6e |___. | n|
|00001b60| 6f 20 6f 77 6e 65 72 20 | 69 73 20 73 70 65 63 69 |o owner |is speci|
|00001b70| 66 69 65 64 20 61 6e 64 | 20 79 6f 75 20 64 6f 20 |fied and| you do |
|00001b80| 6e 6f 74 20 20 6f 77 6e | 20 20 61 20 20 74 61 62 |not own| a tab|
|00001b90| 6c 65 20 20 6f 66 20 20 | 74 68 61 74 0a 20 20 20 |le of |that. |
|00001ba0| 20 20 20 20 20 20 20 20 | 6e 61 6d 65 2c 20 74 68 | |name, th|
|00001bb0| 65 20 63 6f 6d 6d 61 6e | 64 20 66 61 69 6c 73 2e |e comman|d fails.|
|00001bc0| 0a 20 20 20 20 20 20 20 | 74 61 62 6c 65 5f 6e 61 |. |table_na|
|00001bd0| 6d 65 20 2d 20 20 74 68 | 65 20 6e 61 6d 65 20 6f |me - th|e name o|
|00001be0| 66 20 74 68 65 20 64 61 | 74 61 62 61 73 65 20 74 |f the da|tabase t|
|00001bf0| 61 62 6c 65 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |able you| want to|
|00001c00| 20 63 6f 70 79 2e 0a 20 | 20 20 20 20 20 20 7b 69 | copy.. | {i|
|00001c10| 6e 20 7c 20 6f 75 74 7d | 20 2d 20 20 74 68 65 20 |n | out}| - the |
|00001c20| 64 69 72 65 63 74 69 6f | 6e 20 6f 66 20 74 68 65 |directio|n of the|
|00001c30| 20 63 6f 70 79 2e 20 49 | 6e 20 69 6e 64 69 63 61 | copy. I|n indica|
|00001c40| 74 65 73 20 61 20 63 6f | 70 79 20 66 72 6f 6d 0a |tes a co|py from.|
|00001c50| 20 20 20 20 20 20 20 20 | 20 20 20 61 20 66 69 6c | | a fil|
|00001c60| 65 20 69 6e 74 6f 20 74 | 68 65 20 64 61 74 61 62 |e into t|he datab|
|00001c70| 61 73 65 20 74 61 62 6c | 65 2c 20 77 68 69 6c 65 |ase tabl|e, while|
|00001c80| 20 6f 75 74 20 69 73 20 | 61 20 63 6f 70 79 20 74 | out is |a copy t|
|00001c90| 6f 20 61 20 66 69 6c 65 | 0a 20 20 20 20 20 20 20 |o a file|. |
|00001ca0| 20 20 20 20 66 72 6f 6d | 20 74 68 65 20 64 61 74 | from| the dat|
|00001cb0| 61 62 61 73 65 20 74 61 | 62 6c 65 2e 0a 20 20 20 |abase ta|ble.. |
|00001cc0| 20 20 20 20 64 61 74 61 | 66 69 6c 65 20 2d 20 20 | data|file - |
|00001cd0| 74 68 65 20 66 75 6c 6c | 20 70 61 74 68 20 6e 61 |the full| path na|
|00001ce0| 6d 65 20 6f 66 20 61 20 | 68 6f 73 74 20 66 69 6c |me of a |host fil|
|00001cf0| 65 2e 20 20 54 68 65 20 | 70 61 74 68 20 6e 61 6d |e. The |path nam|
|00001d00| 65 20 63 61 6e 0a 20 20 | 20 20 20 20 20 20 20 20 |e can. | |
|00001d10| 20 62 65 20 20 66 72 6f | 6d 20 31 20 74 6f 20 32 | be fro|m 1 to 2|
|00001d20| 35 35 20 63 68 61 72 61 | 63 74 65 72 73 20 69 6e |55 chara|cters in|
|00001d30| 20 6c 65 6e 67 74 68 2e | 20 20 49 74 20 63 61 6e | length.| It can|
|00001d40| 20 61 6c 73 6f 20 69 6e | 64 69 63 61 74 65 0a 20 | also in|dicate. |
|00001d50| 20 20 20 20 20 20 20 20 | 20 20 61 20 74 61 70 65 | | a tape|
|00001d60| 20 64 72 69 76 65 20 6e | 61 6d 65 2e 0a 20 20 20 | drive n|ame.. |
|00001d70| 20 20 20 20 2d 6d 20 6d | 61 78 65 72 72 6f 72 73 | -m m|axerrors|
|00001d80| 20 2d 20 20 74 68 65 20 | 6d 61 78 69 6d 75 6d 20 | - the |maximum |
|00001d90| 6e 75 6d 62 65 72 20 6f | 66 20 65 72 72 6f 72 73 |number o|f errors|
|00001da0| 20 62 65 66 6f 72 65 20 | 74 68 65 20 20 63 6f 70 | before |the cop|
|00001db0| 79 20 20 69 73 0a 20 20 | 20 20 20 20 20 20 20 20 |y is. | |
|00001dc0| 20 61 62 6f 72 74 65 64 | 2e 20 20 20 45 61 63 68 | aborted|. Each|
|00001dd0| 20 20 72 6f 77 20 74 68 | 61 74 20 63 61 6e 27 74 | row th|at can't|
|00001de0| 20 62 65 20 62 75 69 6c | 74 20 62 79 20 62 63 70 | be buil|t by bcp|
|00001df0| 20 69 73 20 74 68 72 6f | 77 6e 20 6f 75 74 0a 20 | is thro|wn out. |
|00001e00| 20 20 20 20 20 20 20 20 | 20 20 61 6e 64 20 63 6f | | and co|
|00001e10| 75 6e 74 65 64 20 61 73 | 20 6f 6e 65 20 65 72 72 |unted as| one err|
|00001e20| 6f 72 2e 20 20 54 68 65 | 20 64 65 66 61 75 6c 74 |or. The| default|
|00001e30| 2c 20 75 73 65 64 20 69 | 66 20 20 74 68 69 73 20 |, used i|f this |
|00001e40| 20 6f 70 74 69 6f 6e 0a | 20 20 20 20 20 20 20 20 | option.| |
|00001e50| 20 20 20 69 73 20 6e 6f | 74 20 69 6e 63 6c 75 64 | is no|t includ|
|00001e60| 65 64 2c 20 69 73 20 31 | 30 2e 0a 20 20 20 20 20 |ed, is 1|0.. |
|00001e70| 20 20 2d 66 20 66 6f 72 | 6d 61 74 66 69 6c 65 20 | -f for|matfile |
|00001e80| 2d 20 20 74 68 65 20 20 | 66 75 6c 6c 20 20 70 61 |- the |full pa|
|00001e90| 74 68 20 20 6e 61 6d 65 | 20 20 6f 66 20 20 61 20 |th name| of a |
|00001ea0| 20 66 69 6c 65 20 20 77 | 69 74 68 20 20 73 74 6f | file w|ith sto|
|00001eb0| 72 65 64 0a 20 20 20 20 | 20 20 20 20 20 20 20 72 |red. | r|
|00001ec0| 65 73 70 6f 6e 73 65 73 | 20 66 72 6f 6d 20 61 20 |esponses| from a |
|00001ed0| 70 72 65 76 69 6f 75 73 | 20 75 73 65 20 6f 66 20 |previous| use of |
|00001ee0| 62 63 70 20 6f 6e 20 74 | 68 65 20 73 61 6d 65 20 |bcp on t|he same |
|00001ef0| 74 61 62 6c 65 3b 20 63 | 72 65 61 2d 0a 20 20 20 |table; c|rea-. |
|00001f00| 20 20 20 20 20 20 20 20 | 74 69 6f 6e 20 6f 66 20 | |tion of |
|00001f10| 74 68 65 20 66 6f 72 6d | 61 74 20 66 69 6c 65 20 |the form|at file |
|00001f20| 69 73 20 6f 70 74 69 6f | 6e 61 6c 2e 20 20 55 73 |is optio|nal. Us|
|00001f30| 65 20 20 74 68 69 73 20 | 20 6f 70 74 69 6f 6e 20 |e this | option |
|00001f40| 20 6f 6e 6c 79 0a 20 20 | 20 20 20 20 20 20 20 20 | only. | |
|00001f50| 20 77 68 65 6e 20 20 79 | 6f 75 20 68 61 76 65 20 | when y|ou have |
|00001f60| 61 6c 72 65 61 64 79 20 | 63 72 65 61 74 65 64 20 |already |created |
|00001f70| 61 20 66 6f 72 6d 61 74 | 20 66 69 6c 65 20 74 68 |a format| file th|
|00001f80| 61 74 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 0a 0a |at you w|ant to..|
|00001f90| 0a 0a 20 20 62 63 70 20 | 20 20 20 20 20 20 20 20 |.. bcp | |
|00001fa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 56 65 72 73 | | Vers|
|00001fb0| 69 6f 6e 20 34 2e 30 20 | 2d 2d 20 31 2f 31 35 2f |ion 4.0 |-- 1/15/|
|00001fc0| 38 39 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |89 | |
|00001fd0| 20 20 20 20 20 20 20 20 | 20 36 0a 20 20 5f 5f 5f | | 6. ___|
|00001fe0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00001ff0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002000| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002010| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002020| 5f 5f 5f 0a 20 20 20 20 | 20 20 20 20 20 20 20 75 |___. | u|
|00002030| 73 65 20 66 6f 72 20 61 | 20 63 6f 70 79 20 69 6e |se for a| copy in|
|00002040| 20 6f 72 20 6f 75 74 2e | 20 20 20 41 66 74 65 72 | or out.| After|
|00002050| 20 20 79 6f 75 20 20 61 | 6e 73 77 65 72 20 20 62 | you a|nswer b|
|00002060| 63 70 27 73 20 20 66 6f | 72 6d 61 74 0a 20 20 20 |cp's fo|rmat. |
|00002070| 20 20 20 20 20 20 20 20 | 71 75 65 73 74 69 6f 6e | |question|
|00002080| 73 2c 20 20 69 74 20 20 | 77 69 6c 6c 20 61 73 6b |s, it |will ask|
|00002090| 20 79 6f 75 20 69 66 20 | 79 6f 75 20 77 61 6e 74 | you if |you want|
|000020a0| 20 74 6f 20 73 61 76 65 | 20 79 6f 75 72 20 61 6e | to save| your an|
|000020b0| 73 77 65 72 73 0a 20 20 | 20 20 20 20 20 20 20 20 |swers. | |
|000020c0| 20 69 6e 20 61 20 66 6f | 72 6d 61 74 20 66 69 6c | in a fo|rmat fil|
|000020d0| 65 2e 20 20 54 68 65 20 | 64 65 66 61 75 6c 74 20 |e. The |default |
|000020e0| 66 69 6c 65 20 6e 61 6d | 65 20 69 73 20 62 63 70 |file nam|e is bcp|
|000020f0| 2e 66 6d 74 2e 20 20 54 | 68 65 20 62 63 70 0a 20 |.fmt. T|he bcp. |
|00002100| 20 20 20 20 20 20 20 20 | 20 20 70 72 6f 67 72 61 | | progra|
|00002110| 6d 20 63 61 6e 20 72 65 | 66 65 72 20 74 6f 20 61 |m can re|fer to a|
|00002120| 20 66 6f 72 6d 61 74 20 | 66 69 6c 65 20 77 68 65 | format |file whe|
|00002130| 6e 20 63 6f 70 79 69 6e | 67 20 64 61 74 61 2c 20 |n copyin|g data, |
|00002140| 73 6f 20 74 68 61 74 0a | 20 20 20 20 20 20 20 20 |so that.| |
|00002150| 20 20 20 79 6f 75 20 64 | 6f 20 6e 6f 74 20 68 61 | you d|o not ha|
|00002160| 76 65 20 74 6f 20 64 75 | 70 6c 69 63 61 74 65 20 |ve to du|plicate |
|00002170| 79 6f 75 72 20 70 72 65 | 76 69 6f 75 73 20 20 66 |your pre|vious f|
|00002180| 6f 72 6d 61 74 20 20 72 | 65 73 70 6f 6e 73 65 73 |ormat r|esponses|
|00002190| 0a 20 20 20 20 20 20 20 | 20 20 20 20 69 6e 74 65 |. | inte|
|000021a0| 72 61 63 74 69 76 65 6c | 79 2e 20 20 20 49 66 20 |ractivel|y. If |
|000021b0| 20 74 68 69 73 20 20 6f | 70 74 69 6f 6e 20 69 73 | this o|ption is|
|000021c0| 20 6e 6f 74 20 75 73 65 | 64 2c 20 62 63 70 20 77 | not use|d, bcp w|
|000021d0| 69 6c 6c 20 71 75 65 72 | 79 0a 20 20 20 20 20 20 |ill quer|y. |
|000021e0| 20 20 20 20 20 79 6f 75 | 20 66 6f 72 20 66 6f 72 | you| for for|
|000021f0| 6d 61 74 20 69 6e 66 6f | 72 6d 61 74 69 6f 6e 20 |mat info|rmation |
|00002200| 69 6e 74 65 72 61 63 74 | 69 76 65 6c 79 2e 0a 20 |interact|ively.. |
|00002210| 20 20 20 20 20 20 2d 65 | 20 65 72 72 66 69 6c 65 | -e| errfile|
|00002220| 20 2d 20 20 74 68 65 20 | 66 75 6c 6c 20 70 61 74 | - the |full pat|
|00002230| 68 20 6e 61 6d 65 20 20 | 6f 66 20 20 61 6e 20 20 |h name |of an |
|00002240| 65 72 72 6f 72 20 20 66 | 69 6c 65 20 20 77 68 65 |error f|ile whe|
|00002250| 72 65 20 20 62 63 70 0a | 20 20 20 20 20 20 20 20 |re bcp.| |
|00002260| 20 20 20 73 74 6f 72 65 | 73 20 20 61 6e 79 20 72 | store|s any r|
|00002270| 6f 77 73 20 74 68 61 74 | 20 69 74 20 77 61 73 20 |ows that| it was |
|00002280| 75 6e 61 62 6c 65 20 74 | 6f 20 74 72 61 6e 73 66 |unable t|o transf|
|00002290| 65 72 20 66 72 6f 6d 20 | 74 68 65 20 66 69 6c 65 |er from |the file|
|000022a0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 74 6f 20 74 |. | to t|
|000022b0| 68 65 20 64 61 74 61 62 | 61 73 65 2e 20 20 45 72 |he datab|ase. Er|
|000022c0| 72 6f 72 20 6d 65 73 73 | 61 67 65 73 20 66 72 6f |ror mess|ages fro|
|000022d0| 6d 20 74 68 65 20 62 63 | 70 20 70 72 6f 67 72 61 |m the bc|p progra|
|000022e0| 6d 20 20 67 6f 20 20 74 | 6f 0a 20 20 20 20 20 20 |m go t|o. |
|000022f0| 20 20 20 20 20 74 68 65 | 20 75 73 65 72 27 73 20 | the| user's |
|00002300| 77 6f 72 6b 73 74 61 74 | 69 6f 6e 2e 20 20 49 66 |workstat|ion. If|
|00002310| 20 74 68 69 73 20 6f 70 | 74 69 6f 6e 20 69 73 20 | this op|tion is |
|00002320| 6e 6f 74 20 75 73 65 64 | 2c 20 6e 6f 20 65 72 72 |not used|, no err|
|00002330| 6f 72 0a 20 20 20 20 20 | 20 20 20 20 20 20 66 69 |or. | fi|
|00002340| 6c 65 20 69 73 20 63 72 | 65 61 74 65 64 2e 0a 20 |le is cr|eated.. |
|00002350| 20 20 20 20 20 20 2d 46 | 20 66 69 72 73 74 72 6f | -F| firstro|
|00002360| 77 20 2d 20 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |w - the| number |
|00002370| 6f 66 20 74 68 65 20 66 | 69 72 73 74 20 72 6f 77 |of the f|irst row|
|00002380| 20 74 6f 20 20 63 6f 70 | 79 20 20 28 64 65 66 61 | to cop|y (defa|
|00002390| 75 6c 74 20 20 69 73 0a | 20 20 20 20 20 20 20 20 |ult is.| |
|000023a0| 20 20 20 74 68 65 20 66 | 69 72 73 74 20 72 6f 77 | the f|irst row|
|000023b0| 29 2e 0a 20 20 20 20 20 | 20 20 2d 4c 20 6c 61 73 |).. | -L las|
|000023c0| 74 72 6f 77 20 2d 20 20 | 74 68 65 20 6e 75 6d 62 |trow - |the numb|
|000023d0| 65 72 20 6f 66 20 74 68 | 65 20 6c 61 73 74 20 72 |er of th|e last r|
|000023e0| 6f 77 20 74 6f 20 63 6f | 70 79 20 28 64 65 66 61 |ow to co|py (defa|
|000023f0| 75 6c 74 20 69 73 20 20 | 74 68 65 0a 20 20 20 20 |ult is |the. |
|00002400| 20 20 20 20 20 20 20 6c | 61 73 74 20 72 6f 77 29 | l|ast row)|
|00002410| 2e 0a 20 20 20 20 20 20 | 20 2d 62 20 62 61 74 63 |.. | -b batc|
|00002420| 68 73 69 7a 65 20 2d 20 | 20 74 68 65 20 6e 75 6d |hsize - | the num|
|00002430| 62 65 72 20 6f 66 20 72 | 6f 77 73 20 70 65 72 20 |ber of r|ows per |
|00002440| 62 61 74 63 68 20 6f 66 | 20 64 61 74 61 20 63 6f |batch of| data co|
|00002450| 70 69 65 64 20 20 28 74 | 68 65 0a 0a 0a 0a 20 20 |pied (t|he.... |
|00002460| 37 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |7 | |
|00002470| 20 20 20 20 20 20 20 20 | 56 65 72 73 69 6f 6e 20 | |Version |
|00002480| 34 2e 30 20 2d 2d 20 31 | 2f 31 35 2f 38 39 20 20 |4.0 -- 1|/15/89 |
|00002490| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000024a0| 20 20 20 62 63 70 0a 20 | 20 5f 5f 5f 5f 5f 5f 5f | bcp. | _______|
|000024b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000024c0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000024d0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000024e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 0a |________|_______.|
|000024f0| 20 20 20 20 20 20 20 20 | 20 20 20 64 65 66 61 75 | | defau|
|00002500| 6c 74 20 69 73 20 74 6f | 20 63 6f 70 79 20 61 6c |lt is to| copy al|
|00002510| 6c 20 74 68 65 20 72 6f | 77 73 20 69 6e 20 6f 6e |l the ro|ws in on|
|00002520| 65 20 62 61 74 63 68 29 | 2e 0a 20 20 20 20 20 20 |e batch)|.. |
|00002530| 20 2d 6e 20 2d 20 20 70 | 65 72 66 6f 72 6d 20 74 | -n - p|erform t|
|00002540| 68 65 20 63 6f 70 79 20 | 6f 70 65 72 61 74 69 6f |he copy |operatio|
|00002550| 6e 20 75 73 69 6e 67 20 | 74 68 65 20 64 61 74 61 |n using |the data|
|00002560| 27 73 20 20 6e 61 74 69 | 76 65 20 20 28 64 61 74 |'s nati|ve (dat|
|00002570| 61 2d 0a 20 20 20 20 20 | 20 20 20 20 20 20 62 61 |a-. | ba|
|00002580| 73 65 29 20 20 64 61 74 | 61 74 79 70 65 73 20 61 |se) dat|atypes a|
|00002590| 73 20 74 68 65 20 64 65 | 66 61 75 6c 74 2e 20 20 |s the de|fault. |
|000025a0| 54 68 69 73 20 6f 70 74 | 69 6f 6e 20 64 6f 65 73 |This opt|ion does|
|000025b0| 20 6e 6f 74 20 70 72 6f | 6d 70 74 0a 20 20 20 20 | not pro|mpt. |
|000025c0| 20 20 20 20 20 20 20 66 | 6f 72 20 65 61 63 68 20 | f|or each |
|000025d0| 66 69 65 6c 64 3b 20 69 | 74 20 75 73 65 73 20 74 |field; i|t uses t|
|000025e0| 68 65 20 64 65 66 61 75 | 6c 74 20 76 61 6c 75 65 |he defau|lt value|
|000025f0| 73 2e 0a 20 20 20 20 20 | 20 20 2d 63 20 2d 20 20 |s.. | -c - |
|00002600| 70 65 72 66 6f 72 6d 20 | 74 68 65 20 63 6f 70 79 |perform |the copy|
|00002610| 20 20 6f 70 65 72 61 74 | 69 6f 6e 20 20 77 69 74 | operat|ion wit|
|00002620| 68 20 20 63 68 61 72 61 | 63 74 65 72 20 20 74 79 |h chara|cter ty|
|00002630| 70 65 20 20 61 73 20 20 | 74 68 65 0a 20 20 20 20 |pe as |the. |
|00002640| 20 20 20 20 20 20 20 64 | 65 66 61 75 6c 74 2e 20 | d|efault. |
|00002650| 20 54 68 69 73 20 6f 70 | 74 69 6f 6e 20 64 6f 65 | This op|tion doe|
|00002660| 73 20 6e 6f 74 20 70 72 | 6f 6d 70 74 20 66 6f 72 |s not pr|ompt for|
|00002670| 20 65 61 63 68 20 66 69 | 65 6c 64 3b 20 69 74 20 | each fi|eld; it |
|00002680| 75 73 65 73 0a 20 20 20 | 20 20 20 20 20 20 20 20 |uses. | |
|00002690| 63 68 61 72 20 61 73 20 | 74 68 65 20 64 65 66 61 |char as |the defa|
|000026a0| 75 6c 74 20 73 74 6f 72 | 61 67 65 20 74 79 70 65 |ult stor|age type|
|000026b0| 2c 20 20 6e 6f 20 20 70 | 72 65 66 69 78 65 73 2c |, no p|refixes,|
|000026c0| 20 20 5c 74 20 20 61 73 | 20 20 74 68 65 0a 20 20 | \t as| the. |
|000026d0| 20 20 20 20 20 20 20 20 | 20 64 65 66 61 75 6c 74 | | default|
|000026e0| 20 20 66 69 65 6c 64 20 | 20 73 65 70 61 72 61 74 | field | separat|
|000026f0| 6f 72 2c 20 61 6e 64 20 | 5c 6e 20 61 73 20 74 68 |or, and |\n as th|
|00002700| 65 20 64 65 66 61 75 6c | 74 20 72 6f 77 20 74 65 |e defaul|t row te|
|00002710| 72 6d 69 6e 61 2d 0a 20 | 20 20 20 20 20 20 20 20 |rmina-. | |
|00002720| 20 20 74 6f 72 2e 0a 20 | 20 20 20 20 20 20 2d 74 | tor.. | -t|
|00002730| 20 66 69 65 6c 64 2d 74 | 65 72 6d 69 6e 61 74 6f | field-t|erminato|
|00002740| 72 20 2d 20 20 73 70 65 | 63 69 66 79 20 74 68 65 |r - spe|cify the|
|00002750| 20 64 65 66 61 75 6c 74 | 20 66 69 65 6c 64 20 74 | default| field t|
|00002760| 65 72 6d 69 6e 61 74 6f | 72 2e 0a 20 20 20 20 20 |erminato|r.. |
|00002770| 20 20 2d 72 20 72 6f 77 | 2d 74 65 72 6d 69 6e 61 | -r row|-termina|
|00002780| 74 6f 72 20 2d 20 20 73 | 70 65 63 69 66 79 20 74 |tor - s|pecify t|
|00002790| 68 65 20 64 65 66 61 75 | 6c 74 20 72 6f 77 20 74 |he defau|lt row t|
|000027a0| 65 72 6d 69 6e 61 74 6f | 72 2e 0a 20 20 20 20 20 |erminato|r.. |
|000027b0| 20 20 2d 55 20 75 73 65 | 72 6e 61 6d 65 20 2d 20 | -U use|rname - |
|000027c0| 20 61 6c 6c 6f 77 73 20 | 74 68 65 20 75 73 65 72 | allows |the user|
|000027d0| 20 74 6f 20 73 70 65 63 | 69 66 79 20 61 20 6c 6f | to spec|ify a lo|
|000027e0| 67 69 6e 20 6e 61 6d 65 | 2e 0a 20 20 20 20 20 20 |gin name|.. |
|000027f0| 20 2d 50 20 70 61 73 73 | 77 6f 72 64 20 2d 20 20 | -P pass|word - |
|00002800| 61 6c 6c 6f 77 73 20 74 | 68 65 20 75 73 65 72 20 |allows t|he user |
|00002810| 74 6f 20 73 70 65 63 69 | 66 79 20 61 20 70 61 73 |to speci|fy a pas|
|00002820| 73 77 6f 72 64 2e 20 20 | 49 66 20 74 68 65 20 20 |sword. |If the |
|00002830| 2d 50 0a 20 20 20 20 20 | 20 20 20 20 20 20 6f 70 |-P. | op|
|00002840| 74 69 6f 6e 20 20 69 73 | 20 20 6e 6f 74 20 67 69 |tion is| not gi|
|00002850| 76 65 6e 2c 20 62 63 70 | 20 70 72 6f 6d 70 74 73 |ven, bcp| prompts|
|00002860| 20 66 6f 72 20 61 20 70 | 61 73 73 77 6f 72 64 2e | for a p|assword.|
|00002870| 20 20 49 66 20 74 68 65 | 20 2d 50 0a 20 20 20 20 | If the| -P. |
|00002880| 20 20 20 20 20 20 20 6f | 70 74 69 6f 6e 20 69 73 | o|ption is|
|00002890| 20 67 69 76 65 6e 20 61 | 74 20 74 68 65 20 65 6e | given a|t the en|
|000028a0| 64 20 6f 66 20 74 68 65 | 20 63 6f 6d 6d 61 6e 64 |d of the| command|
|000028b0| 20 20 6c 69 6e 65 20 20 | 77 69 74 68 6f 75 74 20 | line |without |
|000028c0| 20 61 6e 79 0a 20 20 20 | 20 20 20 20 20 20 20 20 | any. | |
|000028d0| 70 61 73 73 77 6f 72 64 | 2c 20 62 63 70 20 75 73 |password|, bcp us|
|000028e0| 65 73 20 74 68 65 20 64 | 65 66 61 75 6c 74 20 70 |es the d|efault p|
|000028f0| 61 73 73 77 6f 72 64 20 | 28 4e 55 4c 4c 29 2e 0a |assword |(NULL)..|
|00002900| 20 20 20 20 20 20 20 2d | 49 20 69 6e 74 65 72 66 | -|I interf|
|00002910| 61 63 65 20 2d 20 20 61 | 6c 6c 6f 77 73 20 74 68 |ace - a|llows th|
|00002920| 65 20 75 73 65 72 20 74 | 6f 20 73 70 65 63 69 66 |e user t|o specif|
|00002930| 79 20 74 68 65 20 6e 61 | 6d 65 20 61 6e 64 20 20 |y the na|me and |
|00002940| 6c 6f 63 61 74 69 6f 6e | 0a 0a 0a 0a 20 20 62 63 |location|.... bc|
|00002950| 70 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |p | |
|00002960| 20 20 20 20 20 20 56 65 | 72 73 69 6f 6e 20 34 2e | Ve|rsion 4.|
|00002970| 30 20 2d 2d 20 31 2f 31 | 35 2f 38 39 20 20 20 20 |0 -- 1/1|5/89 |
|00002980| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002990| 20 20 20 38 0a 20 20 5f | 5f 5f 5f 5f 5f 5f 5f 5f | 8. _|________|
|000029a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000029b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000029c0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000029d0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 0a 20 20 |________|_____. |
|000029e0| 20 20 20 20 20 20 20 20 | 20 6f 66 20 74 68 65 20 | | of the |
|000029f0| 69 6e 74 65 72 66 61 63 | 65 73 20 66 69 6c 65 20 |interfac|es file |
|00002a00| 74 68 61 74 20 63 61 6e | 20 28 6f 70 74 69 6f 6e |that can| (option|
|00002a10| 61 6c 6c 79 29 20 62 65 | 20 20 73 65 61 72 63 68 |ally) be| search|
|00002a20| 65 64 20 20 61 73 0a 20 | 20 20 20 20 20 20 20 20 |ed as. | |
|00002a30| 20 20 70 61 72 74 20 20 | 6f 66 20 20 74 68 65 20 | part |of the |
|00002a40| 20 70 72 6f 63 65 73 73 | 20 20 6f 66 20 63 6f 6e | process| of con|
|00002a50| 6e 65 63 74 69 6e 67 20 | 74 6f 20 74 68 65 20 53 |necting |to the S|
|00002a60| 51 4c 20 53 65 72 76 65 | 72 2e 20 20 54 68 65 0a |QL Serve|r. The.|
|00002a70| 20 20 20 20 20 20 20 20 | 20 20 20 6e 61 6d 65 64 | | named|
|00002a80| 20 66 69 6c 65 20 63 6f | 6e 74 61 69 6e 73 20 74 | file co|ntains t|
|00002a90| 68 65 20 6e 61 6d 65 20 | 61 6e 64 20 20 6e 65 74 |he name |and net|
|00002aa0| 77 6f 72 6b 20 20 61 64 | 64 72 65 73 73 20 20 6f |work ad|dress o|
|00002ab0| 66 20 20 65 76 65 72 79 | 0a 20 20 20 20 20 20 20 |f every|. |
|00002ac0| 20 20 20 20 61 76 61 69 | 6c 61 62 6c 65 20 20 53 | avai|lable S|
|00002ad0| 51 4c 20 53 65 72 76 65 | 72 20 20 6f 6e 20 74 68 |QL Serve|r on th|
|00002ae0| 65 20 6e 65 74 77 6f 72 | 6b 2e 20 20 49 66 20 74 |e networ|k. If t|
|00002af0| 68 69 73 20 6f 70 74 69 | 6f 6e 20 69 73 20 6e 6f |his opti|on is no|
|00002b00| 74 0a 20 20 20 20 20 20 | 20 20 20 20 20 75 73 65 |t. | use|
|00002b10| 64 2c 20 62 63 70 20 6c | 6f 6f 6b 73 20 66 6f 72 |d, bcp l|ooks for|
|00002b20| 20 61 20 66 69 6c 65 20 | 6e 61 6d 65 64 20 69 6e | a file |named in|
|00002b30| 74 65 72 66 61 63 65 73 | 2e 0a 20 20 20 20 20 20 |terfaces|.. |
|00002b40| 20 2d 53 20 20 73 65 72 | 76 65 72 20 2d 20 20 20 | -S ser|ver - |
|00002b50| 61 6c 6c 6f 77 73 20 20 | 74 68 65 20 20 75 73 65 |allows |the use|
|00002b60| 72 20 20 74 6f 20 20 73 | 70 65 63 69 66 79 20 20 |r to s|pecify |
|00002b70| 74 68 65 20 20 6e 61 6d | 65 20 20 6f 66 20 20 74 |the nam|e of t|
|00002b80| 68 65 0a 20 20 20 20 20 | 20 20 20 20 20 20 53 51 |he. | SQ|
|00002b90| 4c 20 53 65 72 76 65 72 | 20 20 77 69 74 68 20 20 |L Server| with |
|00002ba0| 77 68 69 63 68 20 20 74 | 6f 20 20 63 6f 6e 6e 65 |which t|o conne|
|00002bb0| 63 74 2e 20 20 20 54 68 | 69 73 20 69 73 20 74 68 |ct. Th|is is th|
|00002bc0| 65 20 6e 61 6d 65 20 74 | 68 61 74 0a 20 20 20 20 |e name t|hat. |
|00002bd0| 20 20 20 20 20 20 20 53 | 51 4c 20 53 65 72 76 65 | S|QL Serve|
|00002be0| 72 20 6c 6f 6f 6b 73 20 | 75 70 20 69 6e 20 74 68 |r looks |up in th|
|00002bf0| 65 20 69 6e 74 65 72 66 | 61 63 65 73 20 66 69 6c |e interf|aces fil|
|00002c00| 65 2e 0a 20 20 20 20 20 | 20 20 2d 76 20 2d 20 20 |e.. | -v - |
|00002c10| 72 65 70 6f 72 74 73 20 | 74 68 65 20 63 75 72 72 |reports |the curr|
|00002c20| 65 6e 74 20 76 65 72 73 | 69 6f 6e 20 6f 66 20 74 |ent vers|ion of t|
|00002c30| 68 65 20 62 63 70 20 70 | 72 6f 67 72 61 6d 2e 0a |he bcp p|rogram..|
|00002c40| 0a 20 20 43 4f 4d 4d 45 | 4e 54 53 3a 0a 0a 20 20 |. COMME|NTS:.. |
|00002c50| 20 20 20 20 20 6f 20 54 | 68 65 20 62 63 70 20 62 | o T|he bcp b|
|00002c60| 75 6c 6b 20 63 6f 70 79 | 20 70 72 6f 67 72 61 6d |ulk copy| program|
|00002c70| 20 20 70 72 6f 76 69 64 | 65 73 20 20 61 20 20 63 | provid|es a c|
|00002c80| 6f 6e 76 65 6e 69 65 6e | 74 20 20 6d 65 74 68 6f |onvenien|t metho|
|00002c90| 64 20 20 66 6f 72 0a 20 | 20 20 20 20 20 20 20 20 |d for. | |
|00002ca0| 74 72 61 6e 73 66 65 72 | 72 69 6e 67 20 20 64 61 |transfer|ring da|
|00002cb0| 74 61 20 20 62 65 74 77 | 65 65 6e 20 61 20 64 61 |ta betw|een a da|
|00002cc0| 74 61 62 61 73 65 20 74 | 61 62 6c 65 20 61 6e 64 |tabase t|able and|
|00002cd0| 20 61 20 68 6f 73 74 20 | 66 69 6c 65 20 6f 72 0a | a host |file or.|
|00002ce0| 20 20 20 20 20 20 20 20 | 20 74 61 70 65 2e 20 20 | | tape. |
|00002cf0| 44 61 74 61 20 63 6f 70 | 69 65 64 20 49 4e 20 66 |Data cop|ied IN f|
|00002d00| 72 6f 6d 20 61 20 66 69 | 6c 65 20 69 73 20 61 70 |rom a fi|le is ap|
|00002d10| 70 65 6e 64 65 64 20 20 | 74 6f 20 20 61 6e 20 20 |pended |to an |
|00002d20| 65 78 69 73 74 69 6e 67 | 0a 20 20 20 20 20 20 20 |existing|. |
|00002d30| 20 20 64 61 74 61 62 61 | 73 65 20 74 61 62 6c 65 | databa|se table|
|00002d40| 3b 20 64 61 74 61 20 63 | 6f 70 69 65 64 20 4f 55 |; data c|opied OU|
|00002d50| 54 20 74 6f 20 61 20 66 | 69 6c 65 20 6f 76 65 72 |T to a f|ile over|
|00002d60| 77 72 69 74 65 73 20 61 | 6e 79 20 70 72 65 76 69 |writes a|ny previ|
|00002d70| 2d 0a 20 20 20 20 20 20 | 20 20 20 6f 75 73 20 63 |-. | ous c|
|00002d80| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 74 68 65 20 66 |ontents |of the f|
|00002d90| 69 6c 65 2e 0a 0a 0a 0a | 20 20 39 20 20 20 20 20 |ile.....| 9 |
|00002da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002db0| 20 20 56 65 72 73 69 6f | 6e 20 34 2e 30 20 2d 2d | Versio|n 4.0 --|
|00002dc0| 20 31 2f 31 35 2f 38 39 | 20 20 20 20 20 20 20 20 | 1/15/89| |
|00002dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 62 63 70 | | bcp|
|00002de0| 0a 20 20 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |. _____|________|
|00002df0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002e00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002e10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00002e20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 0a 20 20 20 20 20 20 |________|_. |
|00002e30| 20 6f 20 54 68 65 20 62 | 63 70 20 70 72 6f 67 72 | o The b|cp progr|
|00002e40| 61 6d 20 70 65 72 66 6f | 72 6d 73 20 61 20 68 69 |am perfo|rms a hi|
|00002e50| 67 68 2d 73 70 65 65 64 | 20 20 64 61 74 61 20 20 |gh-speed| data |
|00002e60| 74 72 61 6e 73 66 65 72 | 2e 20 20 20 49 74 20 20 |transfer|. It |
|00002e70| 69 73 0a 20 20 20 20 20 | 20 20 20 20 63 61 70 61 |is. | capa|
|00002e80| 62 6c 65 20 20 6f 66 20 | 20 72 65 61 64 69 6e 67 |ble of | reading|
|00002e90| 20 6f 72 20 77 72 69 74 | 69 6e 67 20 66 69 6c 65 | or writ|ing file|
|00002ea0| 73 20 69 6e 20 61 20 77 | 69 64 65 20 76 61 72 69 |s in a w|ide vari|
|00002eb0| 65 74 79 20 6f 66 20 66 | 6f 72 2d 0a 20 20 20 20 |ety of f|or-. |
|00002ec0| 20 20 20 20 20 6d 61 74 | 73 2e 0a 0a 20 20 20 20 | mat|s... |
|00002ed0| 20 20 20 6f 20 54 68 65 | 20 2d 6e 20 28 6e 61 74 | o The| -n (nat|
|00002ee0| 69 76 65 20 66 6f 72 6d | 61 74 29 20 61 6e 64 20 |ive form|at) and |
|00002ef0| 2d 63 20 28 63 68 61 72 | 61 63 74 65 72 20 66 6f |-c (char|acter fo|
|00002f00| 72 6d 61 74 29 20 20 63 | 6f 6d 6d 61 6e 64 20 20 |rmat) c|ommand |
|00002f10| 6c 69 6e 65 0a 20 20 20 | 20 20 20 20 20 20 6f 70 |line. | op|
|00002f20| 74 69 6f 6e 73 20 20 65 | 61 63 68 20 20 70 72 6f |tions e|ach pro|
|00002f30| 76 69 64 65 20 20 73 70 | 65 63 69 66 69 63 20 20 |vide sp|ecific |
|00002f40| 64 65 66 61 75 6c 74 20 | 20 66 6f 72 6d 61 74 73 |default | formats|
|00002f50| 20 66 6f 72 20 74 68 65 | 20 64 61 74 61 0a 20 20 | for the| data. |
|00002f60| 20 20 20 20 20 20 20 62 | 65 69 6e 67 20 63 6f 70 | b|eing cop|
|00002f70| 69 65 64 2e 20 20 4e 61 | 74 69 76 65 20 66 6f 72 |ied. Na|tive for|
|00002f80| 6d 61 74 20 70 72 6f 76 | 69 64 65 73 20 74 68 65 |mat prov|ides the|
|00002f90| 20 6d 6f 73 74 20 63 6f | 6d 70 61 63 74 20 73 74 | most co|mpact st|
|00002fa0| 6f 72 61 67 65 3b 0a 20 | 20 20 20 20 20 20 20 20 |orage;. | |
|00002fb0| 63 68 61 72 61 63 74 65 | 72 20 20 20 66 6f 72 6d |characte|r form|
|00002fc0| 61 74 20 20 63 72 65 61 | 74 65 73 20 20 41 53 43 |at crea|tes ASC|
|00002fd0| 49 49 20 20 66 69 6c 65 | 73 2c 20 20 77 69 74 68 |II file|s, with|
|00002fe0| 20 20 74 61 62 73 20 20 | 62 65 74 77 65 65 6e 0a | tabs |between.|
|00002ff0| 20 20 20 20 20 20 20 20 | 20 63 6f 6c 75 6d 6e 73 | | columns|
|00003000| 2e 0a 20 20 20 20 20 20 | 20 6f 20 57 68 65 6e 20 |.. | o When |
|00003010| 6e 65 69 74 68 65 72 20 | 6f 66 20 74 68 65 20 2d |neither |of the -|
|00003020| 6e 20 6f 72 20 2d 63 20 | 6f 70 74 69 6f 6e 20 69 |n or -c |option i|
|00003030| 73 20 75 73 65 64 2c 20 | 62 63 70 20 77 69 6c 6c |s used, |bcp will|
|00003040| 20 71 75 65 72 79 20 74 | 68 65 0a 20 20 20 20 20 | query t|he. |
|00003050| 20 20 20 20 75 73 65 72 | 20 20 66 6f 72 20 20 69 | user| for i|
|00003060| 6e 66 6f 72 6d 61 74 69 | 6f 6e 20 20 61 62 6f 75 |nformati|on abou|
|00003070| 74 20 20 65 61 63 68 20 | 20 63 6f 6c 75 6d 6e 20 |t each | column |
|00003080| 20 69 6e 20 74 68 65 20 | 74 61 62 6c 65 20 74 6f | in the |table to|
|00003090| 20 62 65 0a 20 20 20 20 | 20 20 20 20 20 63 6f 70 | be. | cop|
|000030a0| 69 65 64 20 61 6e 64 20 | 61 73 6b 73 20 77 68 65 |ied and |asks whe|
|000030b0| 74 68 65 72 20 79 6f 75 | 20 77 61 6e 74 20 74 6f |ther you| want to|
|000030c0| 20 73 61 76 65 20 79 6f | 75 72 20 20 66 6f 72 6d | save yo|ur form|
|000030d0| 61 74 20 20 69 6e 66 6f | 72 6d 61 2d 0a 20 20 20 |at info|rma-. |
|000030e0| 20 20 20 20 20 20 74 69 | 6f 6e 20 69 6e 20 61 20 | ti|on in a |
|000030f0| 66 69 6c 65 2e 0a 0a 20 | 20 20 20 20 20 20 6f 20 |file... | o |
|00003100| 55 70 6f 6e 20 63 6f 6d | 70 6c 65 74 69 6f 6e 2c |Upon com|pletion,|
|00003110| 20 62 63 70 20 69 6e 66 | 6f 72 6d 73 20 79 6f 75 | bcp inf|orms you|
|00003120| 20 6f 66 20 74 68 65 20 | 6e 75 6d 62 65 72 20 6f | of the |number o|
|00003130| 66 20 72 6f 77 73 20 6f | 66 20 20 64 61 74 61 0a |f rows o|f data.|
|00003140| 20 20 20 20 20 20 20 20 | 20 73 75 63 63 65 73 73 | | success|
|00003150| 66 75 6c 6c 79 20 20 63 | 6f 70 69 65 64 2c 20 74 |fully c|opied, t|
|00003160| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 72 6f 77 |he numbe|r of row|
|00003170| 73 20 28 69 66 20 61 6e | 79 29 20 74 68 61 74 20 |s (if an|y) that |
|00003180| 69 74 20 63 6f 75 6c 64 | 0a 20 20 20 20 20 20 20 |it could|. |
|00003190| 20 20 6e 6f 74 20 63 6f | 70 79 2c 20 74 68 65 20 | not co|py, the |
|000031a0| 74 6f 74 61 6c 20 74 69 | 6d 65 20 74 68 65 20 63 |total ti|me the c|
|000031b0| 6f 70 79 20 74 6f 6f 6b | 2c 20 74 68 65 20 61 76 |opy took|, the av|
|000031c0| 65 72 61 67 65 20 20 61 | 6d 6f 75 6e 74 20 20 6f |erage a|mount o|
|000031d0| 66 0a 20 20 20 20 20 20 | 20 20 20 74 69 6d 65 20 |f. | time |
|000031e0| 20 69 74 20 20 74 6f 6f | 6b 20 74 6f 20 63 6f 70 | it too|k to cop|
|000031f0| 79 20 6f 6e 65 20 72 6f | 77 20 28 67 69 76 65 6e |y one ro|w (given|
|00003200| 20 69 6e 20 6d 69 6c 6c | 69 73 65 63 6f 6e 64 73 | in mill|iseconds|
|00003210| 29 2c 20 61 6e 64 20 74 | 68 65 0a 0a 0a 20 20 62 |), and t|he... b|
|00003220| 63 70 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |cp | |
|00003230| 20 20 20 20 20 20 20 56 | 65 72 73 69 6f 6e 20 34 | V|ersion 4|
|00003240| 2e 30 20 2d 2d 20 31 2f | 31 35 2f 38 39 20 20 20 |.0 -- 1/|15/89 |
|00003250| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003260| 20 20 20 31 30 0a 20 20 | 5f 5f 5f 5f 5f 5f 5f 5f | 10. |________|
|00003270| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003280| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003290| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000032a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 0a 20 |________|______. |
|000032b0| 20 20 20 20 20 20 20 20 | 6e 75 6d 62 65 72 20 6f | |number o|
|000032c0| 66 20 72 6f 77 73 20 63 | 6f 70 69 65 64 20 70 65 |f rows c|opied pe|
|000032d0| 72 20 73 65 63 6f 6e 64 | 2e 0a 0a 20 20 20 20 20 |r second|... |
|000032e0| 20 20 6f 20 49 6e 20 6f | 72 64 65 72 20 74 6f 20 | o In o|rder to |
|000032f0| 75 73 65 20 62 63 70 2c | 20 79 6f 75 20 6d 75 73 |use bcp,| you mus|
|00003300| 74 20 68 61 76 65 20 61 | 20 76 61 6c 69 64 20 20 |t have a| valid |
|00003310| 53 51 4c 20 53 65 72 76 | 65 72 20 20 61 63 63 6f |SQL Serv|er acco|
|00003320| 75 6e 74 0a 20 20 20 20 | 20 20 20 20 20 61 6e 64 |unt. | and|
|00003330| 20 20 74 68 65 20 20 61 | 70 70 72 6f 70 72 69 61 | the a|ppropria|
|00003340| 74 65 20 20 70 65 72 6d | 69 73 73 69 6f 6e 73 20 |te perm|issions |
|00003350| 20 6f 6e 20 20 74 68 65 | 20 64 61 74 61 62 61 73 | on the| databas|
|00003360| 65 20 74 61 62 6c 65 73 | 20 61 6e 64 0a 20 20 20 |e tables| and. |
|00003370| 20 20 20 20 20 20 66 69 | 6c 65 73 2e 0a 20 20 20 | fi|les.. |
|00003380| 20 20 20 20 6f 20 54 68 | 65 20 62 63 70 20 70 72 | o Th|e bcp pr|
|00003390| 6f 67 72 61 6d 20 69 73 | 20 6f 70 74 69 6d 69 7a |ogram is| optimiz|
|000033a0| 65 64 20 74 6f 20 6c 6f | 61 64 20 64 61 74 61 20 |ed to lo|ad data |
|000033b0| 69 6e 74 6f 20 74 61 62 | 6c 65 73 20 20 74 68 61 |into tab|les tha|
|000033c0| 74 20 20 64 6f 0a 20 20 | 20 20 20 20 20 20 20 6e |t do. | n|
|000033d0| 6f 74 20 68 61 76 65 20 | 69 6e 64 65 78 65 73 20 |ot have |indexes |
|000033e0| 61 73 73 6f 63 69 61 74 | 65 64 20 77 69 74 68 20 |associat|ed with |
|000033f0| 74 68 65 6d 2e 20 20 57 | 68 65 6e 20 79 6f 75 20 |them. W|hen you |
|00003400| 63 6f 70 79 20 64 61 74 | 61 20 69 6e 74 6f 0a 20 |copy dat|a into. |
|00003410| 20 20 20 20 20 20 20 20 | 61 20 74 61 62 6c 65 20 | |a table |
|00003420| 74 68 61 74 20 64 6f 65 | 73 20 68 61 76 65 20 6f |that doe|s have o|
|00003430| 6e 65 20 6f 72 20 6d 6f | 72 65 20 69 6e 64 65 78 |ne or mo|re index|
|00003440| 65 73 2c 20 61 20 73 6c | 6f 77 65 72 20 76 65 72 |es, a sl|ower ver|
|00003450| 73 69 6f 6e 20 6f 66 0a | 20 20 20 20 20 20 20 20 |sion of.| |
|00003460| 20 62 63 70 20 69 73 20 | 61 75 74 6f 6d 61 74 69 | bcp is |automati|
|00003470| 63 61 6c 6c 79 20 75 73 | 65 64 2e 0a 0a 20 20 20 |cally us|ed... |
|00003480| 20 20 20 20 20 20 48 6f | 77 65 76 65 72 2c 20 74 | Ho|wever, t|
|00003490| 68 65 20 66 61 73 74 20 | 76 65 72 73 69 6f 6e 20 |he fast |version |
|000034a0| 6f 66 20 62 63 70 20 69 | 6e 73 65 72 74 73 20 64 |of bcp i|nserts d|
|000034b0| 61 74 61 20 20 77 69 74 | 68 6f 75 74 20 20 6c 6f |ata wit|hout lo|
|000034c0| 67 67 69 6e 67 0a 20 20 | 20 20 20 20 20 20 20 69 |gging. | i|
|000034d0| 74 2c 20 20 61 6e 64 20 | 72 65 71 75 69 72 65 73 |t, and |requires|
|000034e0| 20 74 68 65 20 53 79 73 | 74 65 6d 20 41 64 6d 69 | the Sys|tem Admi|
|000034f0| 6e 69 73 74 72 61 74 6f | 72 20 6f 72 20 44 61 74 |nistrato|r or Dat|
|00003500| 61 62 61 73 65 20 4f 77 | 6e 65 72 20 74 6f 0a 20 |abase Ow|ner to. |
|00003510| 20 20 20 20 20 20 20 20 | 66 69 72 73 74 20 20 73 | |first s|
|00003520| 65 74 20 20 74 68 65 20 | 20 73 65 6c 65 63 74 20 |et the | select |
|00003530| 20 69 6e 74 6f 2f 62 75 | 6c 6b 63 6f 70 79 20 20 | into/bu|lkcopy |
|00003540| 6f 70 74 69 6f 6e 20 20 | 6f 6e 20 20 20 77 69 74 |option |on wit|
|00003550| 68 20 20 20 74 68 65 0a | 20 20 20 20 20 20 20 20 |h the.| |
|00003560| 20 73 70 5f 64 62 6f 70 | 74 69 6f 6e 20 20 70 72 | sp_dbop|tion pr|
|00003570| 6f 63 65 64 75 72 65 2e | 20 20 49 66 20 74 68 65 |ocedure.| If the|
|00003580| 20 6f 70 74 69 6f 6e 20 | 69 73 20 6e 6f 74 20 73 | option |is not s|
|00003590| 65 74 20 6f 6e 20 61 6e | 64 20 61 20 75 73 65 72 |et on an|d a user|
|000035a0| 0a 20 20 20 20 20 20 20 | 20 20 74 72 69 65 73 20 |. | tries |
|000035b0| 74 6f 20 63 6f 70 79 20 | 64 61 74 61 20 69 6e 74 |to copy |data int|
|000035c0| 6f 20 61 20 74 61 62 6c | 65 20 74 68 61 74 20 68 |o a tabl|e that h|
|000035d0| 61 73 20 6e 6f 20 69 6e | 64 65 78 65 73 2c 20 53 |as no in|dexes, S|
|000035e0| 51 4c 20 53 65 72 76 65 | 72 0a 20 20 20 20 20 20 |QL Serve|r. |
|000035f0| 20 20 20 67 65 6e 65 72 | 61 74 65 73 20 20 61 6e | gener|ates an|
|00003600| 20 65 72 72 6f 72 20 6d | 65 73 73 61 67 65 2e 20 | error m|essage. |
|00003610| 20 59 6f 75 20 64 6f 6e | 27 74 20 6e 65 65 64 20 | You don|'t need |
|00003620| 74 6f 20 73 65 74 20 74 | 68 69 73 20 6f 70 74 69 |to set t|his opti|
|00003630| 6f 6e 0a 20 20 20 20 20 | 20 20 20 20 69 6e 20 6f |on. | in o|
|00003640| 72 64 65 72 20 74 6f 20 | 63 6f 70 79 20 64 61 74 |rder to |copy dat|
|00003650| 61 20 6f 75 74 20 74 6f | 20 61 20 66 69 6c 65 2c |a out to| a file,|
|00003660| 20 6f 72 20 69 6e 20 6f | 72 64 65 72 20 74 6f 20 | or in o|rder to |
|00003670| 20 63 6f 70 79 20 20 64 | 61 74 61 0a 0a 0a 0a 20 | copy d|ata.... |
|00003680| 20 31 31 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | 11 | |
|00003690| 20 20 20 20 20 20 20 20 | 20 56 65 72 73 69 6f 6e | | Version|
|000036a0| 20 34 2e 30 20 2d 2d 20 | 31 2f 31 35 2f 38 39 20 | 4.0 -- |1/15/89 |
|000036b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000036c0| 20 20 20 20 62 63 70 0a | 20 20 5f 5f 5f 5f 5f 5f | bcp.| ______|
|000036d0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000036e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000036f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003700| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003710| 0a 20 20 20 20 20 20 20 | 20 20 69 6e 20 74 6f 20 |. | in to |
|00003720| 61 20 74 61 62 6c 65 20 | 74 68 61 74 20 64 6f 65 |a table |that doe|
|00003730| 73 20 68 61 76 65 20 69 | 6e 64 65 78 65 73 2e 20 |s have i|ndexes. |
|00003740| 20 41 20 62 75 6c 6b 20 | 63 6f 70 79 20 69 6e 20 | A bulk |copy in |
|00003750| 74 6f 20 74 61 62 6c 65 | 73 0a 20 20 20 20 20 20 |to table|s. |
|00003760| 20 20 20 74 68 61 74 20 | 20 68 61 76 65 20 20 69 | that | have i|
|00003770| 6e 64 65 78 65 73 20 20 | 61 6c 77 61 79 73 20 75 |ndexes |always u|
|00003780| 73 65 73 20 74 68 65 20 | 73 6c 6f 77 65 72 20 76 |ses the |slower v|
|00003790| 65 72 73 69 6f 6e 20 6f | 66 20 62 63 70 2c 20 61 |ersion o|f bcp, a|
|000037a0| 6e 64 0a 20 20 20 20 20 | 20 20 20 20 72 6f 77 20 |nd. | row |
|000037b0| 69 6e 73 65 72 74 73 20 | 61 72 65 20 6c 6f 67 67 |inserts |are logg|
|000037c0| 65 64 2e 0a 0a 0a 20 20 | 20 20 20 20 20 20 20 57 |ed.... | W|
|000037d0| 41 52 4e 49 4e 47 20 20 | 5f 5f 5f 5f 5f 5f 5f 5f |ARNING |________|
|000037e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000037f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003800| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003810| 0a 20 20 20 20 20 20 20 | 20 20 7c 20 20 20 20 20 |. | | |
|00003820| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003830| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003840| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003850| 20 20 20 20 20 20 20 20 | 20 20 7c 0a 20 20 20 20 | | |. |
|00003860| 20 20 20 20 20 7c 20 20 | 42 65 63 61 75 73 65 20 | | |Because |
|00003870| 62 75 6c 6b 20 63 6f 70 | 79 20 6c 6f 67 73 20 69 |bulk cop|y logs i|
|00003880| 6e 73 65 72 74 73 20 20 | 69 6e 74 6f 20 20 61 20 |nserts |into a |
|00003890| 20 74 61 62 6c 65 20 20 | 74 68 61 74 20 20 68 61 | table |that ha|
|000038a0| 73 20 20 20 20 7c 0a 20 | 20 20 20 20 20 20 20 20 |s |. | |
|000038b0| 7c 20 20 69 6e 64 65 78 | 65 73 2c 20 20 74 68 65 || index|es, the|
|000038c0| 20 20 6c 6f 67 20 63 61 | 6e 20 67 72 6f 77 20 76 | log ca|n grow v|
|000038d0| 65 72 79 20 6c 61 72 67 | 65 2e 20 20 59 6f 75 20 |ery larg|e. You |
|000038e0| 63 61 6e 20 74 72 75 6e | 63 61 74 65 20 20 20 20 |can trun|cate |
|000038f0| 7c 0a 20 20 20 20 20 20 | 20 20 20 7c 20 20 74 68 ||. | | th|
|00003900| 65 20 6c 6f 67 20 77 69 | 74 68 20 44 55 4d 50 20 |e log wi|th DUMP |
|00003910| 54 52 41 4e 73 61 63 74 | 69 6f 6e 20 61 66 74 65 |TRANsact|ion afte|
|00003920| 72 20 74 68 65 20 20 62 | 75 6c 6b 20 20 63 6f 70 |r the b|ulk cop|
|00003930| 79 20 20 63 6f 6d 2d 20 | 20 20 20 7c 0a 20 20 20 |y com- | |. |
|00003940| 20 20 20 20 20 20 7c 20 | 20 70 6c 65 74 65 73 2c | | | pletes,|
|00003950| 20 20 61 66 74 65 72 20 | 79 6f 75 20 68 61 76 65 | after |you have|
|00003960| 20 62 61 63 6b 65 64 20 | 75 70 20 79 6f 75 72 20 | backed |up your |
|00003970| 64 61 74 61 62 61 73 65 | 20 77 69 74 68 20 44 55 |database| with DU|
|00003980| 4d 50 20 20 20 20 7c 0a | 20 20 20 20 20 20 20 20 |MP |.| |
|00003990| 20 7c 20 20 44 41 54 41 | 42 41 53 45 2e 20 20 20 | | DATA|BASE. |
|000039a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000039b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000039c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000039d0| 20 7c 0a 20 20 20 20 20 | 20 20 20 20 7c 5f 5f 5f | |. | |___|
|000039e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000039f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003a00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003a10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 7c 0a 0a 0a |________|____|...|
|00003a20| 20 20 20 20 57 68 69 6c | 65 20 20 74 68 65 20 73 | Whil|e the s|
|00003a30| 65 6c 65 63 74 20 69 6e | 74 6f 2f 62 75 6c 6b 63 |elect in|to/bulkc|
|00003a40| 6f 70 79 20 6f 70 74 69 | 6f 6e 20 69 73 20 6f 6e |opy opti|on is on|
|00003a50| 2c 20 79 6f 75 20 61 72 | 65 20 6e 6f 74 20 61 6c |, you ar|e not al|
|00003a60| 6c 6f 77 65 64 20 74 6f | 0a 20 20 20 20 64 75 6d |lowed to|. dum|
|00003a70| 70 20 74 68 65 20 74 72 | 61 6e 73 61 63 74 69 6f |p the tr|ansactio|
|00003a80| 6e 20 6c 6f 67 2e 20 20 | 49 73 73 75 69 6e 67 20 |n log. |Issuing |
|00003a90| 74 68 65 20 20 44 55 4d | 50 20 20 54 52 41 4e 73 |the DUM|P TRANs|
|00003aa0| 61 63 74 69 6f 6e 20 20 | 73 74 61 74 65 6d 65 6e |action |statemen|
|00003ab0| 74 0a 20 20 20 20 70 72 | 6f 64 75 63 65 73 20 20 |t. pr|oduces |
|00003ac0| 61 6e 20 20 65 72 72 6f | 72 20 20 6d 65 73 73 61 |an erro|r messa|
|00003ad0| 67 65 20 20 69 6e 73 74 | 72 75 63 74 69 6e 67 20 |ge inst|ructing |
|00003ae0| 20 79 6f 75 20 20 74 6f | 20 75 73 65 20 44 55 4d | you to| use DUM|
|00003af0| 50 20 44 41 54 41 42 41 | 53 45 0a 0a 0a 20 20 62 |P DATABA|SE... b|
|00003b00| 63 70 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |cp | |
|00003b10| 20 20 20 20 20 20 20 56 | 65 72 73 69 6f 6e 20 34 | V|ersion 4|
|00003b20| 2e 30 20 2d 2d 20 31 2f | 31 35 2f 38 39 20 20 20 |.0 -- 1/|15/89 |
|00003b30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b40| 20 20 20 31 32 0a 20 20 | 5f 5f 5f 5f 5f 5f 5f 5f | 12. |________|
|00003b50| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003b60| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003b70| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003b80| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 0a 20 |________|______. |
|00003b90| 20 20 20 69 6e 73 74 65 | 61 64 2e 0a 0a 20 20 20 | inste|ad... |
|00003ba0| 20 54 68 69 73 20 74 61 | 62 6c 65 20 73 68 6f 77 | This ta|ble show|
|00003bb0| 73 20 77 68 69 63 68 20 | 76 65 72 73 69 6f 6e 20 |s which |version |
|00003bc0| 6f 66 20 62 63 70 20 77 | 69 6c 6c 20 62 65 20 75 |of bcp w|ill be u|
|00003bd0| 73 65 64 20 77 68 65 6e | 20 63 6f 70 79 69 6e 67 |sed when| copying|
|00003be0| 20 20 49 4e 2c 0a 20 20 | 20 20 74 68 65 20 20 6e | IN,. | the n|
|00003bf0| 65 63 65 73 73 61 72 79 | 20 20 73 65 74 74 69 6e |ecessary| settin|
|00003c00| 67 73 20 20 66 6f 72 20 | 20 74 68 65 20 20 73 65 |gs for | the se|
|00003c10| 6c 65 63 74 20 69 6e 74 | 6f 2f 62 75 6c 6b 63 6f |lect int|o/bulkco|
|00003c20| 70 79 20 6f 70 74 69 6f | 6e 2c 20 61 6e 64 0a 20 |py optio|n, and. |
|00003c30| 20 20 20 77 68 65 74 68 | 65 72 20 74 68 65 20 74 | wheth|er the t|
|00003c40| 72 61 6e 73 61 63 74 69 | 6f 6e 20 6c 6f 67 20 69 |ransacti|on log i|
|00003c50| 73 20 6b 65 70 74 20 61 | 6e 64 20 64 75 6d 70 61 |s kept a|nd dumpa|
|00003c60| 62 6c 65 2e 0a 0a 20 20 | 20 20 20 20 20 20 20 20 |ble... | |
|00003c70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003c90| 20 73 65 6c 65 63 74 20 | 69 6e 74 6f 2f 62 75 6c | select |into/bul|
|00003ca0| 6b 63 6f 70 79 0a 20 20 | 20 20 20 20 20 20 20 20 |kcopy. | |
|00003cb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003cc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003cd0| 20 20 20 4f 4e 20 20 20 | 20 20 20 20 20 20 20 20 | ON | |
|00003ce0| 20 20 20 20 20 4f 46 46 | 0a 20 20 20 20 20 20 20 | OFF|. |
|00003cf0| 20 20 20 20 20 20 20 20 | 66 61 73 74 20 62 63 70 | |fast bcp|
|00003d00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003d10| 20 20 20 20 20 20 4f 4b | 0a 20 20 20 20 20 28 6e | OK|. (n|
|00003d20| 6f 20 69 6e 64 65 78 65 | 73 20 6f 6e 20 74 61 72 |o indexe|s on tar|
|00003d30| 67 65 74 20 74 61 62 6c | 65 29 20 20 20 44 55 4d |get tabl|e) DUM|
|00003d40| 50 20 54 52 41 4e 20 70 | 72 6f 68 69 62 69 74 65 |P TRAN p|rohibite|
|00003d50| 64 20 20 20 20 70 72 6f | 68 69 62 69 74 65 64 0a |d pro|hibited.|
|00003d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 73 | | s|
|00003d70| 6c 6f 77 20 62 63 70 20 | 20 20 20 20 20 20 20 20 |low bcp | |
|00003d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 4f 4b 20 | | OK |
|00003d90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003da0| 4f 4b 0a 20 20 20 20 20 | 20 20 20 28 6f 6e 65 20 |OK. | (one |
|00003db0| 6f 72 20 6d 6f 72 65 20 | 69 6e 64 65 78 65 73 29 |or more |indexes)|
|00003dc0| 20 20 20 20 20 20 20 44 | 55 4d 50 20 54 52 41 4e | D|UMP TRAN|
|00003dd0| 20 70 72 6f 68 69 62 69 | 74 65 64 20 20 20 44 55 | prohibi|ted DU|
|00003de0| 4d 50 20 54 52 41 4e 20 | 4f 4b 0a 0a 20 20 20 20 |MP TRAN |OK.. |
|00003df0| 42 79 20 64 65 66 61 75 | 6c 74 2c 20 74 68 65 20 |By defau|lt, the |
|00003e00| 73 65 6c 65 63 74 20 69 | 6e 74 6f 2f 62 75 6c 6b |select i|nto/bulk|
|00003e10| 63 6f 70 79 20 6f 70 74 | 69 6f 6e 20 69 73 20 6f |copy opt|ion is o|
|00003e20| 66 66 20 69 6e 20 6e 65 | 77 6c 79 20 20 63 72 65 |ff in ne|wly cre|
|00003e30| 61 74 65 64 0a 20 20 20 | 20 64 61 74 61 62 61 73 |ated. | databas|
|00003e40| 65 73 2e 20 20 20 54 6f | 20 63 68 61 6e 67 65 20 |es. To| change |
|00003e50| 74 68 65 20 64 65 66 61 | 75 6c 74 20 73 69 74 75 |the defa|ult situ|
|00003e60| 61 74 69 6f 6e 2c 20 74 | 75 72 6e 20 74 68 69 73 |ation, t|urn this|
|00003e70| 20 6f 70 74 69 6f 6e 20 | 6f 6e 20 69 6e 0a 20 20 | option |on in. |
|00003e80| 20 20 74 68 65 20 4d 6f | 64 65 6c 20 44 61 74 61 | the Mo|del Data|
|00003e90| 62 61 73 65 2e 0a 0a 0a | 0a 0a 20 20 31 33 20 20 |base....|.. 13 |
|00003ea0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003eb0| 20 20 20 20 56 65 72 73 | 69 6f 6e 20 34 2e 30 20 | Vers|ion 4.0 |
|00003ec0| 2d 2d 20 31 2f 31 35 2f | 38 39 20 20 20 20 20 20 |-- 1/15/|89 |
|00003ed0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 62 | | b|
|00003ee0| 63 70 0a 20 20 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |cp. ___|________|
|00003ef0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003f00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003f10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003f20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 0a 20 20 20 20 |________|___. |
|00003f30| 54 68 65 20 70 65 72 66 | 6f 72 6d 61 6e 63 65 20 |The perf|ormance |
|00003f40| 70 65 6e 61 6c 74 79 20 | 66 6f 72 20 63 6f 70 79 |penalty |for copy|
|00003f50| 69 6e 67 20 20 64 61 74 | 61 20 20 69 6e 74 6f 20 |ing dat|a into |
|00003f60| 20 61 20 20 74 61 62 6c | 65 20 20 74 68 61 74 20 | a tabl|e that |
|00003f70| 20 68 61 73 0a 20 20 20 | 20 69 6e 64 65 78 65 73 | has. | indexes|
|00003f80| 20 20 69 6e 20 20 70 6c | 61 63 65 20 20 6d 61 79 | in pl|ace may|
|00003f90| 20 20 62 65 20 73 65 76 | 65 72 65 2e 20 20 49 66 | be sev|ere. If|
|00003fa0| 20 79 6f 75 20 61 72 65 | 20 63 6f 70 79 69 6e 67 | you are| copying|
|00003fb0| 20 69 6e 20 64 61 74 61 | 20 74 68 61 74 0a 20 20 | in data| that. |
|00003fc0| 20 20 77 69 6c 6c 20 69 | 6e 63 72 65 61 73 65 20 | will i|ncrease |
|00003fd0| 74 68 65 20 73 69 7a 65 | 20 6f 66 20 74 68 65 20 |the size| of the |
|00003fe0| 74 61 62 6c 65 20 62 79 | 20 32 35 25 2c 20 69 74 |table by| 25%, it|
|00003ff0| 20 6d 61 79 20 62 65 20 | 66 61 73 74 65 72 20 74 | may be |faster t|
|00004000| 6f 20 64 72 6f 70 0a 20 | 20 20 20 61 6c 6c 20 20 |o drop. | all |
|00004010| 74 68 65 20 20 69 6e 64 | 65 78 65 73 20 62 65 66 |the ind|exes bef|
|00004020| 6f 72 65 68 61 6e 64 20 | 77 69 74 68 20 44 52 4f |orehand |with DRO|
|00004030| 50 20 49 4e 44 45 58 2c | 20 63 6f 70 79 20 74 68 |P INDEX,| copy th|
|00004040| 65 20 64 61 74 61 20 69 | 6e 74 6f 20 74 68 65 0a |e data i|nto the.|
|00004050| 20 20 20 20 74 61 62 6c | 65 2c 20 61 6e 64 20 74 | tabl|e, and t|
|00004060| 68 65 6e 20 72 65 63 72 | 65 61 74 65 20 74 68 65 |hen recr|eate the|
|00004070| 20 69 6e 64 65 78 65 73 | 2e 0a 0a 0a 20 20 20 20 | indexes|.... |
|00004080| 57 41 52 4e 49 4e 47 20 | 20 5f 5f 5f 5f 5f 5f 5f |WARNING | _______|
|00004090| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000040a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000040b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000040c0| 5f 5f 5f 5f 5f 5f 0a 20 | 20 20 20 7c 20 20 20 20 |______. | | |
|000040d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000040f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004100| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004110| 7c 0a 20 20 20 20 7c 20 | 20 59 6f 75 72 20 64 61 ||. | | Your da|
|00004120| 74 61 62 61 73 65 20 6d | 75 73 74 20 68 61 76 65 |tabase m|ust have|
|00004130| 20 66 72 65 65 20 73 70 | 61 63 65 20 65 71 75 61 | free sp|ace equa|
|00004140| 6c 20 74 6f 20 61 74 20 | 6c 65 61 73 74 20 20 31 |l to at |least 1|
|00004150| 32 30 25 20 20 6f 66 20 | 20 20 20 7c 0a 20 20 20 |20% of | |. |
|00004160| 20 7c 20 20 74 68 65 20 | 73 69 7a 65 20 6f 66 20 | | the |size of |
|00004170| 74 68 65 20 74 61 62 6c | 65 20 69 6e 20 6f 72 64 |the tabl|e in ord|
|00004180| 65 72 20 74 6f 20 62 75 | 69 6c 64 20 6f 72 20 72 |er to bu|ild or r|
|00004190| 65 62 75 69 6c 64 20 61 | 20 63 6c 75 73 74 65 72 |ebuild a| cluster|
|000041a0| 65 64 20 20 20 20 7c 0a | 20 20 20 20 7c 20 20 69 |ed |.| | i|
|000041b0| 6e 64 65 78 2e 20 20 20 | 20 20 20 20 20 20 20 20 |ndex. | |
|000041c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000041d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000041e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000041f0| 20 7c 0a 20 20 20 20 7c | 5f 5f 5f 5f 5f 5f 5f 5f | |. ||________|
|00004200| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004210| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004220| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004230| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 7c 0a 0a 0a |________|____|...|
|00004240| 20 20 6f 20 57 68 65 6e | 20 20 75 73 69 6e 67 20 | o When| using |
|00004250| 20 62 63 70 2c 20 74 68 | 65 20 75 73 65 72 20 69 | bcp, th|e user i|
|00004260| 73 20 70 72 6f 6d 70 74 | 65 64 20 66 6f 72 20 61 |s prompt|ed for a|
|00004270| 20 70 61 73 73 77 6f 72 | 64 2c 20 69 66 20 69 74 | passwor|d, if it|
|00004280| 20 77 61 73 20 6e 6f 74 | 0a 20 20 20 20 73 75 70 | was not|. sup|
|00004290| 70 6c 69 65 64 20 77 69 | 74 68 20 74 68 65 20 2d |plied wi|th the -|
|000042a0| 50 20 6f 70 74 69 6f 6e | 2e 0a 0a 0a 0a 20 20 62 |P option|..... b|
|000042b0| 63 70 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |cp | |
|000042c0| 20 20 20 20 20 20 20 56 | 65 72 73 69 6f 6e 20 34 | V|ersion 4|
|000042d0| 2e 30 20 2d 2d 20 31 2f | 31 35 2f 38 39 20 20 20 |.0 -- 1/|15/89 |
|000042e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000042f0| 20 20 20 31 34 0a 20 20 | 5f 5f 5f 5f 5f 5f 5f 5f | 14. |________|
|00004300| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004310| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004320| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004330| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 0a 20 |________|______. |
|00004340| 20 6f 20 41 66 74 65 72 | 20 74 68 65 20 70 61 73 | o After| the pas|
|00004350| 73 77 6f 72 64 20 68 61 | 73 20 62 65 65 6e 20 67 |sword ha|s been g|
|00004360| 69 76 65 6e 2c 20 62 63 | 70 20 70 72 6f 6d 70 74 |iven, bc|p prompt|
|00004370| 73 20 20 66 6f 72 20 20 | 69 6e 66 6f 72 6d 61 74 |s for |informat|
|00004380| 69 6f 6e 20 20 6f 6e 0a | 20 20 20 20 65 61 63 68 |ion on.| each|
|00004390| 20 20 66 69 65 6c 64 20 | 20 69 6e 20 74 68 65 20 | field | in the |
|000043a0| 73 70 65 63 69 66 69 65 | 64 20 74 61 62 6c 65 2e |specifie|d table.|
|000043b0| 20 20 45 61 63 68 20 70 | 72 6f 6d 70 74 20 64 69 | Each p|rompt di|
|000043c0| 73 70 6c 61 79 73 20 61 | 20 64 65 66 61 75 6c 74 |splays a| default|
|000043d0| 0a 20 20 20 20 76 61 6c | 75 65 2c 20 69 6e 20 62 |. val|ue, in b|
|000043e0| 72 61 63 6b 65 74 73 2c | 20 77 68 69 63 68 20 69 |rackets,| which i|
|000043f0| 73 20 61 63 63 65 70 74 | 65 64 20 62 79 20 70 72 |s accept|ed by pr|
|00004400| 65 73 73 69 6e 67 20 20 | 74 68 65 20 20 52 45 54 |essing |the RET|
|00004410| 55 52 4e 20 20 6b 65 79 | 2e 0a 20 20 20 20 54 68 |URN key|.. Th|
|00004420| 65 20 20 70 72 6f 6d 70 | 74 73 20 20 69 6e 63 6c |e promp|ts incl|
|00004430| 75 64 65 3a 20 20 74 68 | 65 20 20 73 74 6f 72 61 |ude: th|e stora|
|00004440| 67 65 20 20 74 79 70 65 | 20 61 20 70 72 65 66 69 |ge type| a prefi|
|00004450| 78 2d 6c 65 6e 67 74 68 | 20 74 68 65 20 66 69 65 |x-length| the fie|
|00004460| 6c 64 0a 20 20 20 20 6c | 65 6e 67 74 68 20 61 20 |ld. l|ength a |
|00004470| 66 69 65 6c 64 20 74 65 | 72 6d 69 6e 61 74 6f 72 |field te|rminator|
|00004480| 0a 0a 20 20 6f 20 54 68 | 65 20 20 64 65 66 61 75 |.. o Th|e defau|
|00004490| 6c 74 73 20 20 69 6e 20 | 20 62 72 61 63 6b 65 74 |lts in | bracket|
|000044a0| 73 20 20 61 74 20 20 65 | 61 63 68 20 20 70 72 6f |s at e|ach pro|
|000044b0| 6d 70 74 20 20 72 65 70 | 72 65 73 65 6e 74 20 20 |mpt rep|resent |
|000044c0| 72 65 61 73 6f 6e 61 62 | 6c 65 0a 20 20 20 20 64 |reasonab|le. d|
|000044d0| 65 66 61 75 6c 74 73 20 | 20 66 6f 72 20 74 68 65 |efaults | for the|
|000044e0| 20 66 69 65 6c 64 20 69 | 6e 20 71 75 65 73 74 69 | field i|n questi|
|000044f0| 6f 6e 2e 20 20 54 68 65 | 73 65 20 64 65 66 61 75 |on. The|se defau|
|00004500| 6c 74 20 76 61 6c 75 65 | 73 20 64 65 70 65 6e 64 |lt value|s depend|
|00004510| 20 6f 6e 0a 20 20 20 20 | 74 68 65 20 64 61 74 61 | on. |the data|
|00004520| 74 79 70 65 20 6f 66 20 | 74 68 65 20 66 69 65 6c |type of |the fiel|
|00004530| 64 2e 20 20 54 68 65 20 | 66 6f 6c 6c 6f 77 69 6e |d. The |followin|
|00004540| 67 20 74 61 62 6c 65 20 | 73 68 6f 77 73 20 20 74 |g table |shows t|
|00004550| 68 65 20 20 64 65 66 61 | 75 6c 74 73 0a 20 20 20 |he defa|ults. |
|00004560| 20 61 6e 64 20 70 6f 73 | 73 69 62 6c 65 20 72 65 | and pos|sible re|
|00004570| 73 70 6f 6e 73 65 73 2e | 0a 0a 0a 0a 0a 0a 0a 0a |sponses.|........|
|00004580| 0a 0a 0a 20 20 31 35 20 | 20 20 20 20 20 20 20 20 |... 15 | |
|00004590| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 56 65 72 | | Ver|
|000045a0| 73 69 6f 6e 20 34 2e 30 | 20 2d 2d 20 31 2f 31 35 |sion 4.0| -- 1/15|
|000045b0| 2f 38 39 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |/89 | |
|000045c0| 20 20 20 20 20 20 20 20 | 62 63 70 0a 20 20 5f 5f | |bcp. __|
|000045d0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000045e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000045f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004600| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004610| 5f 5f 5f 5f 0a 0a 20 20 | 20 20 20 20 20 20 20 50 |____.. | P|
|00004620| 72 6f 6d 70 74 20 20 20 | 20 20 20 20 20 20 20 20 |rompt | |
|00004630| 20 20 20 20 44 65 66 61 | 75 6c 74 20 50 72 6f 76 | Defa|ult Prov|
|00004640| 69 64 65 64 20 20 20 20 | 20 20 20 20 20 20 20 50 |ided | P|
|00004650| 6f 73 73 69 62 6c 65 20 | 52 65 73 70 6f 6e 73 65 |ossible |Response|
|00004660| 73 0a 20 20 20 20 53 74 | 6f 72 61 67 65 20 54 79 |s. St|orage Ty|
|00004670| 70 65 20 20 20 20 20 44 | 61 74 61 62 61 73 65 20 |pe D|atabase |
|00004680| 20 20 20 20 73 74 6f 72 | 61 67 65 20 20 20 20 20 | stor|age |
|00004690| 20 20 20 20 20 20 20 20 | 20 20 63 68 61 72 20 20 | | char |
|000046a0| 74 6f 20 20 63 72 65 61 | 74 65 20 20 6f 72 0a 20 |to crea|te or. |
|000046b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000046c0| 20 20 20 20 74 79 70 65 | 20 20 20 20 20 66 6f 72 | type| for|
|000046d0| 20 20 20 20 6d 6f 73 74 | 20 20 20 20 20 20 20 20 | most| |
|000046e0| 20 20 20 20 20 20 20 72 | 65 61 64 20 20 61 6e 20 | r|ead an |
|000046f0| 41 53 43 49 49 20 66 69 | 6c 65 3b 0a 20 20 20 20 |ASCII fi|le;. |
|00004700| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004710| 20 66 69 65 6c 64 73 3b | 20 20 20 20 20 20 20 20 | fields;| |
|00004720| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004730| 20 20 20 20 61 6e 79 20 | 53 51 4c 20 53 65 72 76 | any |SQL Serv|
|00004740| 65 72 20 64 61 74 61 2d | 0a 20 20 20 20 20 20 20 |er data-|. |
|00004750| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 63 68 | | ch|
|00004760| 61 72 20 66 6f 72 20 76 | 61 72 63 68 61 72 3b 20 |ar for v|archar; |
|00004770| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004780| 20 74 79 70 65 20 20 77 | 68 65 72 65 20 69 6d 70 | type w|here imp|
|00004790| 6c 69 63 69 74 0a 20 20 | 20 20 20 20 20 20 20 20 |licit. | |
|000047a0| 20 20 20 20 20 20 20 20 | 20 20 20 62 69 6e 61 72 | | binar|
|000047b0| 79 20 20 20 66 6f 72 20 | 20 20 20 76 61 72 2d 20 |y for | var- |
|000047c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 63 6f | | co|
|000047d0| 6e 76 65 72 73 69 6f 6e | 20 20 69 73 20 20 73 75 |nversion| is su|
|000047e0| 70 2d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |p-. | |
|000047f0| 20 20 20 20 20 20 20 20 | 62 69 6e 61 72 79 2e 20 | |binary. |
|00004800| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004810| 20 20 20 20 20 20 20 20 | 20 20 20 70 6f 72 74 65 | | porte|
|00004820| 64 2e 0a 20 20 20 20 50 | 72 65 66 69 78 20 4c 65 |d.. P|refix Le|
|00004830| 6e 67 74 68 20 20 20 20 | 30 20 66 6f 72 20 66 69 |ngth |0 for fi|
|00004840| 65 6c 64 73 20 64 65 66 | 69 6e 65 64 20 77 69 74 |elds def|ined wit|
|00004850| 68 20 64 61 74 61 74 79 | 70 65 20 30 20 69 66 20 |h dataty|pe 0 if |
|00004860| 20 6e 6f 20 20 70 72 65 | 66 69 78 20 20 69 73 0a | no pre|fix is.|
|00004870| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004880| 20 20 20 20 20 20 20 28 | 6e 6f 74 20 73 74 6f 72 | (|not stor|
|00004890| 61 67 65 20 74 79 70 65 | 29 20 63 68 61 72 20 20 |age type|) char |
|000048a0| 20 20 20 20 20 20 20 20 | 64 65 73 69 72 65 64 3b | |desired;|
|000048b0| 20 20 20 20 64 65 66 61 | 75 6c 74 73 0a 20 20 20 | defa|ults. |
|000048c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000048d0| 20 20 20 20 61 6e 64 20 | 61 6c 6c 20 66 69 78 65 | and |all fixe|
|000048e0| 64 2d 6c 65 6e 67 74 68 | 20 64 61 74 61 74 79 70 |d-length| datatyp|
|000048f0| 65 73 2c 20 20 61 72 65 | 20 20 72 65 63 6f 6d 6d |es, are| recomm|
|00004900| 65 6e 64 65 64 20 20 69 | 6e 0a 20 20 20 20 20 20 |ended i|n. |
|00004910| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 31 | | 1|
|00004920| 20 66 6f 72 20 6d 6f 73 | 74 20 6f 74 68 65 72 20 | for mos|t other |
|00004930| 64 61 74 61 74 79 70 65 | 73 20 20 20 20 20 20 20 |datatype|s |
|00004940| 20 20 61 6c 6c 20 6f 74 | 68 65 72 20 63 61 73 65 | all ot|her case|
|00004950| 73 2e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |s.. | |
|00004960| 20 20 20 20 20 20 20 20 | 32 20 66 6f 72 20 62 69 | |2 for bi|
|00004970| 6e 61 72 79 20 61 6e 64 | 20 76 61 72 62 69 6e 61 |nary and| varbina|
|00004980| 72 79 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ry. | |
|00004990| 20 20 20 20 20 20 20 20 | 20 20 73 61 76 65 64 20 | | saved |
|000049a0| 61 73 20 63 68 61 72 0a | 20 20 20 20 20 20 20 20 |as char.| |
|000049b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 34 20 66 | | 4 f|
|000049c0| 6f 72 20 74 65 78 74 20 | 61 6e 64 20 69 6d 61 67 |or text |and imag|
|000049d0| 65 0a 0a 0a 0a 0a 0a 20 | 20 62 63 70 20 20 20 20 |e...... | bcp |
|000049e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049f0| 20 56 65 72 73 69 6f 6e | 20 34 2e 30 20 2d 2d 20 | Version| 4.0 -- |
|00004a00| 31 2f 31 35 2f 38 39 20 | 20 20 20 20 20 20 20 20 |1/15/89 | |
|00004a10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 31 36 0a | | 16.|
|00004a20| 20 20 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f | ______|________|
|00004a30| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a40| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a50| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a60| 5f 5f 5f 5f 5f 5f 5f 5f | 0a 20 20 20 20 4c 65 6e |________|. Len|
|00004a70| 67 74 68 20 20 20 20 20 | 20 20 20 20 20 20 44 65 |gth | De|
|00004a80| 66 69 6e 65 64 20 20 6c | 65 6e 67 74 68 20 20 66 |fined l|ength f|
|00004a90| 6f 72 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |or | |
|00004aa0| 20 44 65 66 61 75 6c 74 | 20 20 76 61 6c 75 65 73 | Default| values|
|00004ab0| 2c 20 20 6f 72 0a 20 20 | 20 20 20 20 20 20 20 20 |, or. | |
|00004ac0| 20 20 20 20 20 20 20 20 | 20 20 20 63 68 61 72 20 | | char |
|00004ad0| 20 20 61 6e 64 20 20 76 | 61 72 63 68 61 72 2e 20 | and v|archar. |
|00004ae0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 67 72 | | gr|
|00004af0| 65 61 74 65 72 2c 20 20 | 61 72 65 20 72 65 63 6f |eater, |are reco|
|00004b00| 6d 2d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |m-. | |
|00004b10| 20 20 20 20 20 20 20 20 | 44 65 66 69 6e 65 64 20 | |Defined |
|00004b20| 6c 65 6e 67 74 68 20 20 | 2a 20 20 32 20 20 20 20 |length |* 2 |
|00004b30| 20 20 20 20 20 20 20 20 | 20 20 20 6d 65 6e 64 65 | | mende|
|00004b40| 64 2e 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |d.. | |
|00004b50| 20 20 20 20 20 20 20 20 | 66 6f 72 20 20 62 69 6e | |for bin|
|00004b60| 61 72 79 20 61 6e 64 20 | 76 61 72 2d 0a 20 20 20 |ary and |var-. |
|00004b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004b80| 20 20 62 69 6e 61 72 79 | 20 20 20 73 61 76 65 64 | binary| saved|
|00004b90| 20 20 20 20 61 73 0a 20 | 20 20 20 20 20 20 20 20 | as. | |
|00004ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 63 68 61 72 | | char|
|00004bb0| 2e 20 20 20 20 20 20 20 | 20 4d 61 78 69 6d 75 6d |. | Maximum|
|00004bc0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004bd0| 20 20 20 20 20 20 6c 65 | 6e 67 74 68 20 20 20 6e | le|ngth n|
|00004be0| 65 65 64 65 64 20 20 20 | 74 6f 0a 20 20 20 20 20 |eeded |to. |
|00004bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c00| 61 76 6f 69 64 20 20 74 | 72 75 6e 63 61 74 69 6f |avoid t|runcatio|
|00004c10| 6e 20 6f 72 0a 20 20 20 | 20 20 20 20 20 20 20 20 |n or. | |
|00004c20| 20 20 20 20 20 20 20 20 | 20 20 64 61 74 61 20 20 | | data |
|00004c30| 6f 76 65 72 66 6c 6f 77 | 20 20 20 66 6f 72 0a 20 |overflow| for. |
|00004c40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c50| 20 20 20 20 61 6c 6c 20 | 6f 74 68 65 72 20 64 61 | all |other da|
|00004c60| 74 61 74 79 70 65 73 2e | 0a 0a 0a 0a 0a 0a 0a 0a |tatypes.|........|
|00004c70| 0a 0a 0a 20 20 31 37 20 | 20 20 20 20 20 20 20 20 |... 17 | |
|00004c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 56 65 72 | | Ver|
|00004c90| 73 69 6f 6e 20 34 2e 30 | 20 2d 2d 20 31 2f 31 35 |sion 4.0| -- 1/15|
|00004ca0| 2f 38 39 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |/89 | |
|00004cb0| 20 20 20 20 20 20 20 20 | 62 63 70 0a 20 20 5f 5f | |bcp. __|
|00004cc0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004cd0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004ce0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004cf0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004d00| 5f 5f 5f 5f 0a 20 20 20 | 20 46 69 65 6c 64 20 54 |____. | Field T|
|00004d10| 65 72 6d 69 6e 61 74 6f | 72 20 4e 6f 6e 65 2e 20 |erminato|r None. |
|00004d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 55 70 20 | | Up |
|00004d40| 74 6f 20 33 30 20 41 53 | 43 49 49 20 63 68 61 72 |to 30 AS|CII char|
|00004d50| 2d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |-. | |
|00004d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d80| 20 20 20 20 20 20 20 20 | 20 20 61 63 74 65 72 73 | | acters|
|00004d90| 2c 20 20 6f 72 20 20 6f | 6e 65 20 20 6f 66 0a 20 |, or o|ne of. |
|00004da0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004db0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004dc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004dd0| 20 20 20 20 20 20 20 74 | 68 65 20 66 6f 6c 6c 6f | t|he follo|
|00004de0| 77 69 6e 67 3a 0a 20 20 | 20 20 20 20 20 20 20 20 |wing:. | |
|00004df0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 5c | | \|
|00004e20| 74 20 74 61 62 0a 20 20 | 20 20 20 20 20 20 20 20 |t tab. | |
|00004e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 5c | | \|
|00004e60| 6e 20 6e 65 77 6c 69 6e | 65 0a 20 20 20 20 20 20 |n newlin|e. |
|00004e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ea0| 20 20 20 5c 72 20 63 61 | 72 72 69 61 67 65 20 72 | \r ca|rriage r|
|00004eb0| 65 74 75 72 6e 0a 20 20 | 20 20 20 20 20 20 20 20 |eturn. | |
|00004ec0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ed0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004ee0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 5c | | \|
|00004ef0| 30 20 6e 75 6c 6c 20 74 | 65 72 6d 69 6e 61 74 6f |0 null t|erminato|
|00004f00| 72 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |r. | |
|00004f10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004f20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004f30| 20 20 20 20 20 20 20 20 | 20 20 20 5c 5c 20 62 61 | | \\ ba|
|00004f40| 63 6b 73 6c 61 73 68 0a | 0a 0a 20 20 6f 20 44 61 |ckslash.|.. o Da|
|00004f50| 74 61 20 63 61 6e 20 62 | 65 20 63 6f 70 69 65 64 |ta can b|e copied|
|00004f60| 20 69 6e 74 6f 20 61 20 | 66 69 6c 65 20 65 69 74 | into a |file eit|
|00004f70| 68 65 72 20 61 73 20 69 | 74 73 20 6e 61 74 69 76 |her as i|ts nativ|
|00004f80| 65 20 28 64 61 74 61 62 | 61 73 65 29 20 64 61 74 |e (datab|ase) dat|
|00004f90| 61 2d 0a 20 20 20 20 74 | 79 70 65 2c 20 20 6f 72 |a-. t|ype, or|
|00004fa0| 20 61 73 20 61 6e 79 20 | 64 61 74 61 74 79 70 65 | as any |datatype|
|00004fb0| 20 66 6f 72 20 77 68 69 | 63 68 20 69 6d 70 6c 69 | for whi|ch impli|
|00004fc0| 63 69 74 20 63 6f 6e 76 | 65 72 73 69 6f 6e 20 69 |cit conv|ersion i|
|00004fd0| 73 20 73 75 70 70 6f 72 | 74 65 64 0a 20 20 20 20 |s suppor|ted. |
|00004fe0| 66 6f 72 20 74 68 65 20 | 64 61 74 61 74 79 70 65 |for the |datatype|
|00004ff0| 20 69 6e 20 71 75 65 73 | 74 69 6f 6e 2e 20 20 53 | in ques|tion. S|
|00005000| 65 65 20 74 68 65 20 44 | 42 2d 4c 69 62 72 61 72 |ee the D|B-Librar|
|00005010| 79 20 20 6d 61 6e 75 61 | 6c 20 20 70 61 67 65 20 |y manua|l page |
|00005020| 20 66 6f 72 0a 0a 0a 0a | 0a 0a 0a 0a 20 20 62 63 | for....|.... bc|
|00005030| 70 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |p | |
|00005040| 20 20 20 20 20 20 56 65 | 72 73 69 6f 6e 20 34 2e | Ve|rsion 4.|
|00005050| 30 20 2d 2d 20 31 2f 31 | 35 2f 38 39 20 20 20 20 |0 -- 1/1|5/89 |
|00005060| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005070| 20 20 31 38 0a 20 20 5f | 5f 5f 5f 5f 5f 5f 5f 5f | 18. _|________|
|00005080| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005090| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000050a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000050b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 0a 20 20 |________|_____. |
|000050c0| 20 20 64 62 63 6f 6e 76 | 65 72 74 20 66 6f 72 20 | dbconv|ert for |
|000050d0| 64 65 74 61 69 6c 73 2e | 0a 0a 20 20 20 20 48 65 |details.|.. He|
|000050e0| 72 65 20 61 72 65 20 74 | 68 65 20 64 65 66 61 75 |re are t|he defau|
|000050f0| 6c 74 20 73 74 6f 72 61 | 67 65 20 64 61 74 61 74 |lt stora|ge datat|
|00005100| 79 70 65 73 20 74 68 61 | 74 20 63 6f 72 72 65 73 |ypes tha|t corres|
|00005110| 70 6f 6e 64 20 74 6f 20 | 53 51 4c 20 53 65 72 76 |pond to |SQL Serv|
|00005120| 65 72 0a 20 20 20 20 64 | 61 74 61 74 79 70 65 73 |er. d|atatypes|
|00005130| 2c 20 61 6e 64 20 74 68 | 65 20 6c 65 67 61 6c 20 |, and th|e legal |
|00005140| 61 62 62 72 65 76 69 61 | 74 69 6f 6e 73 3a 0a 0a |abbrevia|tions:..|
|00005150| 20 20 20 20 20 20 20 54 | 61 62 6c 65 20 44 61 74 | T|able Dat|
|00005160| 61 74 79 70 65 53 74 6f | 72 61 67 65 54 79 70 65 |atypeSto|rageType|
|00005170| 0a 0a 20 20 20 20 20 20 | 20 63 68 61 72 20 20 20 |.. | char |
|00005180| 20 20 20 63 5b 68 61 72 | 5d 0a 20 20 20 20 20 20 | c[har|]. |
|00005190| 20 76 61 72 63 68 61 72 | 20 20 20 63 5b 68 61 72 | varchar| c[har|
|000051a0| 5d 0a 20 20 20 20 20 20 | 20 74 65 78 74 20 20 20 |]. | text |
|000051b0| 20 20 20 54 5b 65 78 74 | 5d 0a 20 20 20 20 20 20 | T[ext|]. |
|000051c0| 20 62 69 6e 61 72 79 20 | 20 20 20 78 0a 20 20 20 | binary | x. |
|000051d0| 20 20 20 20 76 61 72 62 | 69 6e 61 72 79 20 78 0a | varb|inary x.|
|000051e0| 20 20 20 20 20 20 20 69 | 6d 61 67 65 20 20 20 20 | i|mage |
|000051f0| 20 49 5b 6d 61 67 65 5d | 0a 20 20 20 20 20 20 20 | I[mage]|. |
|00005200| 69 6e 74 20 20 20 20 20 | 20 20 69 5b 6e 74 5d 0a |int | i[nt].|
|00005210| 20 20 20 20 20 20 20 73 | 6d 61 6c 6c 69 6e 74 20 | s|mallint |
|00005220| 20 73 5b 6d 61 6c 6c 69 | 6e 74 5d 0a 20 20 20 20 | s[malli|nt]. |
|00005230| 20 20 20 74 69 6e 79 69 | 6e 74 20 20 20 74 5b 69 | tinyi|nt t[i|
|00005240| 6e 79 69 6e 74 5d 0a 20 | 20 20 20 20 20 20 66 6c |nyint]. | fl|
|00005250| 6f 61 74 20 20 20 20 20 | 66 5b 6c 6f 61 74 5d 0a |oat |f[loat].|
|00005260| 0a 0a 0a 20 20 31 39 20 | 20 20 20 20 20 20 20 20 |... 19 | |
|00005270| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 56 65 72 | | Ver|
|00005280| 73 69 6f 6e 20 34 2e 30 | 20 2d 2d 20 31 2f 31 35 |sion 4.0| -- 1/15|
|00005290| 2f 38 39 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |/89 | |
|000052a0| 20 20 20 20 20 20 20 20 | 62 63 70 0a 20 20 5f 5f | |bcp. __|
|000052b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000052c0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000052d0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000052e0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000052f0| 5f 5f 5f 5f 0a 20 20 20 | 20 20 20 20 62 69 74 20 |____. | bit |
|00005300| 20 20 20 20 20 20 62 5b | 69 74 5d 0a 20 20 20 20 | b[|it]. |
|00005310| 20 20 20 6d 6f 6e 65 79 | 20 20 20 20 20 6d 5b 6f | money| m[o|
|00005320| 6e 65 79 5d 0a 20 20 20 | 20 20 20 20 64 61 74 65 |ney]. | date|
|00005330| 74 69 6d 65 20 20 64 5b | 61 74 65 5d 0a 20 20 20 |time d[|ate]. |
|00005340| 20 20 20 20 74 69 6d 65 | 73 74 61 6d 70 20 78 0a | time|stamp x.|
|00005350| 0a 20 20 20 20 20 20 20 | 7c 08 2d 42 72 61 63 6b |. ||.-Brack|
|00005360| 65 74 73 20 28 5b 5d 29 | 20 69 6e 64 69 63 61 74 |ets ([])| indicat|
|00005370| 65 20 74 68 61 74 20 79 | 6f 75 20 6d 61 79 20 75 |e that y|ou may u|
|00005380| 73 65 20 74 68 65 20 20 | 69 6e 69 74 69 61 6c 20 |se the |initial |
|00005390| 20 63 68 61 72 61 63 74 | 65 72 2c 0a 20 20 20 20 | charact|er,. |
|000053a0| 20 20 20 6f 72 20 20 74 | 68 65 20 20 62 65 67 69 | or t|he begi|
|000053b0| 6e 6e 69 6e 67 20 63 68 | 61 72 61 63 74 65 72 73 |nning ch|aracters|
|000053c0| 20 6f 66 20 74 68 65 20 | 77 6f 72 64 2c 20 69 2e | of the |word, i.|
|000053d0| 65 2e 20 66 6f 72 20 62 | 69 74 20 79 6f 75 20 63 |e. for b|it you c|
|000053e0| 6f 75 6c 64 0a 20 20 20 | 20 20 20 20 75 73 65 20 |ould. | use |
|000053f0| 62 2c 20 62 69 20 6f 72 | 20 62 69 74 2e 0a 0a 20 |b, bi or| bit... |
|00005400| 20 20 20 20 20 20 74 69 | 6d 65 73 74 61 6d 70 20 | ti|mestamp |
|00005410| 64 61 74 61 20 69 73 20 | 74 72 65 61 74 65 64 20 |data is |treated |
|00005420| 61 73 20 62 69 6e 61 72 | 79 28 38 29 2e 0a 0a 20 |as binar|y(8)... |
|00005430| 20 6f 20 46 69 65 6c 64 | 73 20 64 65 66 69 6e 65 | o Field|s define|
|00005440| 64 20 69 6e 20 74 68 65 | 20 64 61 74 61 62 61 73 |d in the| databas|
|00005450| 65 20 61 73 20 63 68 61 | 72 20 61 6e 64 20 62 69 |e as cha|r and bi|
|00005460| 6e 61 72 79 20 61 72 65 | 20 61 6c 77 61 79 73 20 |nary are| always |
|00005470| 20 70 61 64 64 65 64 0a | 20 20 20 20 77 69 74 68 | padded.| with|
|00005480| 20 73 70 61 63 65 73 20 | 74 6f 20 74 68 65 20 66 | spaces |to the f|
|00005490| 75 6c 6c 20 6c 65 6e 67 | 74 68 20 64 65 66 69 6e |ull leng|th defin|
|000054a0| 65 64 20 69 6e 20 74 68 | 65 20 64 61 74 61 62 61 |ed in th|e databa|
|000054b0| 73 65 2e 0a 20 20 6f 20 | 57 68 65 6e 20 73 74 6f |se.. o |When sto|
|000054c0| 72 69 6e 67 20 66 69 65 | 6c 64 73 20 28 65 78 63 |ring fie|lds (exc|
|000054d0| 65 70 74 20 63 68 61 72 | 20 61 6e 64 20 62 69 6e |ept char| and bin|
|000054e0| 61 72 79 20 66 69 65 6c | 64 73 29 20 61 73 20 63 |ary fiel|ds) as c|
|000054f0| 68 61 72 20 20 69 6e 73 | 74 65 61 64 0a 20 20 20 |har ins|tead. |
|00005500| 20 6f 66 20 20 74 68 65 | 69 72 20 64 61 74 61 62 | of the|ir datab|
|00005510| 61 73 65 20 64 61 74 61 | 74 79 70 65 73 2c 20 74 |ase data|types, t|
|00005520| 68 65 79 20 77 69 6c 6c | 20 74 61 6b 65 20 6c 65 |hey will| take le|
|00005530| 73 73 20 66 69 6c 65 20 | 73 74 6f 72 61 67 65 20 |ss file |storage |
|00005540| 73 70 61 63 65 0a 20 20 | 20 20 77 69 74 68 20 74 |space. | with t|
|00005550| 68 65 20 64 65 66 61 75 | 6c 74 20 6c 65 6e 67 74 |he defau|lt lengt|
|00005560| 68 20 61 6e 64 20 61 20 | 70 72 65 66 69 78 20 6f |h and a |prefix o|
|00005570| 72 20 61 20 74 65 72 6d | 69 6e 61 74 6f 72 2e 20 |r a term|inator. |
|00005580| 20 62 63 70 20 20 63 61 | 6e 20 20 75 73 65 0a 20 | bcp ca|n use. |
|00005590| 20 20 20 65 69 74 68 65 | 72 20 20 61 20 74 65 72 | eithe|r a ter|
|000055a0| 6d 69 6e 61 74 6f 72 20 | 6f 72 20 61 20 70 72 65 |minator |or a pre|
|000055b0| 66 69 78 20 74 6f 20 64 | 65 74 65 72 6d 69 6e 65 |fix to d|etermine|
|000055c0| 20 74 68 65 20 6d 6f 73 | 74 20 65 66 66 69 63 69 | the mos|t effici|
|000055d0| 65 6e 74 20 75 73 65 0a | 0a 0a 0a 20 20 62 63 70 |ent use.|... bcp|
|000055e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000055f0| 20 20 20 20 20 56 65 72 | 73 69 6f 6e 20 34 2e 30 | Ver|sion 4.0|
|00005600| 20 2d 2d 20 31 2f 31 35 | 2f 38 39 20 20 20 20 20 | -- 1/15|/89 |
|00005610| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005620| 20 32 30 0a 20 20 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f | 20. __|________|
|00005630| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005640| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005650| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005660| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 0a 20 20 20 |________|____. |
|00005670| 20 6f 66 20 73 74 6f 72 | 61 67 65 20 73 70 61 63 | of stor|age spac|
|00005680| 65 2e 20 20 54 68 65 20 | 6d 61 78 69 6d 75 6d 20 |e. The |maximum |
|00005690| 61 6d 6f 75 6e 74 20 6f | 66 20 73 74 6f 72 61 67 |amount o|f storag|
|000056a0| 65 20 73 70 61 63 65 20 | 72 65 71 75 69 72 65 64 |e space |required|
|000056b0| 20 20 66 6f 72 0a 20 20 | 20 20 65 61 63 68 20 66 | for. | each f|
|000056c0| 69 65 6c 64 20 69 73 20 | 73 75 67 67 65 73 74 65 |ield is |suggeste|
|000056d0| 64 20 62 79 20 62 63 70 | 20 61 73 20 74 68 65 20 |d by bcp| as the |
|000056e0| 64 65 66 61 75 6c 74 2e | 0a 0a 20 20 20 20 41 20 |default.|.. A |
|000056f0| 6c 65 6e 67 74 68 20 70 | 72 65 66 69 78 20 69 73 |length p|refix is|
|00005700| 20 61 20 31 2c 20 32 2c | 20 6f 72 20 34 2d 62 79 | a 1, 2,| or 4-by|
|00005710| 74 65 20 69 6e 74 65 67 | 65 72 20 20 77 68 69 63 |te integ|er whic|
|00005720| 68 20 20 72 65 70 72 65 | 73 65 6e 74 73 20 20 74 |h repre|sents t|
|00005730| 68 65 0a 20 20 20 20 6c | 65 6e 67 74 68 20 20 6f |he. l|ength o|
|00005740| 66 20 65 61 63 68 20 64 | 61 74 61 20 76 61 6c 75 |f each d|ata valu|
|00005750| 65 2c 20 61 6e 64 20 69 | 6d 6d 65 64 69 61 74 65 |e, and i|mmediate|
|00005760| 6c 79 20 70 72 65 63 65 | 64 65 73 20 65 61 63 68 |ly prece|des each|
|00005770| 20 64 61 74 61 20 76 61 | 6c 75 65 0a 20 20 20 20 | data va|lue. |
|00005780| 69 6e 20 74 68 65 20 68 | 6f 73 74 20 66 69 6c 65 |in the h|ost file|
|00005790| 2e 20 20 41 20 74 65 72 | 6d 69 6e 61 74 6f 72 20 |. A ter|minator |
|000057a0| 69 73 20 61 6e 79 20 63 | 68 61 72 61 63 74 65 72 |is any c|haracter|
|000057b0| 20 6f 72 20 73 74 72 69 | 6e 67 20 6f 66 20 20 63 | or stri|ng of c|
|000057c0| 68 61 72 2d 0a 20 20 20 | 20 61 63 74 65 72 73 2e |har-. | acters.|
|000057d0| 0a 0a 20 20 20 20 54 68 | 65 20 74 61 62 6c 65 73 |.. Th|e tables|
|000057e0| 20 62 65 6c 6f 77 20 73 | 68 6f 77 20 74 68 65 20 | below s|how the |
|000057f0| 69 6e 74 65 72 61 63 74 | 69 6f 6e 20 20 6f 66 20 |interact|ion of |
|00005800| 20 70 72 65 66 69 78 2d | 6c 65 6e 67 74 68 73 2c | prefix-|lengths,|
|00005810| 20 20 74 65 72 6d 69 6e | 61 2d 0a 20 20 20 20 74 | termin|a-. t|
|00005820| 6f 72 73 2c 20 20 61 6e | 64 20 20 66 69 65 6c 64 |ors, an|d field|
|00005830| 20 20 6c 65 6e 67 74 68 | 20 20 6f 6e 20 74 68 65 | length| on the|
|00005840| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 20 69 6e 20 | informa|tion in |
|00005850| 74 68 65 20 66 69 6c 65 | 2e 20 20 60 60 50 27 27 |the file|. ``P''|
|00005860| 20 69 73 0a 20 20 20 20 | 75 73 65 64 20 74 6f 20 | is. |used to |
|00005870| 69 6e 64 69 63 61 74 65 | 20 74 68 65 20 70 72 65 |indicate| the pre|
|00005880| 66 69 78 20 69 6e 20 74 | 68 65 20 73 74 6f 72 65 |fix in t|he store|
|00005890| 64 20 74 61 62 6c 65 3b | 20 60 60 54 27 27 20 69 |d table;| ``T'' i|
|000058a0| 6e 64 69 63 61 74 65 73 | 20 74 68 65 0a 20 20 20 |ndicates| the. |
|000058b0| 20 74 65 72 6d 69 6e 61 | 74 6f 72 2c 20 20 61 6e | termina|tor, an|
|000058c0| 64 20 20 61 70 70 65 6e | 64 65 64 20 20 73 70 61 |d appen|ded spa|
|000058d0| 63 65 73 20 20 61 72 65 | 20 20 73 68 6f 77 6e 20 |ces are| shown |
|000058e0| 20 77 69 74 68 20 20 64 | 61 73 68 65 73 2c 20 60 | with d|ashes, `|
|000058f0| 60 2d 27 27 2e 0a 20 20 | 20 20 60 60 2e 2e 2e 27 |`-''.. | ``...'|
|00005900| 27 20 69 6e 64 69 63 61 | 74 65 73 20 74 68 61 74 |' indica|tes that|
|00005910| 20 74 68 65 20 70 61 74 | 74 65 72 6e 20 77 6f 75 | the pat|tern wou|
|00005920| 6c 64 20 72 65 70 65 61 | 74 20 66 6f 72 20 65 61 |ld repea|t for ea|
|00005930| 63 68 20 66 69 65 6c 64 | 2e 20 20 54 68 65 0a 20 |ch field|. The. |
|00005940| 20 20 20 66 69 65 6c 64 | 20 6c 65 6e 67 74 68 20 | field| length |
|00005950| 69 73 20 38 20 66 6f 72 | 20 65 61 63 68 20 63 6f |is 8 for| each co|
|00005960| 6c 75 6d 6e 2c 20 61 6e | 64 20 77 65 27 72 65 20 |lumn, an|d we're |
|00005970| 73 74 6f 72 69 6e 67 20 | 74 68 65 20 36 2d 63 68 |storing |the 6-ch|
|00005980| 61 72 61 63 74 65 72 0a | 20 20 20 20 66 69 65 6c |aracter.| fiel|
|00005990| 64 20 60 60 73 74 72 69 | 6e 67 27 27 20 65 61 63 |d ``stri|ng'' eac|
|000059a0| 68 20 74 69 6d 65 2e 0a | 0a 20 20 20 20 53 51 4c |h time..|. SQL|
|000059b0| 20 53 65 72 76 65 72 20 | 63 68 61 72 20 64 61 74 | Server |char dat|
|000059c0| 61 0a 0a 0a 0a 20 20 32 | 31 20 20 20 20 20 20 20 |a.... 2|1 |
|000059d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 56 | | V|
|000059e0| 65 72 73 69 6f 6e 20 34 | 2e 30 20 2d 2d 20 31 2f |ersion 4|.0 -- 1/|
|000059f0| 31 35 2f 38 39 20 20 20 | 20 20 20 20 20 20 20 20 |15/89 | |
|00005a00| 20 20 20 20 20 20 20 20 | 20 20 62 63 70 0a 20 20 | | bcp. |
|00005a10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005a20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005a30| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005a40| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005a50| 5f 5f 5f 5f 5f 5f 0a 0a | 20 20 20 20 20 20 20 20 |______..| |
|00005a60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 50 72 | | Pr|
|00005a70| 65 66 69 78 2d 6c 65 6e | 67 74 68 20 3d 20 30 20 |efix-len|gth = 0 |
|00005a80| 20 20 20 20 50 72 65 66 | 69 78 2d 6c 65 6e 67 74 | Pref|ix-lengt|
|00005a90| 68 20 31 2c 20 32 20 6f | 72 20 34 0a 20 20 20 20 |h 1, 2 o|r 4. |
|00005aa0| 4e 6f 20 74 65 72 6d 69 | 6e 61 74 6f 72 20 20 20 |No termi|nator |
|00005ab0| 73 74 72 69 6e 67 2d 2d | 73 74 72 69 6e 67 2d 2d |string--|string--|
|00005ac0| 2e 2e 2e 20 20 20 20 20 | 50 73 74 72 69 6e 67 2d |... |Pstring-|
|00005ad0| 2d 50 73 74 72 69 6e 67 | 2d 2d 2e 2e 2e 0a 20 20 |-Pstring|--.... |
|00005ae0| 20 20 54 65 72 6d 69 6e | 61 74 6f 72 20 20 20 20 | Termin|ator |
|00005af0| 20 20 73 74 72 69 6e 67 | 2d 2d 54 73 74 72 69 6e | string|--Tstrin|
|00005b00| 67 2d 2d 54 2e 2e 2e 20 | 20 20 50 73 74 72 69 6e |g--T... | Pstrin|
|00005b10| 67 2d 2d 54 50 73 74 72 | 69 6e 67 2d 2d 54 2e 2e |g--TPstr|ing--T..|
|00005b20| 2e 0a 0a 0a 0a 20 20 20 | 20 4f 74 68 65 72 20 64 |..... | Other d|
|00005b30| 61 74 61 74 79 70 65 73 | 20 63 6f 6e 76 65 72 74 |atatypes| convert|
|00005b40| 65 64 20 74 6f 20 63 68 | 61 72 20 73 74 6f 72 61 |ed to ch|ar stora|
|00005b50| 67 65 0a 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ge.. | |
|00005b60| 20 20 20 20 20 20 20 20 | 20 50 72 65 66 69 78 2d | | Prefix-|
|00005b70| 6c 65 6e 67 74 68 20 3d | 20 30 20 20 20 20 50 72 |length =| 0 Pr|
|00005b80| 65 66 69 78 2d 6c 65 6e | 67 74 68 20 31 2c 20 32 |efix-len|gth 1, 2|
|00005b90| 20 6f 72 20 34 0a 20 20 | 20 20 4e 6f 20 74 65 72 | or 4. | No ter|
|00005ba0| 6d 69 6e 61 74 6f 72 20 | 20 20 73 74 72 69 6e 67 |minator | string|
|00005bb0| 2d 2d 73 74 72 69 6e 67 | 2d 2d 2e 2e 2e 20 20 20 |--string|--... |
|00005bc0| 50 73 74 72 69 6e 67 50 | 73 74 72 69 6e 67 2e 2e |PstringP|string..|
|00005bd0| 2e 0a 20 20 20 20 54 65 | 72 6d 69 6e 61 74 6f 72 |.. Te|rminator|
|00005be0| 20 20 20 20 20 20 73 74 | 72 69 6e 67 54 73 74 72 | st|ringTstr|
|00005bf0| 69 6e 67 54 2e 2e 2e 20 | 20 20 20 20 50 73 74 72 |ingT... | Pstr|
|00005c00| 69 6e 67 54 50 73 74 72 | 69 6e 67 54 2e 2e 2e 0a |ingTPstr|ingT....|
|00005c10| 0a 20 20 6f 20 4e 6f 74 | 65 20 74 68 61 74 20 74 |. o Not|e that t|
|00005c20| 68 65 20 66 69 6c 65 20 | 73 74 6f 72 61 67 65 20 |he file |storage |
|00005c30| 74 79 70 65 20 61 6e 64 | 20 6c 65 6e 67 74 68 20 |type and| length |
|00005c40| 6f 66 20 61 20 63 6f 6c | 75 6d 6e 20 64 6f 20 20 |of a col|umn do |
|00005c50| 6e 6f 74 20 20 68 61 76 | 65 0a 20 20 20 20 74 6f |not hav|e. to|
|00005c60| 20 20 62 65 20 74 68 65 | 20 73 61 6d 65 20 61 73 | be the| same as|
|00005c70| 20 74 68 65 20 74 79 70 | 65 20 61 6e 64 20 6c 65 | the typ|e and le|
|00005c80| 6e 67 74 68 20 6f 66 20 | 74 68 65 20 63 6f 6c 75 |ngth of |the colu|
|00005c90| 6d 6e 20 69 6e 20 74 68 | 65 20 64 61 74 61 62 61 |mn in th|e databa|
|00005ca0| 73 65 0a 20 20 20 20 74 | 61 62 6c 65 2e 20 20 28 |se. t|able. (|
|00005cb0| 49 66 20 74 79 70 65 73 | 20 61 6e 64 20 66 6f 72 |If types| and for|
|00005cc0| 6d 61 74 73 20 62 65 69 | 6e 67 20 63 6f 70 69 65 |mats bei|ng copie|
|00005cd0| 64 20 69 6e 20 61 72 65 | 20 69 6e 63 6f 6d 70 61 |d in are| incompa|
|00005ce0| 74 69 62 6c 65 20 20 77 | 69 74 68 0a 20 20 20 20 |tible w|ith. |
|00005cf0| 74 68 65 20 73 74 72 75 | 63 74 75 72 65 20 6f 66 |the stru|cture of|
|00005d00| 20 74 68 65 20 64 61 74 | 61 62 61 73 65 20 74 61 | the dat|abase ta|
|00005d10| 62 6c 65 2c 20 74 68 65 | 20 63 6f 70 79 20 66 61 |ble, the| copy fa|
|00005d20| 69 6c 73 2e 29 0a 0a 0a | 0a 20 20 62 63 70 20 20 |ils.)...|. bcp |
|00005d30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d40| 20 20 20 56 65 72 73 69 | 6f 6e 20 34 2e 30 20 2d | Versi|on 4.0 -|
|00005d50| 2d 20 31 2f 31 35 2f 38 | 39 20 20 20 20 20 20 20 |- 1/15/8|9 |
|00005d60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 32 | | 2|
|00005d70| 32 0a 20 20 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |2. ____|________|
|00005d80| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005d90| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005da0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005db0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 0a 0a 20 20 6f 20 |________|__.. o |
|00005dc0| 55 73 65 72 20 64 61 74 | 61 74 79 70 65 73 20 61 |User dat|atypes a|
|00005dd0| 72 65 20 63 6f 70 69 65 | 64 20 61 73 20 74 68 65 |re copie|d as the|
|00005de0| 69 72 20 62 61 73 65 20 | 64 61 74 61 74 79 70 65 |ir base |datatype|
|00005df0| 20 6f 72 20 61 73 20 61 | 6e 79 20 20 64 61 74 61 | or as a|ny data|
|00005e00| 74 79 70 65 0a 20 20 20 | 20 66 6f 72 20 77 68 69 |type. | for whi|
|00005e10| 63 68 20 69 6d 70 6c 69 | 63 69 74 20 63 6f 6e 76 |ch impli|cit conv|
|00005e20| 65 72 73 69 6f 6e 20 69 | 73 20 73 75 70 70 6f 72 |ersion i|s suppor|
|00005e30| 74 65 64 2e 0a 20 20 6f | 20 46 6f 72 20 63 68 61 |ted.. o| For cha|
|00005e40| 72 20 6f 72 20 76 61 72 | 63 68 61 72 20 64 61 74 |r or var|char dat|
|00005e50| 61 2c 20 61 6e 79 20 6c | 65 6e 67 74 68 20 76 61 |a, any l|ength va|
|00005e60| 6c 75 65 20 69 73 20 61 | 63 63 65 70 74 65 64 2e |lue is a|ccepted.|
|00005e70| 0a 0a 20 20 6f 20 49 66 | 20 64 61 74 61 20 69 6e |.. o If| data in|
|00005e80| 20 76 61 72 63 68 61 72 | 20 61 6e 64 20 76 61 72 | varchar| and var|
|00005e90| 62 69 6e 61 72 79 20 66 | 69 65 6c 64 73 20 69 73 |binary f|ields is|
|00005ea0| 20 6c 6f 6e 67 65 72 20 | 20 74 68 61 6e 20 20 74 | longer | than t|
|00005eb0| 68 65 20 20 6c 65 6e 67 | 74 68 0a 20 20 20 20 79 |he leng|th. y|
|00005ec0| 6f 75 20 73 70 65 63 69 | 66 79 20 66 6f 72 20 63 |ou speci|fy for c|
|00005ed0| 6f 70 79 20 6f 75 74 2c | 20 74 68 65 20 64 61 74 |opy out,| the dat|
|00005ee0| 61 20 69 6e 20 74 68 65 | 20 66 69 6c 65 20 69 73 |a in the| file is|
|00005ef0| 20 73 69 6c 65 6e 74 6c | 79 20 74 72 75 6e 63 61 | silentl|y trunca|
|00005f00| 74 65 64 0a 20 20 20 20 | 61 74 20 74 68 65 20 73 |ted. |at the s|
|00005f10| 70 65 63 69 66 69 65 64 | 20 6c 65 6e 67 74 68 2e |pecified| length.|
|00005f20| 0a 20 20 6f 20 41 20 74 | 65 72 6d 69 6e 61 74 6f |. o A t|erminato|
|00005f30| 72 20 73 74 72 69 6e 67 | 20 63 61 6e 20 62 65 20 |r string| can be |
|00005f40| 75 70 20 74 6f 20 33 30 | 20 63 68 61 72 61 63 74 |up to 30| charact|
|00005f50| 65 72 73 20 6c 6f 6e 67 | 3b 20 74 68 65 20 6d 6f |ers long|; the mo|
|00005f60| 73 74 20 63 6f 6d 6d 6f | 6e 0a 20 20 20 20 74 65 |st commo|n. te|
|00005f70| 72 6d 69 6e 61 74 6f 72 | 73 20 20 61 72 65 20 20 |rminator|s are |
|00005f80| 61 20 20 74 61 62 20 28 | 65 6e 74 65 72 65 64 20 |a tab (|entered |
|00005f90| 61 73 20 60 60 5c 74 27 | 27 20 61 6e 64 20 75 73 |as ``\t'|' and us|
|00005fa0| 65 64 20 66 6f 72 20 61 | 6c 6c 20 63 6f 6c 75 6d |ed for a|ll colum|
|00005fb0| 6e 73 0a 20 20 20 20 65 | 78 63 65 70 74 20 74 68 |ns. e|xcept th|
|00005fc0| 65 20 6c 61 73 74 20 6f | 6e 65 29 2c 20 61 20 6e |e last o|ne), a n|
|00005fd0| 65 77 6c 69 6e 65 20 28 | 65 6e 74 65 72 65 64 20 |ewline (|entered |
|00005fe0| 61 73 20 60 60 5c 6e 27 | 27 20 61 6e 64 20 75 73 |as ``\n'|' and us|
|00005ff0| 65 64 20 66 6f 72 20 20 | 74 68 65 0a 20 20 20 20 |ed for |the. |
|00006000| 6c 61 73 74 20 20 66 69 | 65 6c 64 20 69 6e 20 61 |last fi|eld in a|
|00006010| 20 72 6f 77 29 2e 20 20 | 4f 74 68 65 72 20 74 65 | row). |Other te|
|00006020| 72 6d 69 6e 61 74 6f 72 | 73 20 61 72 65 3a 20 5c |rminator|s are: \|
|00006030| 30 20 28 74 68 65 20 6e | 75 6c 6c 20 74 65 72 6d |0 (the n|ull term|
|00006040| 69 6e 61 2d 0a 20 20 20 | 20 74 6f 72 29 20 61 6e |ina-. | tor) an|
|00006050| 64 20 5c 5c 20 28 62 61 | 63 6b 73 6c 61 73 68 29 |d \\ (ba|ckslash)|
|00006060| 20 61 6e 64 20 5c 72 20 | 28 63 61 72 72 69 61 67 | and \r |(carriag|
|00006070| 65 20 72 65 74 75 72 6e | 29 2e 0a 0a 20 20 6f 20 |e return|)... o |
|00006080| 57 68 65 6e 20 61 20 74 | 65 72 6d 69 6e 61 74 6f |When a t|erminato|
|00006090| 72 20 6f 72 20 70 72 65 | 66 69 78 20 69 73 20 70 |r or pre|fix is p|
|000060a0| 72 65 73 65 6e 74 2c 20 | 69 74 20 61 66 66 65 63 |resent, |it affec|
|000060b0| 74 73 20 74 68 65 20 61 | 63 74 75 61 6c 20 6c 65 |ts the a|ctual le|
|000060c0| 6e 67 74 68 0a 20 20 20 | 20 6f 66 20 20 64 61 74 |ngth. | of dat|
|000060d0| 61 20 74 72 61 6e 73 66 | 65 72 72 65 64 2e 20 20 |a transf|erred. |
|000060e0| 49 66 20 74 68 65 20 6c | 65 6e 67 74 68 20 6f 66 |If the l|ength of|
|000060f0| 20 61 6e 20 65 6e 74 72 | 79 20 62 65 69 6e 67 20 | an entr|y being |
|00006100| 63 6f 70 69 65 64 20 6f | 75 74 20 74 6f 0a 20 20 |copied o|ut to. |
|00006110| 20 20 61 20 66 69 6c 65 | 20 69 73 20 6c 65 73 73 | a file| is less|
|00006120| 20 74 68 61 6e 20 74 68 | 65 20 73 74 6f 72 61 67 | than th|e storag|
|00006130| 65 20 6c 65 6e 67 74 68 | 2c 20 69 74 20 69 73 20 |e length|, it is |
|00006140| 20 66 6f 6c 6c 6f 77 65 | 64 20 20 69 6d 6d 65 64 | followe|d immed|
|00006150| 69 61 74 65 6c 79 0a 20 | 20 20 20 62 79 20 20 74 |iately. | by t|
|00006160| 68 65 20 20 74 65 72 6d | 69 6e 61 74 6f 72 2c 20 |he term|inator, |
|00006170| 6f 72 20 74 68 65 20 70 | 72 65 66 69 78 20 66 6f |or the p|refix fo|
|00006180| 72 20 74 68 65 20 6e 65 | 78 74 20 66 69 65 6c 64 |r the ne|xt field|
|00006190| 2e 20 20 54 68 65 20 65 | 6e 74 72 79 20 69 73 0a |. The e|ntry is.|
|000061a0| 0a 0a 20 20 32 33 20 20 | 20 20 20 20 20 20 20 20 |.. 23 | |
|000061b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 56 65 72 73 | | Vers|
|000061c0| 69 6f 6e 20 34 2e 30 20 | 2d 2d 20 31 2f 31 35 2f |ion 4.0 |-- 1/15/|
|000061d0| 38 39 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |89 | |
|000061e0| 20 20 20 20 20 20 20 62 | 63 70 0a 20 20 5f 5f 5f | b|cp. ___|
|000061f0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00006200| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00006210| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00006220| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00006230| 5f 5f 5f 0a 20 20 20 20 | 6e 6f 74 20 70 61 64 64 |___. |not padd|
|00006240| 65 64 20 74 6f 20 74 68 | 65 20 66 75 6c 6c 20 73 |ed to th|e full s|
|00006250| 74 6f 72 61 67 65 20 20 | 6c 65 6e 67 74 68 20 20 |torage |length |
|00006260| 28 63 68 61 72 20 20 61 | 6e 64 20 20 62 69 6e 61 |(char a|nd bina|
|00006270| 72 79 20 20 64 61 74 61 | 20 20 69 73 0a 20 20 20 |ry data| is. |
|00006280| 20 72 65 74 75 72 6e 65 | 64 20 66 72 6f 6d 20 53 | returne|d from S|
|00006290| 51 4c 20 53 65 72 76 65 | 72 20 61 6c 72 65 61 64 |QL Serve|r alread|
|000062a0| 79 20 70 61 64 64 65 64 | 20 74 6f 20 74 68 65 20 |y padded| to the |
|000062b0| 66 75 6c 6c 20 6c 65 6e | 67 74 68 29 2e 0a 0a 20 |full len|gth)... |
|000062c0| 20 6f 20 57 68 65 6e 20 | 63 6f 70 79 69 6e 67 20 | o When |copying |
|000062d0| 69 6e 20 66 72 6f 6d 20 | 61 20 66 69 6c 65 2c 20 |in from |a file, |
|000062e0| 64 61 74 61 20 69 73 20 | 74 72 61 6e 73 66 65 72 |data is |transfer|
|000062f0| 72 65 64 20 20 75 6e 74 | 69 6c 20 20 65 69 74 68 |red unt|il eith|
|00006300| 65 72 20 20 74 68 65 0a | 20 20 20 20 6e 75 6d 62 |er the.| numb|
|00006310| 65 72 20 20 6f 66 20 20 | 62 79 74 65 73 20 20 69 |er of |bytes i|
|00006320| 6e 64 69 63 61 74 65 64 | 20 20 68 61 76 65 20 20 |ndicated| have |
|00006330| 62 65 65 6e 20 63 6f 70 | 69 65 64 20 6f 72 20 74 |been cop|ied or t|
|00006340| 68 65 20 74 65 72 6d 69 | 6e 61 74 6f 72 20 69 73 |he termi|nator is|
|00006350| 0a 20 20 20 20 65 6e 63 | 6f 75 6e 74 65 72 65 64 |. enc|ountered|
|00006360| 2e 20 20 4f 6e 63 65 20 | 61 20 6e 75 6d 62 65 72 |. Once |a number|
|00006370| 20 6f 66 20 20 62 79 74 | 65 73 20 20 65 71 75 61 | of byt|es equa|
|00006380| 6c 20 20 74 6f 20 20 74 | 68 65 20 20 66 69 6c 65 |l to t|he file|
|00006390| 20 20 73 74 6f 72 61 67 | 65 0a 20 20 20 20 6c 65 | storag|e. le|
|000063a0| 6e 67 74 68 20 20 68 61 | 73 20 20 62 65 65 6e 20 |ngth ha|s been |
|000063b0| 74 72 61 6e 73 66 65 72 | 72 65 64 2c 20 74 68 65 |transfer|red, the|
|000063c0| 20 72 65 73 74 20 6f 66 | 20 74 68 65 20 64 61 74 | rest of| the dat|
|000063d0| 61 20 69 73 20 66 6c 75 | 73 68 65 64 20 75 6e 74 |a is flu|shed unt|
|000063e0| 69 6c 0a 20 20 20 20 74 | 68 65 20 74 65 72 6d 69 |il. t|he termi|
|000063f0| 6e 61 74 6f 72 20 69 73 | 20 65 6e 63 6f 75 6e 74 |nator is| encount|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
