MQSeries.net :: View topic - Oracle database query from Message Broker

zico · Posted: Mon May 08, 2006 8:51 pm Post subject:

Hi,

How do i use the following SQL query in Message Broker ESQL statement.

Select max(A.Joining_DT) from EMP.EMPDetail A where A.Joining_DT < '12-Dec-9999'

It works fine with SQL Navigator or Toad database tool. Please be informed Joining_DT is date type field and the default date is stored as '12-Dec-9999'. My purpose is to pick the maximum date from the EMPDetail table (under EMP schema) which is less than the default date.

Can anyone please suggest what will be the best ESQL code to perform the query.

Thanks in advance.

Zico