[MySql]

[Jerry Fletcher]

Hello,

When opening a [MySql] Table with iol=* is there any way to handle locking a record?

Jerry

[EVa]

PxPlus will do that for you, but you can change the SQL syntax it uses by changing option EXTROPT (see https://manual.pvxplus.com/?command_tags/mysql.htm).  I just tried this:

Session #1:
1>print pth(1)," % ",opt(1)
[MySQL]MySQL;bitfile;KEY=KEYFIELD % ;user=root;pswd=pswd;prepare=N;strip
1>extract (1,key="05")
1>print prm('XI')
 0

Session #2:
1>print pth(1)," # ",opt(1)
[MySQL]MySQL;bitfile;KEY=KEYFIELD # ;user=root;pswd=pswd;prepare=N;strip
1>extract(1,key="05")
Error #0: Record/file busy
Last IO to [MySQL]MySQL;bitfile;KEY=KEYFIELD, channel 1
MYSQL:1205:Lock wait timeout exceeded; try restarting transaction

[Jerry Fletcher]

Hi

Thank you. that worked.
it must have been that 'XI' parameter which I dont think i can shut off across board but maybe right prior to sql extracts.

Jerry