SAP Knowledge Base Article - Preview

3121673 - How to get export MSSQL JSON_VALUE from SAP ASE - SAP SDK

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

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0

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.