xample 3 Copies data back into Adaptive Server using the saved format file, pub_form: bcp pubs2..publishers in pub_out -f pub_form Example 4 Enter the single letter exactly as it appears below: To see examples of datatypes, enter "?" at the prompt: Enter the file storage type of field 'pub_id' ['char']:? Invalid column type. Valid types are: : same type as Adaptive Server column. c : char T : text i : int s : smallint t : tinyint f : float m : money b : bit d : datetime x : binary I : image D : smalldatetime r : real M : smallmoney n : numeric e : decimal Example 5 Copies a data file created with a character set used on a VT200 terminal into the pubs2..publishers table. The -q flag translates it. The -z flag displays bcp messages in French: bcp pubs2..publishers in vt200_data -J iso_1 -q vt200 -z french Example 6 (UNIX only) Specifies that you are using a Macintosh, running bcp on a workstation that is using roman8, with the file system on another machine that uses iso_1: bcp pubs2..publishers in -a mac -J roman8 -q iso_1 Example 7 Specifies that Adaptive Server send 40K of text or image data using a packet size of 4096 bytes: bcp pubs2..publishers out -T 40960 -A 4096 Usage Use this syntax for bcp_r if you are using threaded drivers. Use this syntax for bcp_dce if you are using threaded drivers in the IBM platform. The current version of bcp ignores the -y sybase_directory parameter. You cannot use named pipes to copy files in or out. Error message format is different than earlier versions of bcp. If you have scripts that perform routines based on the values of these messages you may need to rewrite them, for example: The display message that indicates the number of rows transferred has been changed. During a session, this version of bcp periodically reports a running total of rows transferred. This message replaces the "1000 rows transferred" message displayed by the previous bcp. Permissions You must have an Adaptive Server account and the appropriate permissions on the database tables or views, as well as the operating system files to use in the transfer to use bcp. To copy data into a table, you must have insert permission on the table. To copy a table to an operating system file, you must have select permission on the following tables: the table to copy sysobjects syscolumns sysindexes Tables used sysaudits_01 - sysaudits_08
关闭本页
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
