RE: iNav sql script locking object

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Thanks, 
No, I have it set so the results show in the same window. But there were no results anyway : I'd made a mistake in my create view statement so I got an error when I ran my select on the view. When I went back to execute drop view, create view, I found the view locked .

 

> -----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.