UpdateConnection

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.
-S	odbc_subtype	Optional. Enables the ODBC subtype for an ODBC connection. An ODBC connection can be one of the following ODBC subtypes: - AWS Redshift - Azure DW - Greenplum - Google Big Query - PostgreSQL - Snowflake - SAP HANA - None Default is None.