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>

[-w (use parameter in password) |

-x (do not use parameter in password)]}]} |

-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.
To specify a parameter in the password, add the $Param prefix for the -p option and ensure that you use the -w option. Do not use a dollar sign ($) anywhere else in the -p option, and enter the parameter password without spaces. For example, -p '$Param_abc' -w
-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.
-w
-
Optional. Enables you to use a parameter in the password option. pmrep uses the password specified with the -p or -P option as the name of the session parameter at run time.
Valid only if you use the -p or -P option.
If you do not use a parameter in the password option, pmrep uses the user password specified with the -p or -P option.
-x
-
Optional. Disables the use of password parameters if you use the parameter in password.
pmrep uses the password specified with the -p or -P option.
-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.