I need pick bussiness field from message body on more high level , I don't want to modify every process logic.

And if the business service is builtIn process not custom process.  for example:

EnsLib.HL7.Service.TCPService -> EnsLib.HL7.Operation.TCPOperation

above flow will insert hl7 request and response to table EnsLib_HL7.Message and other message tables. 

I want to get message body to parse it before insert.

But The EnsLib.HL7.Service.TCPService   and EnsLib.HL7.Operation.TCPOperation is builtIn .

So I think ensembe is provide some hook like before and after

EnsLib.HL7.Service.TCPService ->before hook ->sendSync->After hook-> EnsLib.HL7.Operation.TCPOperation

Thank You.

I tryed ROW_NUMBER() ,got follow error:

Mistake in SQL statement, ERROR #5540: SQLCODE: -359 Message: User defined SQL function 'SQLUSER.ROW_NUMBER' does not exist

The problem is not what I use either ROW_NUMBER() or ROW_NUM fake field.

The point is the flow .Cache first find ROW_NUMBER() in self platform but platform not contain oracle function.

Or is it platform's limit?  I don't know where is the border..

Thank You,

Thank You, My database is oracle 11g

It use ROWNUM as paging condition ,like this 

select * from order_info where ROWNUM <=3 

But above query can't execute because follow error in ensemble sql console

Not found ROWNUM field in  table order_info

ROWNUM is a fake field for oracle like %VID in Caché  

seems like the query external datase's flow  is Caché  parse -> sql gateway, It cause above problem.