Re: SQL Scripts in ACS

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Or maybe an SQL "delete from filename" which will delete row by row, or 
it will do the quicker CLRPFM under the covers if it can get a lock.


On 3/23/2021 1:51 PM, Charles Wilt wrote:
> Since CLRPFM requires an exclusive lock, it doesn't play nice with SQL
> pseudo-closed cursors...
>
> Try adding a
> ALCOBJ OBJ((MYLIB/MYFILE *FILE *EXCL)) CONFLICT(*RQSRLS)
>
> Before the CLRPFM...
>
> Charles
>
> On Tue, Mar 23, 2021 at 9:37 AM Dave <dfx1@xxxxxxxxxxxxxx> wrote:
>
> > Hi all,
> >
> > I'm testing a program on an ACS 5250 emulator screen. I switch to a SQL
> > script window to view some results. When I go back to the green screen, I
> > can't continue to  test because my program is trying to do a CLRPFM and the
> > job running the SQL scripts has locks on the files that I previously
> > consulted.
> > I would have thought this was a bug. Can anyone help?