V10 SQL query in V12

[Roger Shirley]

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.

 

Original SQL

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

 

Thanks,

[FrankMuffke]

Hi

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....

 

cheers, Wolfgang

[Roger Shirley]

Thanks All,

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

 

 

 

 

 

Roger Shirley

Ops Analyst

702-281-7789