Command Reference > pmrep Command Reference > UpdateConnection
  

UpdateConnection

Updates the user name, password, connect string, and attributes for a database connection.
The command returns an “operation successfully completed” or returns “operation failed” message. A failure might occur for the following reasons:
The UpdateConnection command uses the following syntax:
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>]
The following table describes pmrep UpdateConnection options and arguments:
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 FTP connections, the valid subtype is FTP.
For a list of predefined connection subtypes, see Connection Subtypes.
Note: 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:
  • - Application
  • - FTP
  • - Loader
  • - Queue
  • - Relational
Default is relational.
Note: 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.
For more information about connection subtypes, see Connection Subtypes.