Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
HTYP_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false software
HTYP_SWVers varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false version
HTYP_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false hardware
HTYP_Text varchar (81) VARCHAR2 (81 CHAR) varchar(81) varchar (81) true description
HTYP_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true "BS2000", "UNIX", "WINDOWS"... for editing
HTYP_LicenseType varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true license type
HTYP_LicenseClass char (1) CHAR (1 CHAR) char(1) char (1) true licence class (minimum)
HTYP_SystemId char (3) CHAR (3 CHAR) char(3) char (3) true system id for Exekutor
HTYP_PCount int NUMBER(38,0) int int false this license class is valid for up to HTYP_PCount processors
HTYP_LoginMask varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true login description mask

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_HTYP HTYP_SW, HTYP_SWVers, HTYP_HW, HTYP_PCount true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File