FSM SQL Extractor Properties
Before using this function, the properties associated with the model should be reviewed. Open the FTM model
in the Modeling perspective. Select the model, right-click its name, and select the File Properties option.

The following window is opened. Select the FTM FSM SQL Properties entry.
Press F1 to get help for this window. Context sensitive help is also available for each component (field
, list box, and so on).
These properties are stored in a properties file (resources/File.properties) in
the same project as the model. If a model is transferred to another workspace, these properties will not need
to be setup again, but it's enough to transfer the properties file.

| Item | Description |
|---|---|
| Path | Displays the relative path of the selected resource |
| SQL file name: | The file name where the FSM Extractor plug-in writes the generated SQL statements. The
file name can be customized by using three available markers as follows:
Note: These markers are optional and can be used in any position and in any order.
For example, if the
<SQL file name:> fields contains <Output_$ModelName_$Date_Time.sql>, the generated name is
<Output_FSM Sample Model_20090201_185601.sql> Note: The file will be generated in the "SQL Extracts"
folder in the Model's project folder
|
| Comment template: | The text entered in this field is added as a comment at the top of the generated SQL
file. Up to 2000 characters can be entered.
Note: If the selected model contains unsaved modifications, this marker is replaced with the date and time at
run time. A warning message also appears as a comment in the output file.
Example:
|
| Initial ID | The start value of the unique ID column in the generated SQL Insert Statements. This value is incremented by 1 for each subsequent statement generated. |