Mon, 3/05/10 – 8:11 | View Comments

Paris, FRANCE – April 28th, 2010
Murex, the leading provider of cross-asset trading, risk management and processing solutions, announced today new milestones in its strategy to lower TCO, supported by the continued evolution of its …

Read the full story »
Announcements

Official announcements regarding the Murex User Group

Books

Book recommendations. Please contribute book reviews and list your favorite books.

Consulting

Consulting companies specialized in Murex implementations and related services.

Events

Event anouncements; we usually meet 3-4 times per year in London, New York and other financial centers.

FAQ

Frequently asked questions.

Home » Murex Mailing List

Is it possible read read external DDBB from a RQWHERE in Murex?

Submitted by Markus Linke on Wednesday, 8 July 2009View Comments

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). [...]

VN:F [1.9.3_1094]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.3_1094]
Rating: 0 (from 0 votes)
Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

Leave a comment!

You must be logged in to post a comment.

blog comments powered by Disqus