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
- jConnect
- JDBC 7.07
- JDBC 16 ( is version JDBC 7.07 )
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.
SAP Knowledge Base Article - Preview