RE: iNav sql script locking object

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Birgitta Hauser
Envoyé : lundi 24 janvier 2011 16:23
À : 'Midrange Systems Technical Discussion'
Objet : AW: iNav sql script locking object

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.

--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.