Setting up column data types in Modeler - optional (SQL code)
Modeler provides a set of Data Types for Columns. Through the Code Generator DLLs, each supplied Data Type is mapped to a data type that is suitable for your target database.
You can change the supplied Column Data Types in Modeler, so that are suited for your target database. If you create a Data Type, its name is not changed when generated in the SQL code.
To change the supplied Column Data Types:
1. In Modeler, open the model for which you want to add a Column Data Type.
2. Open the Model's Property Pages (you can select the Model in the Packages pane).
3. Click the Text tab.
4. In the drop-down list, select Id.
5. Copy the value of the Id to the Clipboard.
6. On the Model's server, use Windows Explorer to search the ModelerATFiles folder for the Id you copied to the Clipboard. If you installed Modeler to the default location, the path of the ModelerATFiles folder is C:\ProgramData\PTC Integrity Modeler\ModelerATFiles.
7. Open the folder you found in the previous step and you will find a subfolder for each version of the model - open the folder for the version of the model with which you are working.
8. In a text editor such as Notepad, open the template.txt file.
9. Find the @TEMPLATE Column entry.
10. In the DATATYPE entry for the Column definition, add the data types, delimited from the other data types by vertical bars. For example, to add a data type named MYDATATYPE, change the text as follows: