Definition of table: MQ1QWP - Queue for crashed messages

generated: 12.12.2016 18:34:03
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
MQQWP_PK Long Integer 4 UC: Null=False Typ=Auto Primary Key
MQQWP_System Text 8 UC: Null=True UC4 System Name
MQQWP_CAddr Text 32 UC: Null=True Call Address
MQQWP_CSRName Text 8 UC: Null=True Call Routine Name
MQQWP_CAcv Long Integer 4 UC: Null=True Call ACV
MQQWP_BAddr Text 32 UC: Null=True Back Address
MQQWP_BSRName Text 8 UC: Null=True Back Routine Name
MQQWP_BAcv Long Integer 4 UC: Null=True Back ACV
MQQWP_FAddr Text 32 UC: Null=True From Address
MQQWP_LogAddr Text 32 UC: Null=True Logical Address
MQQWP_PhysAddr Text 32 UC: Null=True Physical Address
MQQWP_BTable Text 8 UC: Null=True Back Table (MQCP001, MQCP002...)
MQQWP_SchedTime Date/Time 8 UC: Null=True Scheduling Time
MQQWP_Status Long Integer 4 UC: Null=True Status (0=not sended, 1=sended)
MQQWP_Priority Long Integer 4 UC: Null=True Priority (0=high, 255=low)
MQQWP_DRole Text 32 UC: Null=True Destination Role (e.g. "*PRIMARY")
MQQWP_LAddr Text 32 UC: Null=True Server processes this message now
MQQWP_QState Integer 2 UC: Null=True State of message (1=unprocessed, 2=locked, 3=processed)
MQQWP_Alarm Integer 2 UC: Null=True Message is in state 'Alarm' (0=no, 1=yes)
MQQWP_RetryCnt Integer 2 UC: Null=True Count of processed releases or retries
MQQWP_MsgInfo Text 255 UC: Null=True ShortText for Message
MQQWP_CrashInfo Text 255 UC: Null=True Crash Information
MQQWP_SentAlarm Integer 2 UC: Null=True 0=new message, 1=alarm was already evaluated
MQQWP_Len Long Integer 4 UC: Null=True Length
MQQWP_Msg Memo 0 UC: Typ=blob L=0 Null=True inlinelength=30000 db2lobsize=128_M Message Content


Indexes:

Name Fields
NK_MQ1QWP_Prio MQQWP_Priority, MQQWP_SchedTime, MQQWP_PK
NK_MQ1QWP_SchTime MQQWP_SchedTime
PK_MQ1QWP MQQWP_PK


Return to the Index File