Re: SQL locks entire table on INSERT?

["Patrick Townsend" <patownsend@xxxxxxxxxxxxxx>]

Vern and Alex,

Many thanks!
Patrick


----- Original Message -----
From: "Vern Hamberg" <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, May 13, 2003 5:21 AM
Subject: Re: SQL locks entire table on INSERT?


> You use SQLSetConnectOption or SQLSetConnectAttr. It's all in hte SQL Call
> Level Interface manual, q.v.
>
> Vern
>
> At 09:47 PM 5/12/2003 -0700, you wrote:
> >Hi Alex,
> >
> >The application must be using the default isolation level. Do you know
what
> >the default isolation level is for AS/400? Do you know how to change the
> >isolation level? I can find discussions of isolation level on the IBM web
> >site, but I can't see what API to call to change it.
> >
> >TIA,
> >Patrick
>
>
> _______________________________________________
> 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.
>
>