Sender JDBC adapter : Update SQL Statement : stored procedure

[rohit_goel]

Hi,

Can we use a stored procedure in the sender jdbc adapter in 'Update SQL Statement'.

The problem i am facing is like, we are selecting data from two tables in 'SQL statement for query' and then in 'Update SQL Statement' , we need to delete that data from these two tables.

Please let me know if it is possible.

Thanks,

Rohit

[GabrielSagaya]

1)you can use JOINS or UNIONS to access the data from mutliple tables from the DB.

2) you can use storedprocedure

[Shabarish_Nair]

you can use a Stored procedure in the

Query SQL Statement

You have the following options:

·        Specify a valid SQL SELECT statement to select the data to be sent from the specified database.

·        Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

The expression must correspond to the SQL variant supported by the relevant JDBC driver. It can also contain table JOINs.

so have your whole select and update as part of this single Stored procedure