Automic Workload Automation

  • 1.  V10 SQL query in V12

    Posted 04-17-2018 12:51 PM

    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,



  • 2.  Re: V10 SQL query in V12

    Posted 05-04-2018 03:13 PM

    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



  • 3.  Re: V10 SQL query in V12
    Best Answer

    Posted 05-04-2018 03:32 PM
      |   view attached

    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