Automic Support tells me "The contents that resided in table uc_msg have been completed redistributed throughout multiple tables with different column names as well. Unfortunately this means there is no simple way to redesign your SQL query previously used as the data is found across multiple tables with different names UC_MSGDT, UC_MSGKD, UC_MSGL, UC_MSGT, UC_MTYPE, etc."
Querying multiple tables is beyond my SQL knowledge, can someone explain how to query multiple tables.
01 select msg_id, msg_text 02 from uc_msg 03 where msg_area = 'UC_0001' 04 and msg_lang = '&$SYS_LANGUAGE#' 05 and msg_type = 'D' 06 and msg_id >= 1800 07 and msg_id <= 1899 08 order by msg_id
I unfortunately do not have a V10 System on short hand - can you pls post the output of this query (or a part of it) to see what should be searched for.
As far As I can see its some status info....
I received a solution from Dennis Strenkowski.
select msg_idnr, msgtx_text
from MSG, MSGTX
where msg_idnr = msgtx_msg_idnr
and msgtx_msgl_short = '&$SYS_LANGUAGE#'
and msg_msgt_type = 'D'
and msg_oh_idnr = 45002
and msg_idnr >= 1800
and msg_idnr <= 1899
order by msg_idnr