Stored procedures commits

gbtech · New User Joined: 22 Aug 2007 Posts: 3 Location: new york

Hi All,

I was asked the following on an interview:

If a client application calls a stored procedure that does an update who does a commit providing that stored procedure is not the one doing it?

Any thoughts on this are appreciated.

ashwinreddy · Posted: Fri Aug 24, 2007 11:56 pm Post subject:

Hi,

am totally confused on your question, do you intend that the store procedure is not updating the records or something else.

could you provide us more information or expand your sentence.

Cheers
Ashwin

dbzTHEdinosauer · Posted: Sat Aug 25, 2007 12:13 am Post subject:

If a client application calls a stored procedure that does an update,
who does a commit providing that stored procedure is not the one doing it? (the commit)

ashwinreddy · Posted: Sat Aug 25, 2007 12:13 am Post subject:

Hi,

I assuming your question as your Store procedure is not updating as expected.

First Check whether the DDL declarations for the store procedure are as per your requiremnt.

And if you are testing your SP (stored Procedure) using batch then check the calling program passing values (Inputs you pass) and declarations.

If everything is ok, so you have to place the display statments before execution of that SQL and after that. check the SQL code.

And remember SP can't be debugged using a Debugging tools. Only option is placing displays.

Hope this Helps

Cheers
Ashwin

socker_dad

To get back on track of your original question, I would have answered, "When the stored procedure returns control to the calling module." and prayed that I was right!

gbtech · New User Joined: 22 Aug 2007 Posts: 3 Location: new york

I have assumed from the interview question that the stored proc was called from a non-mainframe application (i.e. not from CICS where one could do a syncpoint or a batch program where one could do an exec sql commit). Then if the stored proc does an update who issues a commit?

stodolas · Posted: Sat Aug 25, 2007 4:13 am Post subject:

Doesn't the commit happen implicitly on the completion of the stored procedure?

dbzTHEdinosauer · Posted: Sat Aug 25, 2007 4:38 am Post subject:

Finally, thank you Steve............