applies only when you are bulk copying in; it has no effect on bulk copying out. -e errfile is the full path name of an error file where bcp stores any rows that it was unable to transfer from the file to the database. Error messages from the bcp program appear on your terminal. bcp creates an error file only when you specify this parameter. -f formatfile is the full path name of a file with stored responses from a previous use of bcp on the same table. After you answer bcp's format questions, it prompts you to save your answers in a format file. Creation of the format file is optional. The default file name is bcp.fmt. The bcp program can refer to a format file when you are copying data so that you do not have to duplicate your previous format responses interactively. Use the -f parameter only if you previously created a format file that you want to use now for a copy in or copy out. If you do not specify this parameter, bcp queries you for format information interactively. -F firstrow is the number of the first row to copy from an input file (default is the first row). -g id_start_value specifies the value of the IDENTITY column to use as a starting point for copying data in. You cannot use the -g and -E flags together. -I interfaces_file specifies the name and location of the interfaces file to search when connecting to Adaptive Server. If you do not specify -I, bcp looks for an interfaces file (sql.ini on Windows platforms) located in the ini directory, which is below the directory specified by the SYBASE environment variable. -J client_charset specifies the character set to use on the client. bcp uses a filter to convert input between client_charset and the Adaptive Server character set. -J client_charset requests that Adaptive Server convert to and from client_charset, the character set used on the client. -J with no argument disables character set conversion. Use this if the client and server use the same character set. Omitting -J sets the character set to a default for the platform, which may not necessarily be the character set that the client is using. See the System Administration Guide for more information about character sets and associated flags. The following error message will appear if an incorrect or unrecognized character set is named with the -J parameter: Unrecognized localization object. Using default value 'iso_1'. Starting copy... => warning. -L lastrow is the number of the last row to copy from an input file (default is the last row). -m maxerrors is the maximum number of errors permitted before bcp aborts the copy. bcp discards each row that it cannot build, counting each rejected row as one error. If you do not include this parameter, bcp uses a default value of 10. -P password specifies an Adaptive Server password. If you do not specify -P password, bcp prompts for a password. You can leave out the -P flag If your password is NULL. -q datafile_charset runs bcp to copy character data to or from a file system that uses a character set different from the client character set. In Japanese language environments, the -q flag translates Hankaku Katakana (half-width characters) into Zenkaku Katakana (full-width characters). The following error message will appear if the character translation file(s) named with the -q parameter is missing, or you mistype the name(s): Error in attempting to determine the size of a pair of translation tables.:'stat' utility failed. The ascii_7 character set is compatible with all character sets. If either the Adaptive Server character set or the client's character set is set to ascii_7, any 7-bit ASCII character is allowed to pass between client and server unaltered. Other characters produce conversion errors. Character set conversion issues are covered more thoroughly in the System Administration Guide. -r row_terminator specifies the row terminator. Warning! Do not use -t or -r parameters with bcp in native format. Results are unpredictable and data could become corrupted. When specifying terminators from the command line with the -t or -r parameter, you must escape characters that have special significance to the Windows NT Command Prompt shell (see the following examples). Either place a backslash in front of the special character or enclose it in quotes. This is not necessary when bcp prompts you (interactive mode). -R remote_server_principal specifies the principal name for the server as defined to the security mechanism. By default, a server's principal name matches the server's network name (which is specified with the -S parameter or the DSQUERY environment variable). Use the -R parameter when the server's principal name and network name are not the same. -S server specifies the name of the Adaptive Server to which to connect. If you specify -S with no argument, bcp uses the server specified by the DSQUERY environment variable. -t field_terminator specifies the default field terminator. Warning! Do not use -t or -r parameters with bcp in native format. Results are unpredictable and data could become corrupted. -T text_or_image_size allows you to specify, in bytes, the maximum length of text or image data that Adaptive Server sends. The default is 32K. If a text or an image field is large
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
