Name Type MSSql Type Oracle Type DB2 Nullable Description
OHAF_OH_Idnr int NUMBER(38,0) int false reference to object header (OH)
OHAF_Lnr int NUMBER(38,0) int false Line number
OHAF_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Hostname
OHAF_HostAttrType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true attribute type corresponding to table UC_HTYP
OHAF_Version varchar (12) VARCHAR2 (12 CHAR) varchar(12) true Executor Version
OHAF_HTYP_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) true hardware
OHAF_HTYP_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) true software
OHAF_HTYP_SWVers varchar (32) VARCHAR2 (32 CHAR) varchar(32) true version
OHAF_HostRoles varchar(256) VARCHAR2 (256 CHAR) varchar(256) true Role of host (from INI or edited in object)
OHAF_TcpIpAddr varchar (64) VARCHAR2 (64 CHAR) varchar(64) true TCP/IP address
OHAF_LicCategory varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Licence Category
OHAF_ExcludeFlag smallint NUMBER(38,0) smallint true Include or Exclude row

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OHAF OHAF_OH_Idnr, OHAF_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OHAF_OH OHAF_OH_Idnr OH_Idnr

Return to the Index File