AW: iNav sql script locking object

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Did you close the results within the second script in which you accessed the
view?
(Edit --> close all results)

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Monday, 24. January 2011 15:42
An: Midrange Systems Technical Discussion
Betreff: iNav sql script locking object

Hi all,

Had 2 sql script windows open. In W1 created my view, in W2 ran the request
using the view. The result wasn't right so I went back to W1 to correct the
view.

This was basically :

Drop myview;
Create myview as....;

On running the script, I get an error saying the view is used. WRKOBJLCK
showed 2 jobs (I assume for each sql script window). Had to close the
windows to end these jobs after first copying their contents to 2 new
windows.

What am i doing wrong?

Thanks.