Sql string with callable statement..
How do i get a dump of a stored procedure (the exact call that is being made ).. When i use AS400JDBCCallableStatement and have a call something like
call procedureA(?,?,?) and i pass in the in and out parameters and what i need is something which gives me a dump of the sql statement something
call procedureA(val1,val2,val3) which i can then directly copy and paste it to an sql editor. i tried toString on the CallableStatement but it wouldnt work .
I am using AS400JDBCCallableStatement object and am registering the in and out parameters but was expecting either toString to give me the dump or for the CallableStatement to have a method called "dump" which dumps the actual SQL String but it did not have any.
Thx a zillion