Updates session properties for a set of sessions that meet specified conditions. You can update all sessions in a folder or a list of sessions. To update a list of sessions, create a persistent input file. The list can contain a specific list of sessions, or it can contain conditions such as a name pattern or a property value. Use ExecuteQuery to generate a persistent input file.
When you run MassUpdate, you can view information such as the folder name, the number of sessions that are successfully updated or failed, and the names of the sessions that are updated. You can view the status of the update in the command line window or in a log file that the command generates. You specify the name and path for the log file when you run the command. By default, the log file is stored in the directory where you run the command.
Use MassUpdate to update a session property across multiple sessions when a PowerCenter version changes a default value.
You cannot update dependent session properties.
Before you update the sessions, you can also run MassUpdate in a test mode to view changes. To view a sample log file, see
Sample Log File.
The MassUpdate command uses the following syntax:
pmrep massupdate
-t <session_property_type (session_property, session_config_property, transformation_instance_attribute, session_instance_runtime_option)>
-n <session_property_name>
-v <session_property_value>
[-w <transformation_type>]
{-i <persistent_input_file> | -f <folder_name> }
[-o <condition_operator (equal, unequal, less, greater)>]
[-l <condition_value>]
[-g <update_session_instance_flag>]
[-m <test_mode>]
[-u <output_log_file_name>]
The following table describes
pmrep
MassUpdate options and arguments:
| |
Required. Session property type to update. Session properties are of the following types:
transformation_instance_attribute
session_instance_runtime_option
|
| |
Required. Name of the attribute or property to update.
|
| |
Required. Value that you want to assign to the property followed by a semicolon.
For example, to assign a value to the property, use the following syntax:
-v "IgnoreNULLInExpressionComparison=Yes;"
Enclose the session property value in double quotes.
|
| |
Required if you update a transformation instance attribute. Transformation type to update. You can update the following transformation types: aggregator, joiner, lookup procedure, rank, sorter, source definition, and target definition.
|
| |
Required if you do not use the -f option. Name of the file that contains the selected list of sessions to update. You can use the
pmrep ExecuteQuery command to run a query and generate this file. MassUpdate returns an error if you specify an object that is not a session. You must use the -i option or the -f option, but not both.
|
| |
Required if you do not use the -i option. Name of the folder. Use to update all sessions in a folder. You must use the -i option or the -f option, but not both.
|
| |
Required if you use condition_value. Part of the condition that defines the session set.
The attribute of a session or session instance is updated when the condition is met.
You can use the following condition operators to update a string: equal or unequal.
You can use the following condition operators to update an integer: equal, unequal, less, or greater.
|
| |
Required if you use a condition operator. Part of the condition. The condition appears as follows:
<session_property_value> <condition operator> <condition_value>
|
|
update_session_instance_flag
|
Required if you update a session instance run-time option.
Optional for the following session property types: session property, session configuration attribute, and transformation instance attribute.
Updates session instances.
You can update an attribute in a session instance if the session instance overrides the attribute.
|
| |
Optional. Runs MassUpdate in test mode. View sessions that will be impacted by the command before you commit changes. You can see the following details in the command line window:
Type of session: reusable or non-reusable
Current value of the session property
Sessions for which the attribute has the same value and are not affected by the command.
|
| |
Optional. Name of the log file that stores the status of the update and basic information about the sessions or session instances. Previous attribute values are also written to this file. If you do not use this option, the details appear in the command line window.
|
The MassUpdate command returns “massupdate successfully completed” or returns “failed to execute massupdate” message. The update might fail for the following reasons:
You did not specify a valid attribute value pertaining to the attribute name.
You specified the correct session property name and the wrong session property type along with it.
You did not specify the -v option that ends with a semicolon while updating a session property value.
You did not specify the -w option while updating a transformation instance attribute.
You did not specify the -g option while updating a session instance run-time option.
You do not have the Repository Services Administrator role.
