Mon, 21/12/09 – 13:51 | Comments

Iridium Consulting, the first Murex integrator in North America, and Murex S.A.S., the leading provider of cross-asset trading, risk management and processing solutions, today announced that Iridium has joined the Murex Partnership Programme as a …

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 2009Comments

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.8.4_1055]
Rating: 0.0/10 (0 votes cast)
VN:F [1.8.4_1055]
Rating: 0 (from 0 votes)
Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

blog comments powered by Disqus