If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Just taking a quick glance, I see that the cursor you closed doesn't reference customer_u_name. However, you're issuing multiple selects against customer_u_name without a cursor. My suggestion is to assign a specific cursor to each open of customer_u_name and then close those cursors at the end of the procedure and see if the file is closed.
Jonas Temple
Got FROG?
Got Tadpole? No, because it's not done yet! Stay tuned....
This procedure is puer sql. There is absolutely no RPG or CL . . . involved with this procedure. However, I do have SET OPTION COMMIT = *NONE in the procedure header. Unfortunately, the lock remains.
So, does this mean that you are not running the RUNSQLSTM command over a source member containing the CREATE PROCEDURE statements, and generating a CLE-type object on your System i which you can then execute from other SQL commands?
"Time passes, but sometimes it beats the <crap> out of you as it goes."
I just spent 2 hours and 11 minutes on the phone with IBM tech support. They kept telling me that I would have to send n all my tables and allow them to do a recreate of my environment. I refused and walked through the procudure statement by statement. Apparently in V5r2 there is a problem where the system does not release on object lock on a file after an ALTER command is issued with a COMMIT Level of *NONE.
The Solution was to journal the file and set the commit level to something other than *NONE.
2 hours and 11 minutes on an alter.
The lesson learned is Stick to your guns and never let the support reps off the phone.
Predictions are usually difficult, especially about the future. ~Yogi Berra
I just spent 2 hours and 11 minutes on the phone with IBM tech support. .......
The lesson learned is Stick to your guns and never let the support reps off the phone.
Way to go !!!
I keep getting "Working as designed" from IBM, and a link to submit a new feature request from their website - kind of a DIY approach to customer service ...
Comment