The Properties window lets you view and edit the properties that apply to components, projects, or jobs.
For the ETL and SQL Transformation projects, use the Properties window to perform these tasks:
To view and edit component properties and values, select the component in the Design window. All properties of the selected component appear in the Properties window.
A property name displayed in bold text in the Properties window indicates that the property is required for the component to operate correctly.
All other properties are optional; use them to fine-tune and configure the component.
The Evaluate option lets you compute and evaluate dynamic property settings at runtime instead of assigning static values at design time.
Select the Evaluate option to allow expressions within component property values. For some property items, this option is by default, selected.
Use the Eval check box in the Properties window to enable or disable evaluation for a property. Once the Evaluate option is activated, you can include JavaScript expressions in the corresponding field using square bracket notation (SBN).
Project and job data, as well as property values, are stored in the Sybase IQ InfoPrimer repository. Most of the records in the repository are not encrypted.
By default, the Encrypt option is selected for the password property.
To encrypt property values, right-click a property name in the Properties window, and select Encrypt.
Alternatively, select the Encrypt check box next to the property value.
You can add or edit custom component properties in the Properties window. Like other properties, custom properties also incorporate a variable that can be referenced in expressions or user-defined procedures.
Click the Property icon in the Properties window to access the configuration window of a selected component.
Select the Propagate rollback option in the Properties window to enable transactionality support for generated jobs or projects.
When you select this option, data is committed at the end of the write operation for a successful execution, and rolled back for an unsuccessful execution. If you do not select the option, the project does not enforce a transaction rollback on successful components, if one or more components fail. Failed components roll back their own transactions. Jobs also, when Propagate rollback is not selected, do not enforce transaction rollbacks on successful projects, if one or more projects fail. Failed projects roll back their own transactions.