Name Type MSSql Type Oracle Type DB2 Nullable Description
OHGF_OH_Idnr int NUMBER(38,0) int false Connection to OH
OHGF_Lnr int NUMBER(38,0) int false Line Number
OHGF_Type char (1) CHAR (1 CHAR) char(1) false Type of filter line (H=single host, F=filter)
OHGF_Name varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Wildcard filter to hostname
OHGF_Version varchar (12) VARCHAR2 (12 CHAR) varchar(12) true Wildcard filter to UC4 version of host
OHGF_HW varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Wildcard filter to platform hardware of host
OHGF_SW varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Wildcard filter to platform software of host
OHGF_SWVers varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Wildcard filter to platform software version of host
OHGF_Archive1 varchar (60) VARCHAR2 (60 CHAR) varchar(60) true Wildcard filter to Archive1 of host
OHGF_Archive2 varchar (20) VARCHAR2 (20 CHAR) varchar(20) true Wildcard filter to Archive2 of host
OHGF_HostRole varchar(256) VARCHAR2 (256 CHAR) varchar(256) true Wildcard filter to HostRole of host

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OHGF OHGF_OH_Idnr, OHGF_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OHGF_OHG OHGF_OH_Idnr OHG_OH_Idnr

Return to the Index File