Re: Set Lock Mode in Powerbuilder
You don't need to go through a stored procedure to set isolation level and
lock mode. You can enter
EXECUTE IMMEDIATE "whatever SQL statements that Informix recognizes";
This works for PowerBuilder 3.x, 4.x, and 5.x. I have not used 1.x and 2.x
so I can't tell about them.
Chao Y. Din
tat mun wrote:
> Hi,
> I am trying to find means to set lock mode in Powerbuilder 4 and 5.
> Okay, my configuration is as follows:
>
> Powerbuilder 4.0 PC Client using I-NET 5.0
> Informix Online Dynamic Server 7.14 on AIX machine
> Isolation level is committed read.
>
> I have tried setting lock mode to wait 30 via a stored procedure.
> Then execute this procedure in the powerbuilder application. I then
> follow this up with some other embedded as well as datawindows sql
> calls. But the SQL statement error number -244, -250, -263, ISAM error
> -107 still occur.
>
> I used the onstat -q sql statement in UNIX to check. The sql
> statment shows a NO WAIT.
>
> Does anyone have any idea how to solve this?