Name Type MSSql Type Oracle Type DB2 Nullable Description
MQRWP_PK int NUMBER(38,0) int false Primary Key
MQRWP_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) true UC4 System Name
MQRWP_CAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Call Address
MQRWP_CSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Call Routine Name
MQRWP_CAcv int NUMBER(38,0) int true Call ACV
MQRWP_BAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Back Address
MQRWP_BSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Back Routine Name
MQRWP_BAcv int NUMBER(38,0) int true Back ACV
MQRWP_FAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true From Address
MQRWP_LogAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Logical Address
MQRWP_PhysAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Physical Address
MQRWP_BTable varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Back Table (MQCP001, MQCP002...)
MQRWP_SchedTime datetime DATE timestamp true Scheduling Time
MQRWP_Status int NUMBER(38,0) int true Status (0=not sended, 1=sended)
MQRWP_Priority int NUMBER(38,0) int true Priority (0=high, 255=low)
MQRWP_DRole varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Destination Role (e.g. "*PRIMARY")
MQRWP_LAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) true Server processes this message now
MQRWP_Len int NUMBER(38,0) int true Length
MQRWP_Msg varbinary(max) BLOB blob(128 M) INLINE LENGTH 30000 COMPACT true Message Content

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_MQ2RWP_Prio MQRWP_Priority, MQRWP_SchedTime, MQRWP_PK false false false false
NK_MQ2RWP_SchTime MQRWP_SchedTime false false false false
PK_MQ2RWP MQRWP_PK true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File