Shared Content for Data Engineering
All Products
updateconnection -t <connection_subtype > -d <connection_name> [{-u <new_user_name> [-p <new_password>|-P <new_password_environment_variable>]}| -K <connection_to_the_Kerberos_server>] [-c <new_connection_string>] [-a <attribute_name> -v <new_attribute_value>] [-s <connection type application, relational, ftp, loader or queue > ] [-l <code page>]
Option | Argument
| Description |
---|---|---|
-t
| connection_subtype
| Required. Displays the connection subtype.
For example, for a Relational connection, connection subtypes include Oracle, Sybase, and Microsoft SQL Server.
For a list of predefined connection subtypes, see
Connection Subtypes.
The connection subtype in the -t option must be valid for the associated connection type specified with the -s option.
|
-d
| connection_name
| Required. Database connection name.
|
-u
| new_user_name
| Optional. User name used for authentication when you connect to the relational database.
|
-p
| new_password
| Optional. Password used for authentication when you connect to the relational database. Use the -p or -P option, but not both.
|
-P
| new_password_
environment_variable
| Optional. Password environment variable used for authentication when you connect to the relational database. Use the -p or -P option, but not both.
|
-K
| -
| Optional. Indicates that the database that you are connecting to runs on a network that uses Kerberos authentication.
|
-c
| new_connection_string
| Optional. Connect string the Integration Service uses to connect to the relational database.
|
-a
| attribute_name
| Optional. Name of the attribute.
|
-v
| new_attribute_value
| Required if you use the -a option. New attribute value of the connection. Enter “yes” to enable new attributes, and “no” to disable new attributes.
|
-s
| connection type application, relational, ftp, loader or queue
| Optional. Type of connection. A connection can be one of the following types:
Default is relational.
The connection subtype in the -t option must be valid for the associated connection type specified with the -s option.
|
-l
| code page
| Optional. Code page associated with the connection.
|
Updated April 22, 2019