cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Recv - Select and Update

prabhu_s2
Active Contributor
0 Kudos

Hi,

With JDBC recv, can we select records with status "10" and update the selected records with status "10" to "20" in the same XML strucutre?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Prabhu,

With JDBC recv, can we select records with status "10" and update the selected records with status "10" to "20" in the same XML strucutre?

Yes, you can do that. Go through the SAP Help documents for the required structure. Use "SQL_QUERY" as the action to be performed.

You can use graphical and XSL mapping for this, but I would prefer XSL for the same.

Use Sync send from IP to get the response back.

Regards,

Neetesh

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

By using SQL_QUERY -- you can only fetch the results from DB (sql statemets like simple query or joins)

SQL_DML -- you can update,insert or delete.

I think Select & update in Single statement is not possible.

As neetesh said you have to use intermediate structure and your scenario will be

File --> JDBC(select)

JDBC_Response-> JDBC(update)

Regards

Ramg

Former Member
0 Kudos

I think you mean to say JDBC Sender, because in JDBC receiver you can not select any message. you can just pass it.

Is that you want?

Thanks,

Hetal

prabhu_s2
Active Contributor
0 Kudos

It is JDBC Recv which i mean that can do the select and update as performed when using jdbc sender

former_member568822
Active Participant
0 Kudos

Hi,

You can use SQL stored procedure to achieve these. Just create the select and update inside the stored procedure and use JDBC Recv to execute the stored procedure.