Symptom
MSSQL:
select JSON_VALUE(Event_Payload, '$.BORHeader.eventId') AS EventId,
JSON_VALUE(Event_Payload, '$.BORHeader.eventSource') AS EventSource,
JSON_VALUE(Event_Payload, '$.BORHeader.payloadType') AS PayloadType,
JSON_VALUE(Event_Payload, '$.BORHeader.etBranchNumber') AS BranchNumber,
JSON_VALUE(Event_Payload, '$.BORHeader.etBaseAcctNumber') AS BaseAcctNumber,
JSON_VALUE(Event_Payload, '$.Payload.header.eventId') AS HeaderEventId,
JSON_VALUE(Event_Payload, '$.Payload.msgType') AS MsgType,
JSON_VALUE(Event_Payload, '$.Payload.tradeDate') AS TradeDate,
JSON_VALUE(Event_Payload, '$.Payload.securityID') AS SecurityID
from IncomingReqMsg
Is there a way in SAP ASE to retrieve this information? The output would be something like:
EventId EventSource PayloadType BranchNumber BaseAcctNumber HeaderEventId MsgType TradeDate SecurityId
value-of-the-event-id Value_EventSource Payload_type 12345 123456 value-of-Header-Event-ID NULL NULL NULL
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
Product
Keywords
KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.