Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
MQQWP_PK int NUMBER(38,0) int int false Primary Key
MQQWP_System varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true UC4 System Name
MQQWP_CAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Call Address
MQQWP_CSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Call Routine Name
MQQWP_CAcv int NUMBER(38,0) int int true Call ACV
MQQWP_BAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Back Address
MQQWP_BSRName varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Back Routine Name
MQQWP_BAcv int NUMBER(38,0) int int true Back ACV
MQQWP_FAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true From Address
MQQWP_LogAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Logical Address
MQQWP_PhysAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Physical Address
MQQWP_BTable varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Back Table (MQCP001, MQCP002...)
MQQWP_SchedTime datetime DATE timestamp timestamp true Scheduling Time
MQQWP_Status int NUMBER(38,0) int int true Status (0=not sended, 1=sended)
MQQWP_Priority int NUMBER(38,0) int int true Priority (0=high, 255=low)
MQQWP_DRole varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Destination Role (e.g. "*PRIMARY")
MQQWP_LAddr varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Server processes this message now
MQQWP_QState smallint NUMBER(38,0) smallint smallint true State of message (1=unprocessed, 2=locked, 3=processed)
MQQWP_Alarm smallint NUMBER(38,0) smallint smallint true Message is in state 'Alarm' (0=no, 1=yes)
MQQWP_RetryCnt smallint NUMBER(38,0) smallint smallint true Count of processed releases or retries
MQQWP_MsgInfo varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true ShortText for Message
MQQWP_CrashInfo varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Crash Information
MQQWP_SentAlarm smallint NUMBER(38,0) smallint smallint true 0=new message, 1=alarm was already evaluated
MQQWP_Len int NUMBER(38,0) int int true Length
MQQWP_Msg varbinary(max) BLOB blob(128 M) INLINE LENGTH 30000 COMPACT bytea true Message Content

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_MQ1QWP_Prio MQQWP_Priority, MQQWP_SchedTime, MQQWP_PK false false false false
NK_MQ1QWP_SchTime MQQWP_SchedTime false false false false
PK_MQ1QWP MQQWP_PK true true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File