My Current data looks like this:
||ENTITY_INTERNAL_ID||LIT_STATIC_TYPE||ORIGIN_ENTITY_TYPE||ORIGIN_ENTITY_ID||LIT_STATIC_TYPE||TXT_SEQ_NUM||LIT_VALUE|| |JW1jmnij|01|DECONTRL|ENTER_SIZELB173|01|1|~OK| |JW1jmnij|01|DECONTRL|CANCEL_SIZELB173|01|2|~Cancel| |JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)"d]8|01|3|31000 Bytes| |JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m(tirB|01|3|2 Bytes| |JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)%3VV|01|3|32000 Bytes| |JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)'g\A|01|3|63882 Bytes| |JW1jmnij|01|DEVAL|COM1_MESSAGE_SIZE_SENDLB!#m)/bG$|01|3|64000 Bytes| |JW1jmnij|01|DEDTELEM|COM1_MESSAGE_SIZE_SENDLB173|01|3|Message Size| |JW1jmnij|01| | |01|5|Message Size Parameter|
This was pulled by the SQL query: select entity_Internal_Id, lit_Static_Type, origin_Entity_Type, origin_Entity_Id, lit_Static_Type, txt_Seq_Num, lit_value from Wdd0d040 where entity_Internal_Id = 'JW1jmnij' and lit_Static_Type = '01' order by txt_Seq_Num
When running a similar query in hibernate: from Wdd0d040 where wdd40Key.entityInternalId = 'JW1jmnij' and litStaticType = '01' order by wdd40Key.txtSeqNum
I get the following results: Orig {DECONTRL::ENTER_SIZELB173 } Seq:1 Value=[~OK ] Orig {DECONTRL::CANCEL_SIZELB173 } Seq:2 Value=[~Cancel] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig {DEVAL ::COM1_MESSAGE_SIZE_SENDLB!#m(tirB} Seq:3 Value=[2 Bytes] Orig { :: } Seq:5 Value=[Message Size Parameter
As you can see: 1. Missing the entry that starts with "DETELEM" value 2. All Values for lit_value column are the same "2 Bytes".
|
|