User Target System


Open ModelSphere allows you to define your own target systems. This functionnality gives you the opportunity to handle any database management systems even the ones that are not explicitly supported by Open ModelSphere

There are two different ways of creating a user target system.


Creating a user target system from a project

Click Tools > Add/Remove Target System système cible > Add and choose from the list the user target system item.


Note that if the user target system item is not available in the list, verify that the file UserTS.typ is into the "targets" directory where the application has been installed. This file must not be altered. A package New User Target System will appear under the Built-in Types node. This is from this package that the user can define new data types.

Use the Add  button from the creation tool bar or from the menu Edit > Add >Type.
         
    Add a data type :

    ADD_USER_TYPE_fr.jpg

Creating a user target system with the template "UserTypeFileTemplate.typ"

The templace file "UserTypeFileTemplate.typ" can be found into the directory \Targets\Template from the main directory of Open ModelSphere. Copy this file into the Target directory of Open ModelSphere to edit a new .typ file. A .typ file contains a list of predifined data types for a given target system. ModelSphere will read this file after the application is launch. The new target system will then be available from the list in Open ModelSphere. Below is an example of type file.

Note that the root-ID is 2000 and must not be modified. 

How to create a user target system file

//    THIS FILE IS A TEMPLATE FILE FOR CREATING USER TARGET SYSTEMS
//    $Date:  06-03-28 11:15 $
//
//    Predefined types

NOTE: The TARGET-ID must be 2000 and higher.
The ROOT-ID 2000 must be kept.

NAME= My target system
VERSION=2.0
TARGET-ID=2003
ROOT-ID=2000

NOTE : The user types must be formated as follow.
The first column represents the list of user data types.
The second column contains the logical data types (see logical.typ) equivalent to the corresponding user data type.
The correspondance with a logical type is optional.

// type, logical type (optional)
TYPES
{
CHAR,             CHARACTER
CHARACTER,  CHARACTER
DATE,
DEC,               DECIMAL
DECIMAL,        DECIMAL
FLOAT,            FLOAT
INT,                  INTEGER
INTEGER,         INTEGER
NUMERIC,        NUMERIC
NUMBER,         NUMERIC
REAL,               REAL
SPECIAL TYPE,
}

NOTE : aliases are optionals.

ALIASES
{
CHAR, CHARACTER
NUMBER, NUMERIC, DECIMAL, DEC, REAL
INT, INTEGER
}