Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MQMWP_PK int NUMBER(38,0) int int false Primary Key
MQMWP_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true UC4 System Name
MQMWP_CAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Call Address
MQMWP_CSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Call Routine Name
MQMWP_CAcv int NUMBER(38,0) int int true Call ACV
MQMWP_BAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Back Address
MQMWP_BSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Back Routine Name
MQMWP_BAcv int NUMBER(38,0) int int true Back ACV
MQMWP_FAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true From Address
MQMWP_LogAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Logical Address
MQMWP_PhysAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Physical Address
MQMWP_BTable varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Back Table (MQCP001, MQCP002...)
MQMWP_SchedTime datetime DATE timestamp timestamp true Scheduling Time
MQMWP_Status int NUMBER(38,0) int int true Status (0=not sended, 1=sended)
MQMWP_Priority int NUMBER(38,0) int int true Priority (0=high, 255=low)
MQMWP_DRole varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Destination Role (e.g. "*PRIMARY")
MQMWP_LAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Server processes this message now
MQMWP_Len int NUMBER(38,0) int int true Length
MQMWP_Msg varbinary(max) BLOB blob(128 M) INLINE LENGTH 30000 COMPACT bytea true Message Content
MQMWP_MsgType varchar (20) VARCHAR2 (20 CHAR) varchar(20) varchar (20) true Type of the message

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_MQ1MWP_Prio MQMWP_Priority, MQMWP_SchedTime, MQMWP_PK false false false false
PK_MQ1MWP MQMWP_PK true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File