on 08-30-2010 6:54 PM
Hi all, I need to delete records of 3 tables after the Communication Channel send the information.
The problem is I want to put the 3 sentences in the Update SQL Statement separated with ";" but it does not work.
This is my statement
DELETE from table1 WHERE field1='3';DELETE from table2 WHERE field1='3';DELETE from table3 WHERE field1='3';
This is the error in the Runtime Workbench.
Database-level error reported by JDBC driver while executing statement 'DELETE from pruebas.SAPRCTGH WHERE DGHSTS='3'.'. The JDBC driver returned the following error message: 'java.sql.SQLException: Token . was not valid. Valid tokens: <END-OF-STATEMENT>.'. For details, contact your database server vendor.
When I tested from Razor SQL it works fine, I do not know what more to change.
Regards,
Sebastián Alvarez
It's better you use a procedure in Database.
You can ask for legacy team create a procedure with all controls (three delete and more) that you need.
regards
Bruno
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all.
Thank you very much for your answers.
I'll try one thing, I'll create another Service Interface and in the Configuration Scenario create another Receiver Agreement, so the message will be sent to ECC and will "return" like inbound to delete the tables with 3 delete statements.
Thank you very much to all of you.
I'll try this and I'll tell you
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can't achieve this with single statement, you need to create 3 separate statements in PI.
SP is also an alternative.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sebastian,
You need to have 3 statements having three different Delete Actions. I'm not sure you can have it in single Statement.
Can you paste how your xml looks like after mapping?
Thanks,
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.