Option | Argument | Description |
|---|---|---|
-t | session_property_type | Required. Session property type to update. Session properties are of the following types:
|
-n | session_property_name | Required. Name of the attribute or property to update. |
-v | session_property_value | 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;" Note: Enclose the session property value in double quotes. |
-w | transformation_type | 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. |
-i | persistent_input_file | 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. |
-f | folder_name | 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. |
-o | condition_operator | 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. |
-l | condition_value | Required if you use a condition operator. Part of the condition. The condition appears as follows: <session_property_value> <condition operator> <condition_value> |
-g | 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. |
-m | test_mode | 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:
|
-u | output_log_file_name | 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. |
Session Property | Session Property Type |
|---|---|
$Source connection value | session_property |
$Target connection value | session_property |
Additional Concurrent Pipelines for Lookup Cache Creation | session_config_property |
Aggregator Data Cache Size | transformation_instance_attribute The transformation_type argument must be aggregator. |
Aggregator Index Cache Size | transformation_instance_attribute The transformation_type argument must be aggregator. |
Allow Temporary Sequence for Pushdown | session_property |
Allow Temporary View for Pushdown | session_property |
Cache Directory | transformation_instance_attribute The transformation_type argument must be aggregator, joiner, or rank. |
Cache LOOKUP( ) function | session_config_property |
Collect performance data | session_property |
Commit Interval | session_property |
Commit Type | session_property |
Constraint based load ordering | session_config_property |
Custom Properties | session_config_property |
DateTime Format String | session_config_property |
Default buffer block size | session_config_property |
Disable this task | session_instance_runtime_option |
DTM buffer size | session_property |
Enable high precision | session_property |
Enable Test Load | session_property |
Fail parent if this task does not run | session_instance_runtime_option |
Fail parent if this task fails | session_instance_runtime_option |
Incremental Aggregation | session_property |
Is Enabled | session_config_property |
Java Classpath | session_property |
Joiner Data Cache Size | transformation_instance_attribute The transformation_type argument must be joiner. |
Joiner Index Cache Size | transformation_instance_attribute The transformation_type argument must be joiner. |
Line Sequential buffer length | session_config_property |
Lookup cache directory name | transformation_instance_attribute The transformation_type argument must be lookup procedure. |
Lookup Data Cache Size | transformation_instance_attribute The transformation_type argument must be lookup procedure. |
Lookup Index Cache Size | transformation_instance_attribute The transformation_type argument must be lookup procedure. |
Maximum Memory Allowed For Auto Memory Attributes | session_config_property |
Maximum Percentage of Total Memory Allowed For Auto Memory Attributes | session_config_property |
On Pre-Post SQL error | session_config_property |
On Pre-session command task error | session_config_property |
On Stored Procedure error | session_config_property |
Output file directory | transformation_instance_attribute The transformation_type argument must be target definition. |
Override tracing | session_config_property |
Parameter Filename | session_property |
Pre 85 Timestamp Compatibility | session_config_property |
Pre-build lookup cache | session_config_property |
Pushdown Optimization | session_property |
Rank Data Cache Size | transformation_instance_attribute The transformation_type argument must be rank. |
Rank Index Cache Size | transformation_instance_attribute The transformation_type argument must be rank. |
Recovery Strategy | session_property |
Reject file directory | transformation_instance_attribute The transformation_type argument must be target definition. |
Rollback Transactions on Errors | session_property |
Save session log by | session_config_property |
Session Log File directory | session_property |
Session retry on deadlock | session_property |
Session Sort Order | session_property When the Integration Service runs in Unicode mode, you can choose the sort order to sort character data in the session. You can configure the following values for the sort order:
|
Sorter Cache Size | transformation_instance_attribute The transformation_type argument must be sorter. |
Source file directory | transformation_instance_attribute The transformation_type argument must be source definition. |
Stop on errors | session_config_property |
Treat source rows as | session_property |
Treat the input link as AND | session_instance_runtime_option |
Write Backward Compatible Session Log File | session_property |