on 05-12-2010 10:45 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.