Is it possible read read external DDBB from a RQWHERE in Murex?
You can get to a database within the same SQL server easily enough
1> select top 2 M_NB into tempdb..MYTEMP_DBF from TRN_HDR_DBF 2> (2 rows affected)
Then: RQWHERE(‘TRN_HDR_DBF.M_NB in (select M_NB from tempdb..MYTEMP_DBF )’,”)
works ok.
Your life will be easier if you stick to Murex naming conventions for tables (_DBF suffix) and fields (M_ prefix). [...]



