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.
FSMExtractorProp
The following window is opened. Select the FTM FSM SQL Properties entry.
displayFSMExtractorProp
Press F1 to get help for this window. Context sensitive help is also available for each component (field , list box, and so on).
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:
$Date
This will be replaced by the current date at run time.
STime
This marker will be replaced by the current time at run time.
$ModelName
This will be replaced by the selected model name.
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.
$FileName
This is the name of the generated file.
$PluginVersion:
This is the version of the FSM SQL Extractor plug-in.
$Date:
This is the date when the file is generated.
$Time:
This is the time when the file is generated.
$ModelName:
This is the name of the selected model.
$ModelLastChanged:
This is the data and time when the selected model was last saved.
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:
– Script Name:   Output_PMP Sample _20090616_174003.txt
– Generated:   2009-06-16 17:40:03 IST
– Model Name:   PMP Sample
– Model Version:   2009-05-29 16:29:54 IST
– Extractor Version:   EPP_1.07_b008 09/05/21 10:17:47
– W A R N I N G :   At the time this file was generated,
                    the model contained unsaved changes
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.
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.