Running the FSM Extractor

To generate the SQL script for an FSM Model , right-click a model in the Project Explorer view and select: FTM → Generate FSM SQL
generateFSM_SQL
The generated SQL file is created in the "SQL Extracts" folder in the model's project folder. The file is opened into an SQL File Editor if the "Data tool" feature of RSA is installed, otherwise it is opened in a text editor in the workbench.
Note: The SQL File Editor provides the ability to execute the SQL statements using a database connection configured in the Database Development perspective.

If the DB2® Command Line Processor is to be used to process the generated scripts on the Windows operating system, the Unicode characters in the scripts are not properly recognized unless the value of the DB2CODEPAGE variable has been set to 1208. To do this, issue the following command: db2set DB2CODEPAGE=1208