Select Query in the receiver JDBC

[Former Member]

Hello all,

Is it Possible to use the select query in eceiver JDBC.

Thanks,

Srinivasa

[Former Member · Accepted solution]

After selecting what you will do with the message?

If you ask incomplete question or if you dont give much information you will not get exact reply as your expecting. So please give as much information as you can.

Cheers,

---Satish

[Former Member · Accepted solution]

Hi Satish,

What I meant was ,a part from providing the Message structure at the receiver side which builts internally a Select statement,is there any other way to write a Select Query some where .

Thanks,

Srinivasa

[Former Member · Accepted solution]

Hi Srinivas,

You can either create the structure or can directly write the SQL_QUERY or| SQL_DML statement where you will specifty the action SQL_QUERY | SQL_DML .

So you can use either XML SQL Format or Native SQL Format. Please see this help srini:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

---Satish

[former_member200962]

SELECT is very much possible in receiver JDBC scenario....we normaly use the SELECT when there is a SYNC communication involved in the JDBC scenario....so that you make a request to the DB using the SELECT statement and in return the DB responds with the columns you selected.

Regards,

Abhishek.

[Former Member]

HI Srinivasa,

No, Select query is not pos for receiver JDBC....its only for sender JDBC....you can use insert,update or delete for receiver JDBC....

Regds,

Pinangshuk.

[former_member181985]

>No, Select query is not pos for receiver JDBC....its only for sender JDBC....you can use insert,update or delete for receiver JDBC....

Pinangshuk, are you sure?