Name Type MSSql Type Oracle Type DB2 Nullable Description
MQCP_PK int NUMBER(38,0) int false Primary Key
MQCP_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) true UC4 System Name
MQCP_CAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Call Address
MQCP_CSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Call Routine Name
MQCP_CAcv int NUMBER(38,0) int true Call ACV
MQCP_BAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Back Address
MQCP_BSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Back Routine Name
MQCP_BAcv int NUMBER(38,0) int true Back ACV
MQCP_FAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true From Address
MQCP_LogAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Logical Address
MQCP_PhysAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Physical Address
MQCP_BTable varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Back Table (MQCP001, MQCP002...)
MQCP_SchedTime datetime DATE timestamp true Scheduling Time
MQCP_Status int NUMBER(38,0) int true Status (0=not sended, 1=sended)
MQCP_Priority int NUMBER(38,0) int true Priority (0=high, 255=low)
MQCP_DRole varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Destination Role (e.g. "*PRIMARY")
MQCP_LAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Server processes this message now
MQCP_Len int NUMBER(38,0) int true Length
MQCP_Msg varbinary(max) BLOB blob(128 M) INLINE LENGTH 30000 COMPACT true Message Content

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_MQ2CP003_BAcv MQCP_BAcv false false false false
NK_MQ2CP003_Prio MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status false false false false
NK_MQ2CP003_SchTime MQCP_SchedTime false false false false
PK_MQ2CP003 MQCP_PK true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File