Copies definitions for specified views, rules, defaults, triggers, or procedures from a database to an operating system file or from an operating system file to a database.
The defncopy utility cannot copy
table definitions or reports created with Report Workbench™.
defncopy {in filename dbname | out filename dbname
[owner.]objectname [[owner.]objectname]...
[-v] [-X]
[-a display_charset]
[-I interfaces_file]
[-J [client_charset]]
[-K keytab_file]
[-P password]
[-R remote_server_principal]
[-S [server]]
[-U username]
[-V [security_options]]
[-z language]
[-Z security_mechanism]
{in filename dbname | out filename dbname
[owner.]objectname [[owner.]objectname...] }
Specifies the direction of definition copy.
Specifies the name of the operating system file destination or source for the definition copy. The copy out overwrites any existing file.
Specifies the name of the database to copy the definitions from or to.
Specifies name(s) of database object(s) for defncopy to copy out. Do not use objectname when copying definitions in.
Allows you to run defncopy from a terminal where the character set differs from that of the machine on which defncopy is running. -a in conjunction with -J specifies the character set translation file (.xlt file) required for the conversion. Use -a without -J only if the client character set is the same as the default character set.
Allows you to specify the name and location of the interfaces file to search when connecting to Adaptive Server. If you do not specify -I, defncopy looks for an interfaces file (sql.ini for Windows platforms) located in the ini directory below the directory specified by the SYBASE environment variable.
Specifies the character set to use on the client. A filter converts input between client_charset and the Adaptive Server character set.
-J client_charset requests that Adaptive Server convert to and from client_charset, the client’s character set.
-J with no argument sets character set conversion to NULL. No conversion takes place. Use this if the client and server are using the same character set.
Omitting -J sets the character set to a default for the platform. (See the System Administration Guide for more information about character sets and the associated flags.
The ascii_7 character set is compatible with
all character sets. If either the Adaptive Server’s or
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.
Can be used only with DCE security. It specifies a DCE keytab file that contains the security key for the user name specified with -U option. Keytab files can be created with the DCE dcecp utility. See your DCE documentation for more information.
If the -K option is not supplied, the user of defncopy must be logged in to DCE with the same user name as specified with the -U option.
Allows you to specify your password. This option is ignored if -V is used.
Specifies the principal name for the server. By default, a server’s principal name matches the server’s network name (which is specified with the -S option or the DSQUERY environment variable). The -R option must be used when the server’s principal name and network name are not the same.
Specifies the name of the Adaptive Server to connect to. Without -S, defncopy looks for the server specified by your DSQUERY environment variable.
Allows you to specify a login name. Login names are case sensitive. If you do not specify username, defncopy uses the current user’s operating system login name.
Specifies network-based user authentication. With this option, the user must log in to the network’s security system before running the utility. In this case, users must supply their network user name with the -U option; any password supplied with the -P option is ignored.
-V can be followed by a security_options string of key-letter options to enable additional security services. These key letters are:
c – Enable data confidentiality service
i – Enable data integrity service
m – Enable mutual authentication for connection establishment
o – Enable data origin stamping service
q – Enable out-of-sequence detection
r – Enable data replay detection
Displays the version number and copyright message of defncopy and returns to the operating system.
Specifies that, in this connection to the server, the application initiate the login with client-side password encryption. defncopy (the client) specifies to the server that password encryption is desired. The server sends back an encryption key, which defncopy uses to encrypt your password, and the server uses the key to authenticate your password when it arrives.
The official name of an alternate language that the server uses to display defncopy prompts and messages. Without the -z flag, defncopy uses the server’s default language. Add languages to an Adaptive Server at installation, or afterwards with the utility langinstall or the stored procedure sp_addlanguage.
Specifies the name of a security mechanism to use on the connection.
Security mechanism names are defined in the libtcl.cfg configuration file located in the ini subdirectory below the Sybase installation directory. If no security_mechanism name is supplied, the default mechanism is used. For more information on security mechanism names, see the description of the libtcl.cfg file in the Open Client and Open Server Configuration Guide for Microsoft Windows.
Copies definitions from the file new_proc into the database stagedb on server “MERCURY.” The connection with “MERCURY” is established with a user of name “sa” and a NULL password.
defncopy -Usa -P -SMERCURY in new_proc stagedb
Copies definitions for objects sp_calccomp and sp_vacation from the employees database on the Sybase server to the file dc.out. Messages and prompts are displayed in “french.” The user is prompted for a password.
defncopy -S -z french out dc.out employees sp_calccomp sp_vacation
Invoke the defncopy program directly from the operating system. defncopy provides a non-interactive way of copying out definitions (create statements) for views, rules, defaults, triggers, or procedures from a database to an operating system file. Alternatively, it copies in all the definitions from a specified file.
You must have select permission on the sysobjects and syscomments tables to copy out definitions; you do not need permission on the object itself.
You must have the appropriate create permission for the type of object you are copying in. Objects copied in belong to the copier. A System Administrator copying in definitions on behalf of a user must log in as that user to give the user proper access to the reconstructed database objects.
The in filename or out filename and the database name are required and must be unambiguously stated. For copying out, use file names that reflect both the object’s name and its owner.
defncopy ends each definition that it copies out with the comment
/* ### DEFNCOPY: END OF DEFINITION */
When assembling definitions in an operating system file to be copied into a database using defncopy, each definition must be terminated using the “END OF DEFINITION” string.
Enclose values specified to defncopy in quotation marks if they contain characters that could be significant to the shell.
WARNING! Long comments (more than 100 characters) placed before a create statement may cause defncopy to fail.
defncopy for System 11 is built with Client-Library. The defncopy user interface is unchanged except for the following:
New command-line options have been added to enable network-based security services on the connection:
-K keytab_file -R remote_server_principal -V security_options -Z security_mechanism
The -y sybase_directory option has been removed.
