RE: iNav Sql script problem

Just perform another dummy SELECT within Run SQL Scripts to release the
previous lock...

select * from sysibm/sysdummy1;


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: 31 January 2011 09:25
To: Midrange Systems Technical Discussion
Subject: iNav Sql script problem

Hi,

On an earlier thread, I learned that pageing down after executing a
select was in fact scrolling through the cursor.

Now my irritating problem is that I've created a view. Then I do a
select on that view. Now I find that my select needs to evolve, so i
want to change the view. I cannot drop the view as the cursor is still
open from the previous select.

All I can do is copy my scripts to a new window, and close the existing
windows to liberate the cursor, then start again.

Is there a command I can use to close the cursor on the view?

Thanks