cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC double update?

Former Member
0 Kudos

Is It possible to update two different tables of one Database using one JDBC Sender?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Ruben,

U can do so.

I am sure that there are some threads already on this topic.

-Naveen.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

one query can be written on one table. But if you want to update 2 tables, you can write a stored procedure for it.

-Kavita

Former Member
0 Kudos

SEE THIS BLOG FOR HELP W.R.T. STORED PROCEDURES :

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Vara

[PLEASE REWARD FOR POSTING]

Former Member
0 Kudos

Hi Ruben,

You have to write a stored procedure that will do the job.

Call the stored procedure in the query statement.

In the update statement enter <TEST>

Best regards,

Bela