Skip to Content
author's profile photo Former Member
Former Member

Regarding JDBC receiver adapter select query.

Dear Experts,

Scenario is Proxy to JDBC synchronous scenario, where I need to SELECT records based on some "KEY" field value search criteria & obtain response back in to PI.

Present Structure below for receiver JDBC adapter:


Statement

TableName

action

table

access (0 to unbounded)

FLD1

FLD2

KEY (0 to unbounded)

FLD1

compareOperation(attribute)

FLD2

compareOperation(attribute)

For instance If we have 3 records sent from source then output is getting generated as below

RESULT/OUTPUT:

Statement

TableName

action

table

access1

access2

access3

KEY1

KEY2

KEY3

As per structure specified in help.sap "access" node & "KEY" nodes were maintained at same level

Link:http://help.sap.com/saphelp_srm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.html

But during generation of SELECT statement for multiple records as specified above under RESULT/OUTPUT , I hope there will not be differentiation of which "KEY" field node belongs to which "access" node. Hence If "KEY" field node is made as sub node to "access" node will this work ? result output will be in below format

Statement

TableName

action

table

access1

KEY1

access2

KEY2

access3

KEY3

Can you please let me know whether above SELECT format works correctly for receiver JDBC SELECT query OR how should I change my structure. Do I need to change the structure in such way like, for each record one "Statement" node need to be generated ELSE one Statement with multiple "access" nodes & "KEY" node as sub node to it will work.

Kindly provide your inputs.


Regards,

Vivek.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 17, 2016 at 03:26 AM

    Hello Vivek,

    • Is the select query the same for each 3 records or different?
      • If Same, then you need to have your mapping such that 3 STATEMENT level tags are created one for each Record.
      • If different, you would need 3 different types of statements created as per your SELECT query

    If you had an example, that would be easier to explain and validate.

    Regards

    Bhavesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2016 at 12:04 PM

    Hi Bhavesh,

    Thanks for your reply. Its a same SELECT query for all records. Hence can I consider that 3 different Statement records need to be created separately or one Statement node with multiple "access" nodes (& Key field node as sub node to each access node) under it will work ?

    Regards,

    Vivek.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.